专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US06546395B1 Multi-dimensional restructure performance by selecting a technique to modify a relational database based on a type of restructure 有权
标题翻译：通过选择一种基于重组类型修改关系数据库的技术来实现多维度的重组性能
公开(公告)号：US06546395B1
公开(公告)日：2003-04-08
申请号：US09385317
申请日：1999-08-30
申请人： Daniel Martin DeKimpe , William Earl Malloy , Khiem Phu Pham , Craig Reginald Tomlyn
发明人： Daniel Martin DeKimpe , William Earl Malloy , Khiem Phu Pham , Craig Reginald Tomlyn
IPC分类号： G06F1730
CPC分类号： G06F17/30592 , Y10S707/99942
摘要： A method, apparatus, and article of manufacture for improving multi-dimensional restructure performance by selecting a technique to modify a relational database based on a type of restructure. A command is executed in a computer to perform a database operation on a relational database stored on a data store connected to the computer. It is determined that a multi-dimensional database has been modified. Modifications to one or more original tables in a relational database corresponding to the multi-dimensional database are identified. A technique for modifying the relational database to correspond to the multidimensional database is selected based on the identified modifications.
摘要翻译：一种用于通过基于重组类型选择修改关系数据库的技术来改善多维重组性能的方法，装置和制品。在计算机中执行命令以对存储在连接到计算机的数据存储器上的关系数据库执行数据库操作。确定已经修改了多维数据库。识别对应于多维数据库的关系数据库中的一个或多个原始表的修改。基于所识别的修改来选择用于修改关系数据库以对应于多维数据库的技术。

2. 发明授权

US5943668A Relational emulation of a multi-dimensional database 失效
标题翻译：使用多维成员标识符存储和访问关系数据库中的多维数据块
公开(公告)号：US5943668A
公开(公告)日：1999-08-24
申请号：US885417
申请日：1997-06-30
申请人： William Earl Malloy , Simon Edward Moore , Gary Robinson , Craig Reginald Tomlyn
发明人： William Earl Malloy , Simon Edward Moore , Gary Robinson , Craig Reginald Tomlyn
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99943 , Y10S707/99945
摘要： A method, apparatus, and article of manufacture for using a relational database management system to support on-line analytical processing (OLAP) systems. A multi-dimensional database is defined having a set of multi-dimensional data blocks and a set of identifiers comprising selected dimensions of multi-dimensional data for identifying particular ones of the multi-dimensional data blocks. The set of identifiers provides an ordering of the multi-dimensional data blocks using multi-dimensional member identifiers and holds usage information and age information about the multi-dimensional data blocks. The data in the set of multi-dimensional data blocks is stored in a relational database that represents the multi-dimensional database. Then, a set of rows representing a multi-dimensional data block is accessed from the relational database.
摘要翻译：一种使用关系数据库管理系统来支持在线分析处理（OLAP）系统的方法，装置和制品。定义多维数据库具有一组多维数据块和一组标识符，其包括用于识别多维数据块中的特定数据块的多维数据的选定维度。所述标识符集使用多维成员标识符提供多维数据块的排序，并且保存关于多维数据块的使用信息和年龄信息。多维数据块集合中的数据被存储在表示多维数据库的关系数据库中。然后，从关系数据库访问表示多维数据块的一组行。

3. 发明授权

