会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 9. 发明授权
    • 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维度中的成员访问。 根据另一方面,可以将不透明滤光片或它们的组合应用于基于分析的数据。