Relational emulation of a multi-dimensional database
First Claim
1. A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, the method comprising the steps of:
- (a) defining a multi-dimensional database 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, wherein 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;
(b) storing the data in the set of multi-dimensional data blocks in a relational database, wherein the relational database represents the multi-dimensional database;
(c) accessing a set of rows representing a multi-dimensional data block from the relational database after receiving a multi-dimensional member identifier and determining a corresponding relational member identifier.
1 Assignment
0 Petitions
Accused Products
Abstract
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.
125 Citations
6 Claims
-
1. A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, the method comprising the steps of:
-
(a) defining a multi-dimensional database 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, wherein 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; (b) storing the data in the set of multi-dimensional data blocks in a relational database, wherein the relational database represents the multi-dimensional database; (c) accessing a set of rows representing a multi-dimensional data block from the relational database after receiving a multi-dimensional member identifier and determining a corresponding relational member identifier.
-
-
2. A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, the method comprising the steps of:
-
(a) defining a multi-dimensional database 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, wherein 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; (b) storing the data in the set of multi-dimensional data blocks in a relational database, wherein the relational database represents the multi-dimensional database; and (c) accessing a set of rows representing a multi-dimensional data block from the relational database; (d) receiving a relational member identifier; and (e) determining a corresponding multi-dimensional member identifier.
-
-
3. An apparatus for executing a command to perform a database operation on a relational database, comprising:
-
(a) a computer having a data storage device coupled thereto, wherein the data storage device stores the relational database; (b) one or more computer programs, performed by the computer, for defining a multi-dimensional database 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, wherein 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, for storing the data in the set of multi-dimensional data blocks in a relational database, wherein the relational database represents the multi-dimensional database, and for accessing a set of rows representing a multi-dimensional data block from the relational database after receiving a multi-dimensional member identifier and determining a corresponding relational member identifier.
-
-
4. An apparatus for executing a command to perform a database operation on a relational database, comprising:
-
(a) a computer having a data storage device coupled thereto, wherein the data storage device stores the relational database; (b) one or more computer programs, performed by the computer, for defining a multi-dimensional database 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, wherein 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, for storing the data in the set of multi-dimensional data blocks in a relational database, wherein the relational database represents the multi-dimensional database, for accessing a set of rows representing a multi-dimensional data block from the relational database, for receiving a relational member identifier and for determining a corresponding multi-dimensional member identifier.
-
-
5. An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing a command to perform a database operation on a relational database stored on a data storage device, the method comprising the steps of:
-
(a) defining a multi-dimensional database 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, wherein 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; (b) storing the data in the set of multi-dimensional data blocks in a relational database, wherein the relational database represents the multi-dimensional database; and (c) accessing a set of rows representing a multi-dimensional data block from the relational database after receiving a multi-dimensional member identifier and determining a corresponding relational member identifier.
-
-
6. An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing a command to perform a database operation on a relational database stored on a data storage device, the method comprising the steps of:
-
(a) defining a multi-dimensional database 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, wherein 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; (b) storing the data in the set of multi-dimensional data blocks in a relational database, wherein the relational database represents the multi-dimensional database; (c) accessing a set of rows representing a multi-dimensional data block from the relational database; (d) receiving a relational member identifier; and (e) determining a corresponding multi-dimensional member identifier.
-
Specification