US5940818A Attribute-based access for multi-dimensional databases 失效
标题翻译：多维数据库的基于属性的访问
公开(公告)号：US5940818A
公开(公告)日：1999-08-17
申请号：US885410
申请日：1997-06-30
申请人： William Earl Malloy , Craig Reginald Tomlyn
发明人： William Earl Malloy , Craig Reginald Tomlyn
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , Y10S707/99932 , Y10S707/99933
摘要： A method, apparatus, and article of manufacture for using a relational database management system to support on-line analytical processing (OLAP) systems. A multi-dimensional database is represented as a relational schema in the relational database. The multi-dimensional database has one or more dimensions having one or more members. Each value in the multi-dimensional database is identified by the intersection of one member from each dimension. The relational schema includes a fact table and related dimension tables. The fact table has a dimension column for all but one of the dimensions of the multi-dimensional database and a value column for each member of the remaining dimension. The fact table has at least one row that contains the values corresponding to the intersection of the members identified by the dimension columns and the members associated with the value columns. Each dimension table has a row for each member of a dimension. At least one dimension table has one or more attribute columns for holding attribute values for members defined by the dimension table.
摘要翻译：一种使用关系数据库管理系统来支持在线分析处理（OLAP）系统的方法，装置和制品。多维数据库在关系数据库中表示为关系模式。多维数据库具有具有一个或多个成员的一个或多个维度。多维数据库中的每个值由一个成员从每个维度的交集来标识。关系模式包括事实表和相关维度表。事实表具有除多维数据库的所有维度以外的所有维的维度列和剩余维度的每个成员的值列。事实表至少包含一行，其中包含与维列相关联的成员与与值列相关联的成员的交集相对应的值。每个维度表都有一个维度的每个成员的行。至少一个维度表具有一个或多个属性列，用于保存由维度表定义的成员的属性值。

4. 发明授权

US5926818A Relational database implementation of a multi-dimensional database 失效
标题翻译：多维数据库的关系数据库实现
公开(公告)号：US5926818A
公开(公告)日：1999-07-20
申请号：US884696
申请日：1997-06-30
申请人： William Earl Malloy
发明人： William Earl Malloy
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , Y10S707/99942
摘要： A method, apparatus, and article of manufacture for using a relational database management system to support on-line analytical processing (OLAP) systems. A multi-dimensional database is represented as a relational schema in the relational database. The multi-dimensional database has one or more dimensions. Each dimension has one or more members. The relational schema includes a fact table and one or more related dimension tables. Additionally, the fact table has a dimension column for all but one of the dimensions of the multi-dimensional database and a value column for each member of the remaining dimension. The fact table also has at least one row that contains values corresponding to the intersection of the members identified by the dimension columns and the members associated with the value columns.
摘要翻译：一种使用关系数据库管理系统来支持在线分析处理（OLAP）系统的方法，装置和制品。多维数据库在关系数据库中表示为关系模式。多维数据库具有一个或多个维度。每个维度都有一个或多个成员。关系模式包括事实表和一个或多个相关维度表。此外，事实表具有除多维度数据库中的所有维度以外的所有维度的维度列和剩余维度的每个成员的值列。事实表还包含至少一行，其中包含对应于由维度列标识的成员与与值列相关联的成员的交集的值。

5. 发明授权

US5905985A Relational database modifications based on multi-dimensional database modifications 失效
标题翻译：基于多维数据库修改的关系数据库修改
公开(公告)号：US5905985A
公开(公告)日：1999-05-18
申请号：US884695
申请日：1997-06-30
申请人： William Earl Malloy , Craig Reginald Tomlyn
发明人： William Earl Malloy , Craig Reginald Tomlyn
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , Y10S707/99942 , Y10S707/99943
摘要： A method, apparatus, and article of manufacture for using a relational database management system to support on-line analytical processing (OLAP) systems. A relational schema is defined from a multi-dimensional database definition. The multi-dimensional database definition has one or more dimensions having one or more members. The relational schema includes a fact table and related dimension tables. The fact table has a dimension column for all but one of the dimensions of the multi-dimensional database and a value column for each member of the remaining dimension. The fact table has one or more rows that contain values corresponding to the intersection of the members identified by the dimension columns and the members associated with the value columns. Each dimension table has a row for each member of a dimension. Each row of each dimension table includes a multi-dimensional member identifier and a relational member identifier. A relational database is created based on the defined relational schema. Rows are accessed from the relational database using the multi-dimensional member identifiers by joining the dimension tables to the fact table through the relational member identifiers.
摘要翻译：一种使用关系数据库管理系统来支持在线分析处理（OLAP）系统的方法，装置和制品。关系模式是从多维数据库定义定义的。多维数据库定义具有一个或多个具有一个或多个成员的维度。关系模式包括事实表和相关维度表。事实表具有除多维数据库的所有维度以外的所有维的维度列和剩余维度的每个成员的值列。事实表具有一行或多行，其中包含与由维列相关联的成员与与值列相关联的成员的交集相对应的值。每个维度表都有一个维度的每个成员的行。每个维度表的每行包括多维成员标识符和关系成员标识符。基于定义的关系模式创建关系数据库。通过关联成员标识符将维度表连接到事实表，通过使用多维成员标识符从关系数据库访问行。

