-
公开(公告)号：US20070130116A1
公开(公告)日：2007-06-07
申请号：US11671443
申请日：2007-02-05
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/30398 , Y10S707/99932 , Y10S707/99943 , Y10S707/99944 , Y10S707/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维度中的成员访问。 根据另一方面，可以将不透明滤光片或它们的组合应用于基于分析的数据。
-
公开(公告)号：US20050015360A1
公开(公告)日：2005-01-20
申请号：US10899862
申请日：2004-07-26
CPC分类号： G06F17/30592 , G06F17/30398 , Y10S707/99932 , Y10S707/99943 , Y10S707/99944 , Y10S707/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维度中的成员访问。 根据另一方面，可以将不透明滤光片或它们的组合应用于基于分析的数据。
-
公开(公告)号：US20050080802A1
公开(公告)日：2005-04-14
申请号：US11000597
申请日：2004-11-30
CPC分类号： G06F17/30398 , G06F17/30395 , G06F17/30592 , Y10S707/99943 , Y10S715/968
摘要： An analytical reporting functionality provides full-fledged dynamic reporting capabilities on top of a multidimensional data model. A GUI facilitates replicating the same reporting data for various elements of a dimension. Additionally, direct interaction with the report to perform OLAP-style is enabled.
摘要翻译： 分析报告功能在多维数据模型之上提供完整的动态报告功能。 GUI便于为维度的各种元素复制相同的报告数据。 此外，启用与执行OLAP风格的报表的直接交互。
-
公开(公告)号：US06768986B2
公开(公告)日：2004-07-27
申请号：US09826425
申请日：2001-04-03
IPC分类号： G06F1730
CPC分类号： G06F17/30592 , G06F17/30398 , Y10S707/99932 , Y10S707/99943 , Y10S707/99944 , Y10S707/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维度中的成员访问。 根据另一方面，可以将不透明滤光片或它们的组合应用于基于分析的数据。
-
公开(公告)号：US07664777B2
公开(公告)日：2010-02-16
申请号：US11671443
申请日：2007-02-05
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/30398 , Y10S707/99932 , Y10S707/99943 , Y10S707/99944 , Y10S707/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维度中的成员访问。 根据另一方面，可以将不透明滤光片或它们的组合应用于基于分析的数据。
-
公开(公告)号：US06831668B2
公开(公告)日：2004-12-14
申请号：US09824654
申请日：2001-04-03
IPC分类号： G06F300
CPC分类号： G06F17/30398 , G06F17/30395 , G06F17/30592 , Y10S707/99943 , Y10S715/968
摘要： An analytical reporting functionality provides full-fledged dynamic reporting capabilities on top of a multidimensional data model. A GUI facilitates replicating the same reporting data for various elements of a dimension. Additionally, direct interaction with the report to perform OLAP-style is enabled.
摘要翻译： 分析报告功能在多维数据模型之上提供完整的动态报告功能。 GUI便于为维度的各种元素复制相同的报告数据。 此外，启用与执行OLAP风格的报表的直接交互。
-
公开(公告)号：US07945597B2
公开(公告)日：2011-05-17
申请号：US11563601
申请日：2006-11-27
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/30398 , Y10S707/917 , Y10S707/957 , Y10S707/958 , Y10S707/96 , Y10S707/99933 , Y10S707/99944 , Y10S707/99945
摘要： A system and a method for creating an analytical report on top of a multidimensional data model built on top of a relational or multidimensional database. The database operates in a computer system and provides returned values responsive to queries. Such a query is generated automatically and is deduced from a report definition. According to one embodiment, a report specification is used by the system and method of the present invention is able to defer the initial query of the data source, as is the case with conventional reporting tools and methods, until after the report has been defined. That is, the manner in which a analytic report is defined provides for an automatically generated query. Once the report has been defined, the data to populate such a report is retrieved to build the document.
摘要翻译： 一种建立在关系型或多维数据库之上的多维数据模型之上的分析报告的系统和方法。 数据库在计算机系统中运行，并提供响应于查询的返回值。 这样的查询是自动生成的，并从报表定义中推导出来。 根据一个实施例，系统使用报告规范，并且本发明的方法能够延迟数据源的初始查询，如常规报告工具和方法的情况，直到定义报告为止。 也就是说，定义分析报告的方式提供了自动生成的查询。 报告定义完成后，将检索填写此类报告的数据以构建文档。
-
公开(公告)号：US07356779B2
公开(公告)日：2008-04-08
申请号：US11000597
申请日：2004-11-30
IPC分类号： G06F3/00
CPC分类号： G06F17/30398 , G06F17/30395 , G06F17/30592 , Y10S707/99943 , Y10S715/968
摘要： An analytical reporting functionality provides full-fledged dynamic reporting capabilities on top of a multidimensional data model. A GUI facilitates replicating the same reporting data for various elements of a dimension. Additionally, direct interaction with the report to perform OLAP-style is enabled.
摘要翻译： 分析报告功能在多维数据模型之上提供完整的动态报告功能。 GUI便于为维度的各种元素复制相同的报告数据。 此外，启用与执行OLAP风格的报表的直接交互。
-
公开(公告)号：US07222130B1
公开(公告)日：2007-05-22
申请号：US10673090
申请日：2003-09-26
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/30398 , Y10S707/917 , Y10S707/957 , Y10S707/958 , Y10S707/96 , Y10S707/99933 , Y10S707/99944 , Y10S707/99945
摘要： A system and a method for creating an analytical report on top of a multidimensional data model built on top of a relational or multidimensional database. The database operates in a computer system and provides returned values responsive to queries. Such a query is generated automatically and is deduced from a report definition. According to one embodiment, a report specification is used by the system and method of the present invention is able to defer the initial query of the data source, as is the case with conventional reporting tools and methods, until after the report has been defined. That is, the manner in which a analytic report is defined provides for an automatically generated query. Once the report has been defined, the data to populate such a report is retrieved to build the document.
摘要翻译： 一种建立在关系型或多维数据库之上的多维数据模型之上的分析报告的系统和方法。 数据库在计算机系统中运行，并提供响应于查询的返回值。 这样的查询是自动生成的，并从报表定义中推导出来。 根据一个实施例，系统使用报告规范，并且本发明的方法能够延迟数据源的初始查询，如常规报告工具和方法的情况，直到定义报告为止。 也就是说，定义分析报告的方式提供了自动生成的查询。 报告定义完成后，将检索填写此类报告的数据以构建文档。
-
公开(公告)号：US20070088689A1
公开(公告)日：2007-04-19
申请号：US11563601
申请日：2006-11-27
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/30398 , Y10S707/917 , Y10S707/957 , Y10S707/958 , Y10S707/96 , Y10S707/99933 , Y10S707/99944 , Y10S707/99945
摘要： A system and a method for creating an analytical report on top of a multidimensional data model built on top of a relational or multidimensional database. The database operates in a computer system and provides returned values responsive to queries. Such a query is generated automatically and is deduced from a report definition. According to one embodiment, a report specification is used by the system and method of the present invention is able to defer the initial query of the data source, as is the case with conventional reporting tools and methods, until after the report has been defined. That is, the manner in which a analytic report is defined provides for an automatically generated query. Once the report has been defined, the data to populate such a report is retrieved to build the document.
摘要翻译： 一种建立在关系型或多维数据库之上的多维数据模型之上的分析报告的系统和方法。 数据库在计算机系统中运行，并提供响应于查询的返回值。 这样的查询是自动生成的，并从报表定义中推导出来。 根据一个实施例，系统使用报告规范，并且本发明的方法能够延迟数据源的初始查询，如常规报告工具和方法的情况，直到定义报告为止。 也就是说，定义分析报告的方式提供了自动生成的查询。 报告定义完成后，将检索填写此类报告的数据以构建文档。
-
-
-
-
-
-
-
-
-
搜索结果
11 条记录 (耗时 0.012 秒)