会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 3. 发明授权
    • Mapping of an RDBMS schema onto a multidimensional data model
    • 将RDBMS模式映射到多维数据模型
    • US07664777B2
    • 2010-02-16
    • US11671443
    • 2007-02-05
    • Jean-Yves CrasHenri BiestroRicardo Polo-Malouvier
    • Jean-Yves CrasHenri BiestroRicardo Polo-Malouvier
    • G06F17/30
    • G06F17/30592G06F17/30398Y10S707/99932Y10S707/99943Y10S707/99944Y10S707/99945
    • A Relational Database Management System (RDBMS) having any arbitrary structure is translated into a multi-dimensional data model suitable for performing OLAP operations upon. If a relational table defining the relational model includes any tables with cardinality of 1,1 or 0,1, the tables are merged into a single table. If the relational table is not normalized, then normalization is performed and a relationship between the original table and the normalized table is created. If the relational table is normalized, but not by dependence between columns, such as in the dimension table in a snowflake schema, the normalization process is performed using the foreign key in order to generate the normalized table. Once the normalized table is generated, OLAP measures are derived from the normalized relational table by an automated method. In addition, OLAP dimensions are derived from the normalized relational table and the results of the OLAP measures derivation by an automated method according to the present invention. According to an aspect, it is possible to associate a member of a dimension to another member of the same or another dimension. According to another aspect, it is possible to create a new dimension of analysis, the members of which are all the different values that a scalar expression can take on. According to yet another aspect, it is possible to access the various instances of a Reporting Object as members in an OLAP dimension. According to the yet another aspect, it is possible to apply opaque filters or a combination of them to the data that underlies analysis.
    • 具有任意结构的关系数据库管理系统(RDBMS)被翻译成适用于执行OLAP操作的多维数据模型。 如果定义关系模型的关系表包含基数为1,1或0,1的任何表,则表被合并到单个表中。 如果关系表未被归一化,则执行归一化,并且创建原始表与归一化表之间的关系。 如果关系表被归一化,而不是列之间的依赖,例如在雪花模式的维度表中,则使用外键执行归一化过程以生成归一化表。 一旦生成了规范化表,就可以通过自动化方法从归一化关系表导出OLAP度量。 另外,从归一化关系表导出OLAP维度,并且通过根据本发明的自动化方法推导OLAP测量结果。 根据一个方面,可以将尺寸的构件与相同或另一维度的另一个构件相关联。 根据另一方面,可以创建分析的新维度,其成员是标量表达式可以承担的所有不同的值。 根据另一方面,可以将报告对象的各种实例作为OLAP维度中的成员访问。 根据另一方面,可以将不透明滤光片或它们的组合应用于基于分析的数据。
    • 5. 发明申请
    • COLLABORATIVELY ENHANCING BUSINESS INTELLIGENCE MODELS
    • 协同增强业务智能模型
    • US20150106300A1
    • 2015-04-16
    • US14050994
    • 2013-10-10
    • Bruno DumantAlexis NaiboJean-Yves Cras
    • Bruno DumantAlexis NaiboJean-Yves Cras
    • G06Q10/06
    • G06Q10/067
    • The present disclosure relates to a computer-implemented method including identifying a predefined business intelligence model associated with a database, the predefined business intelligence model including one or more entities defining a structured organization of data and the predefined business intelligence model is adapted to access data from the database, identifying an enhanced business intelligence model based on the predefined business intelligence model, the enhanced business intelligence model incorporating by reference one or more entities of the predefined business intelligence model and providing the enhanced business intelligence model for accessing data from the database, accessing data from the database including using the one or more entities incorporated by reference in the enhanced business intelligence model, the predefined business intelligence model being unchanged.
    • 本公开涉及一种计算机实现的方法,包括识别与数据库相关联的预定商业智能模型,所述预定商业智能模型包括定义数据结构化组织的一个或多个实体,并且所述预定商业智能模型适于从 数据库,基于预定义的商业智能模型识别增强的商业智能模型,增强的商业智能模型通过引用将预定义的商业智能模型的一个或多个实体并入,并且提供用于从数据库访问数据的增强的商业智能模型,访问 来自数据库的数据,包括使用在增强商业智能模型中通过引用并入的一个或多个实体,预定义的商业智能模型不变。