6. 发明授权

US07953694B2 Method, system, and program for specifying multidimensional calculations for a relational OLAP engine 有权
标题翻译：用于为关系型OLAP引擎指定多维计算的方法，系统和程序
公开(公告)号：US07953694B2
公开(公告)日：2011-05-31
申请号：US10341763
申请日：2003-01-13
申请人： Nathan Gevaerd Colossi , William Earl Malloy , Mir Hamid Pirahesh , Craig Reginald Tomlyn
发明人： Nathan Gevaerd Colossi , William Earl Malloy , Mir Hamid Pirahesh , Craig Reginald Tomlyn
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30592
摘要： Provided is a system, method, and program for specifying multidimensional calculations. Selection of a subset of a cube model metadata object that is generated from a facts metadata object and one or more dimension metadata objects is received. The facts metadata object references one or more measure metadata objects. A statement is generated for retrieving multidimensional information using metadata in the cube model metadata object and the measure metadata objects, wherein each of the measure metadata objects specifies one or more aggregations.
摘要翻译：提供了用于指定多维计算的系统，方法和程序。接收从事实元数据对象和一个或多个维元数据对象生成的多维数据集模型元数据对象的子集的选择。事实元数据对象引用一个或多个度量元数据对象。生成用于使用多维数据集模型元数据对象和度量元数据对象中的元数据来检索多维信息的语句，其中每个度量元数据对象指定一个或多个聚合。

7. 发明授权

US06754734B2 Systems, methods, and computer program products to improve performance of ported applications, such as a database 有权
标题翻译：系统，方法和计算机程序产品，以提高移植应用程序（如数据库）的性能
公开(公告)号：US06754734B2
公开(公告)日：2004-06-22
申请号：US10033810
申请日：2001-12-18
申请人： David Harold Goode , William Earl Malloy
发明人： David Harold Goode , William Earl Malloy
IPC分类号： G06F1328
CPC分类号： G06F3/0601 , G06F2003/0697 , Y10S707/99932
摘要： Systems, methods, and computer products that improve the performance of computer-implemented I/O operations for complex applications, such as a database, that are ported to target computer systems that are not tailored to support the high-performance services that may benefit applications. Complex applications, such as a database, often manage I/O access operations by a caching mechanism that is tailored to the needs of the application. When porting an application to a target computer system that does not support certain I/O access features, I/O performance of the application may be limited. The present invention may be implemented by introducing specialized I/O access features that are tailored to enhance I/O access performance for complex applications, such as a database.
摘要翻译：系统，方法和计算机产品，可以提高计算机实现的I / O操作的性能，这些复杂应用程序（例如数据库）被移植到目标计算机系统上，这些计算机系统不适合支持可能有益于应用程序的高性能服务。复杂的应用程序（如数据库）通常可以通过针对应用程序需求定制的缓存机制来管理I / O访问操作。当将应用程序移植到不支持某些I / O访问功能的目标计算机系统时，应用程序的I / O性能可能受到限制。本发明可以通过引入专门的I / O访问特征来实现，该功能被定制以增强诸如数据库之类的复杂应用的I / O访问性能。

8. 发明授权

