US5978796A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Accessing multi-dimensional data by mapping dense data blocks to rows in a relational database
Assignee: International Business Machines Corp
•
Filing: 1997-06-30
•
Granted: 1999-11-02
•
Expires: 2017-06-30
Abstract
Abstract A method, apparatus, and article of manufacture for using a relational database management system to support on-line analytical processing (OLAP) systems. A relational database has a fact table and at least one related dimension table. A dimension identifier is received that identifies a data block in a multi-dimensional database. The dimension identifier comprises one or more multi-dimensional member identifiers. Rows are accessed from the fact table through the related dimension tables using the received dimension identifier. Then, the accessed rows are formatted as a data block for the multi-dimensional database.
Inventors
- 👤 William Earl Malloy
- 👤 Gary Robinson
- 👤 Craig Reginald Tomlyn
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 00:51
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/283; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933
Claims Analysis
Total Claims: 48
Claim 1
Independent Claim
142 words
A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables, the method comprising the steps of: (a) receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers; and (b) accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein one of the dimension tables is an anchor dimension table that does not intersect the fact table with a common column and the remaining dimension tables are non-anchor dimension tables that intersect the fact table with common columns.
Claim 2
Independent Claim
142 words
A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables, the method comprising the steps of: (a) receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers; and (b) accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein one of the dimension tables is an anchor dimension table that does not intersect the fact table with a common column and the remaining dimension tables are non-anchor dimension tables that intersect the fact table with common columns.
Claim 3
Dependent Claim
23 words
The method of claim 1 above, further comprising the step of formatting the accessed rows as a data block for the multi-dimensional database.
Claim 4
Dependent Claim
27 words
The method of claim 1 above, wherein the step of accessing rows further comprises the step of mapping the identified multi-dimensional member identifiers to relational member identifiers.
Claim 5
Independent Claim
147 words
A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block; accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein the accessed rows contain values; determining an offset into the data block using the multi-dimensional member identifiers; and storing the values contained in the accessed rows into the data block at the determined offset.
Claim 6
Independent Claim
147 words
A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block; accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein the accessed rows contain values; determining an offset into the data block using the multi-dimensional member identifiers; and storing the values contained in the accessed rows into the data block at the determined offset.
Claim 7
Independent Claim
154 words
A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block, and wherein the data block contains values; accessing rows from the fact table through the related dimension tables using the received dimension identifier; determining an offset into the data block using the multi-dimensional member identifiers; accessing the values contained in the data block at the determined offset; and storing the accessed values in rows of the relational database.
Claim 8
Independent Claim
154 words
A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block, and wherein the data block contains values; accessing rows from the fact table through the related dimension tables using the received dimension identifier; determining an offset into the data block using the multi-dimensional member identifiers; accessing the values contained in the data block at the determined offset; and storing the accessed values in rows of the relational database.
Claim 9
Independent Claim
101 words
A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, wherein the relational database has a fact table and at least one related dimension table, the method comprising the steps of: (a) receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers; (b) accessing rows from the fact table through the related dimension tables using the received dimension identifier; and (c) formatting the accessed rows as a data block for the multi-dimensional database.
Claim 10
Independent Claim
101 words
A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, wherein the relational database has a fact table and at least one related dimension table, the method comprising the steps of: (a) receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers; (b) accessing rows from the fact table through the related dimension tables using the received dimension identifier; and (c) formatting the accessed rows as a data block for the multi-dimensional database.
Claim 11
Dependent Claim
26 words
The method of claim 6 above, wherein the relational database has relational member identifiers for accessing data from the fact table through the related dimension tables.
Claim 12
Dependent Claim
27 words
The method of claim 7 above, wherein the step of accessing rows further comprises the step of mapping the identified multi-dimensional member identifiers to relational member identifiers.
Claim 13
Independent Claim
144 words
A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, wherein the relational database has a fact table and at least one related dimension table, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block; accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein the accessed rows contain values; formatting the accessed rows as a data block for the multi-dimensional database; determining an offset into the data block using the multi-dimensional member identifiers; and storing the values contained in the accessed rows into the data block at the determined offset.
Claim 14
Independent Claim
144 words
A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, wherein the relational database has a fact table and at least one related dimension table, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block; accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein the accessed rows contain values; formatting the accessed rows as a data block for the multi-dimensional database; determining an offset into the data block using the multi-dimensional member identifiers; and storing the values contained in the accessed rows into the data block at the determined offset.
Claim 15
Independent Claim
152 words
A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, wherein the relational database has a fact table and at least one related dimension table, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers wherein the multi-dimensional member identifiers identify an offset into the data block, and wherein the data block contains values; accessing rows from the fact table through the related dimension tables using the received dimension identifier; and formatting the accessed rows as a data block for the multi-dimensional database; determining an offset into the data block using the multi-dimensional member identifiers; accessing the values contained in the data block at the determined offset; and storing the accessed values in rows of the relational database.
Claim 16
Independent Claim
152 words
A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, wherein the relational database has a fact table and at least one related dimension table, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers wherein the multi-dimensional member identifiers identify an offset into the data block, and wherein the data block contains values; accessing rows from the fact table through the related dimension tables using the received dimension identifier; and formatting the accessed rows as a data block for the multi-dimensional database; determining an offset into the data block using the multi-dimensional member identifiers; accessing the values contained in the data block at the determined offset; and storing the accessed values in rows of the relational database.
Claim 17
Independent Claim
158 words
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, and wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables; (b) one or more computer programs, performed by the computer, for receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers and for accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein one of the dimension tables is an anchor dimension table that does not intersect the fact table with a common column and the remaining dimension tables are non-anchor dimension tables that intersect the fact table with common columns.
Claim 18
Independent Claim
158 words
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, and wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables; (b) one or more computer programs, performed by the computer, for receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers and for accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein one of the dimension tables is an anchor dimension table that does not intersect the fact table with a common column and the remaining dimension tables are non-anchor dimension tables that intersect the fact table with common columns.
Claim 19
Dependent Claim
22 words
The apparatus of claim 11 above, further comprising means for formatting the accessed rows as a data block for the multi-dimensional database.
Claim 20
Dependent Claim
26 words
The apparatus of claim 11 above, wherein the means for accessing rows further comprises means for mapping the identified multi-dimensional member identifiers to relational member identifiers.
Claim 21
Independent Claim
165 words
An apparatus for executing a command to perform a database operation on a relational database, comprising: a computer having a data storage device coupled thereto, wherein the data storage device stores the relational database, and wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables; one or more computer programs, performed by the computer, for receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block, for accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein the accessed rows contain values, for determining an offset into the data block using the multi-dimensional member identifiers, and for storing the values contained in the accessed rows into the data block at the determined offset.
Claim 22
Independent Claim
165 words
An apparatus for executing a command to perform a database operation on a relational database, comprising: a computer having a data storage device coupled thereto, wherein the data storage device stores the relational database, and wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables; one or more computer programs, performed by the computer, for receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block, for accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein the accessed rows contain values, for determining an offset into the data block using the multi-dimensional member identifiers, and for storing the values contained in the accessed rows into the data block at the determined offset.
Claim 23
Independent Claim
175 words
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, and wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables; (b) one or more computer programs, performed by the computer, for receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block, and wherein the data block contains values, for accessing rows from the fact table through the related dimension tables using the received dimension identifier, for determining an offset into the data block using the multi-dimensional member identifiers, for accessing the values contained in the data block at the determined offset, and for storing the accessed values in rows of the relational database.
Claim 24
Independent Claim
175 words
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, and wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables; (b) one or more computer programs, performed by the computer, for receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block, and wherein the data block contains values, for accessing rows from the fact table through the related dimension tables using the received dimension identifier, for determining an offset into the data block using the multi-dimensional member identifiers, for accessing the values contained in the data block at the determined offset, and for storing the accessed values in rows of the relational database.
Claim 25
Independent Claim
115 words
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, and wherein the relational database has a fact table and at least one related dimension table; (b) one or more computer programs, performed by the computer, for receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, accessing rows from the fact table through the related dimension tables using the received dimension identifier, and formatting the accessed rows as a data block for the multi-dimensional database.
Claim 26
Independent Claim
115 words
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, and wherein the relational database has a fact table and at least one related dimension table; (b) one or more computer programs, performed by the computer, for receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, accessing rows from the fact table through the related dimension tables using the received dimension identifier, and formatting the accessed rows as a data block for the multi-dimensional database.
Claim 27
Dependent Claim
26 words
The apparatus of claim 16 above, wherein the relational database has relational member identifiers for accessing data from the fact table through the related dimension tables.
Claim 28
Dependent Claim
27 words
The apparatus of claim 17 above, wherein the means for accessing rows further comprises the means for mapping the identified multi-dimensional member identifiers to relational member identifiers.
Claim 29
Independent Claim
165 words
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, and wherein the relational database has a fact table and at least one related dimension table; (b) one or more computer programs, performed by the computer, for receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block, for accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein the accessed rows contain values, for formatting the accessed rows as a data block for the multi-dimensional database, for determining an offset into the data block using the multi-dimensional member identifiers, and for storing the values contained in the accessed rows into the data block at the determined offset.
Claim 30
Independent Claim
165 words
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, and wherein the relational database has a fact table and at least one related dimension table; (b) one or more computer programs, performed by the computer, for receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block, for accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein the accessed rows contain values, for formatting the accessed rows as a data block for the multi-dimensional database, for determining an offset into the data block using the multi-dimensional member identifiers, and for storing the values contained in the accessed rows into the data block at the determined offset.
Claim 31
Independent Claim
173 words
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, and wherein the relational database has a fact table and at least one related dimension table; (b) one or more computer programs, performed by the computer, for receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block, and wherein the data block contains values, for accessing rows from the fact table through the related dimension tables using the received dimension identifier, for formatting the accessed rows as a data block for the multi-dimensional database, for determining an offset into the data block using the multi-dimensional member identifiers, for accessing the values contained in the data block at the determined offset, and for storing the accessed values in rows of the relational database.
Claim 32
Independent Claim
173 words
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, and wherein the relational database has a fact table and at least one related dimension table; (b) one or more computer programs, performed by the computer, for receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block, and wherein the data block contains values, for accessing rows from the fact table through the related dimension tables using the received dimension identifier, for formatting the accessed rows as a data block for the multi-dimensional database, for determining an offset into the data block using the multi-dimensional member identifiers, for accessing the values contained in the data block at the determined offset, and for storing the accessed values in rows of the relational database.
Claim 33
Dependent Claim
164 words
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, wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables, the method comprising the steps of: (a) receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers; and (b) accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein one of the dimension tables is an anchor dimension table that does not intersect the fact table with a common column and the remaining dimension tables are non-anchor dimension tables that intersect the fact table with common columns.
Claim 34
Dependent Claim
164 words
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, wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables, the method comprising the steps of: (a) receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers; and (b) accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein one of the dimension tables is an anchor dimension table that does not intersect the fact table with a common column and the remaining dimension tables are non-anchor dimension tables that intersect the fact table with common columns.
Claim 35
Dependent Claim
23 words
The method of claim 21 above, further comprising the step of formatting the accessed rows as a data block for the multi-dimensional database.
Claim 36
Dependent Claim
27 words
The method of claim 21 above, wherein the step of accessing rows further comprises the step of mapping the identified multi-dimensional member identifiers to relational member identifiers.
Claim 37
Dependent Claim
169 words
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, wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block; accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein the accessed rows contain values; determining an offset into the data block using the multi-dimensional member identifiers; and storing the values contained in the accessed rows into the data block at the determined offset.
Claim 38
Dependent Claim
169 words
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, wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block; accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein the accessed rows contain values; determining an offset into the data block using the multi-dimensional member identifiers; and storing the values contained in the accessed rows into the data block at the determined offset.
Claim 39
Dependent Claim
176 words
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, wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block, and wherein the data block contains values; accessing rows from the fact table through the related dimension tables using the received dimension identifier; determining an offset into the data block using the multi-dimensional member identifiers; accessing the values contained in the data block at the determined offset; and storing the accessed values in rows of the relational database.
Claim 40
Dependent Claim
176 words
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, wherein the relational database has a fact table, one or more related dimension tables, and relational member identifiers for accessing data from the fact table through the related dimension tables, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block, and wherein the data block contains values; accessing rows from the fact table through the related dimension tables using the received dimension identifier; determining an offset into the data block using the multi-dimensional member identifiers; accessing the values contained in the data block at the determined offset; and storing the accessed values in rows of the relational database.
Claim 41
Dependent Claim
123 words
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, wherein the relational database has a fact table and at least one related dimension table, the method comprising the steps of: (a) receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers; (b) accessing rows from the fact table through the related dimension tables using the received dimension identifier; and (c) formatting the accessed rows as a data block for the multi-dimensional database.
Claim 42
Dependent Claim
123 words
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, wherein the relational database has a fact table and at least one related dimension table, the method comprising the steps of: (a) receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers; (b) accessing rows from the fact table through the related dimension tables using the received dimension identifier; and (c) formatting the accessed rows as a data block for the multi-dimensional database.
Claim 43
Dependent Claim
26 words
The method of claim 26 above, wherein the relational database has relational member identifiers for accessing data from the fact table through the related dimension tables.
Claim 44
Dependent Claim
27 words
The method of claim 27 above, wherein the step of accessing rows further comprises the step of mapping the identified multi-dimensional member identifiers to relational member identifiers.
Claim 45
Dependent Claim
166 words
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, wherein the relational database has a fact table and at least one related dimension table, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block; accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein the accessed rows contain values; formatting the accessed rows as a data block for the multi-dimensional database determining an offset into the data block using the multi-dimensional member identifiers; and storing the values contained in the accessed rows into the data block at the determined offset.
Claim 46
Dependent Claim
166 words
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, wherein the relational database has a fact table and at least one related dimension table, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers, wherein the multi-dimensional member identifiers identify an offset into the data block; accessing rows from the fact table through the related dimension tables using the received dimension identifier, wherein the accessed rows contain values; formatting the accessed rows as a data block for the multi-dimensional database determining an offset into the data block using the multi-dimensional member identifiers; and storing the values contained in the accessed rows into the data block at the determined offset.
Claim 47
Dependent Claim
173 words
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, wherein the relational database has a fact table and at least one related dimension table, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers wherein the multi-dimensional member identifiers identify an offset into the data block, and wherein the data block contains values; accessing rows from the fact table through the related dimension tables using the received dimension identifier; formatting the accessed rows as a data block for the multi-dimensional database; determining an offset into the data block using the multi-dimensional member identifiers; accessing the values contained in the data block at the determined offset; and storing the accessed values in rows of the relational database.
Claim 48
Dependent Claim
173 words
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, wherein the relational database has a fact table and at least one related dimension table, the method comprising the steps of: receiving a dimension identifier that identifies a data block in a multi-dimensional database, wherein the dimension identifier comprises one or more multi-dimensional member identifiers wherein the multi-dimensional member identifiers identify an offset into the data block, and wherein the data block contains values; accessing rows from the fact table through the related dimension tables using the received dimension identifier; formatting the accessed rows as a data block for the multi-dimensional database; determining an offset into the data block using the multi-dimensional member identifiers; accessing the values contained in the data block at the determined offset; and storing the accessed values in rows of the relational database.
References Cited (Backward Citations)
US5257365A
Cited
US5359724A
Cited
US5572644A
Cited
US5604854A
Cited
US5761652A
Cited
US5799300A
Cited
US5822751A
Cited
US5848408A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-11-01 | 2003-05-03 | 2003-11-02 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-11-01 | 2007-05-03 | 2007-11-02 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-11-01 | 2011-05-03 | 2011-11-02 | $7700.00 | Window Closed / Lapsed |