US06480848B1 Extension of data definition language (DDL) capabilities for relational databases for applications issuing DML and DDL statements 失效
标题翻译：扩展用于发布DML和DDL语句的应用程序的关系数据库的数据定义语言（DDL）功能
公开(公告)号：US06480848B1
公开(公告)日：2002-11-12
申请号：US09356059
申请日：1999-07-19
申请人： Daniel Martin DeKimpe , William Earl Malloy , Craig Reginald Tomlyn
发明人： Daniel Martin DeKimpe , William Earl Malloy , Craig Reginald Tomlyn
IPC分类号： G06F1730
CPC分类号： G06F17/30595 , Y10S707/954 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99937 , Y10S707/99938
摘要： A method, apparatus, and article of manufacture for DDL Extension layer that provides extended data definition language (DDL) capabilities for relational databases with multi-connections. A plurality of commands comprising data definition language statements and data modification language statements may be received from an application. Then, separate database connections for processing the data definition language statements and the data modification language statements are generated.
摘要翻译： DDL扩展层的方法，设备和制造工具，为具有多连接的关系数据库提供扩展数据定义语言（DDL）功能。可以从应用程序接收包括数据定义语言语句和数据修改语言语句的多个命令。然后，生成用于处理数据定义语言语句和数据修改语言语句的单独的数据库连接。

9. 发明申请

US20090063403A1 SYSTEMS AND COMPUTER PROGRAM PRODUCTS TO IDENTIFY RELATED DATA IN A MULTIDIMENSIONAL DATABASE 失效
标题翻译：系统和计算机程序产品识别多维数据库中的相关数据
公开(公告)号：US20090063403A1
公开(公告)日：2009-03-05
申请号：US12264891
申请日：2008-11-04
申请人： William Earl Malloy , Ken Qian Pu
发明人： William Earl Malloy , Ken Qian Pu
IPC分类号： G06F17/30
CPC分类号： G06F17/30333 , Y10S707/957 , Y10S707/958 , Y10S707/99936 , Y10S707/99942 , Y10S707/99943 , Y10S707/99945
摘要： Systems and computer program products that identify data that is related to and associated with data that has been selected from a multidimensional database. The overwhelming amount of data in a multidimensional database that may be viewed by a user, such as a data analyst, is reduced to the selected and associated data by use of index data and related index data, according to the present invention. The views of selected data and related data may be highlighted and formatted for presentation to the user. Further, irrelevant data is filtered out and not presented to the user. Existing systems have not been able to efficiently and adequately identify data that is related to and associated with selected data in a multidimensional database.
摘要翻译：识别与从多维数据库中选择的数据相关并与之相关联的数据的系统和计算机程序产品。根据本发明，通过使用索引数据和相关索引数据，可以由诸如数据分析者的用户观看的多维数据库中的压倒性数据量被减少到所选择的和相关联的数据。所选数据和相关数据的视图可以被突出显示和格式化以呈现给用户。此外，不相关的数据被过滤掉并且不呈现给用户。现有系统无法有效和充分地识别与多维数据库中的所选数据相关并与之相关联的数据。

10. 发明授权

US07472127B2 Methods to identify related data in a multidimensional database 失效
标题翻译：在多维数据库中识别相关数据的方法
公开(公告)号：US07472127B2
公开(公告)日：2008-12-30
申请号：US10325299
申请日：2002-12-18
申请人： William Earl Malloy , Ken Qian Pu
发明人： William Earl Malloy , Ken Qian Pu
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30333 , Y10S707/957 , Y10S707/958 , Y10S707/99936 , Y10S707/99942 , Y10S707/99943 , Y10S707/99945
摘要： Methods that identify data that is related to and associated with data that has been selected from a multidimensional database. The overwhelming amount of data in a multidimensional database that may be viewed by a user, such as a data analyst, is reduced to the selected and associated data by use of index data and related index data, according to the present invention. The views of selected data and related data may be highlighted and formatted for presentation to the user. Further, irrelevant data is filtered out and not presented to the user. Existing systems have not been able to efficiently and adequately identify data that is related to and associated with selected data in a multidimensional database.
摘要翻译：识别与从多维数据库中选择的数据相关联的数据的方法。根据本发明，通过使用索引数据和相关索引数据，可以由诸如数据分析者的用户观看的多维数据库中的压倒性数据量被减少到所选择的和相关联的数据。所选数据和相关数据的视图可以被突出显示和格式化以呈现给用户。此外，不相关的数据被过滤掉并且不呈现给用户。现有系统无法有效和充分地识别与多维数据库中的所选数据相关并与之相关联的数据。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式