Method of splitting a multi-dimensional cube between a multi-dimensional and a relational database

• US 7,028,046 B2
• Filed: 03/19/2002
• Issued: 04/11/2006
• Est. Priority Date: 03/19/2002
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Hyperion Solutions Corporation (Oracle Corporation)
• Inventors: Kumar, Arun, Nazarenko, Igor, Anjur, Vaishnavi, Binkovich, Maya, Liao, Kevin Kaixuan, Anjur, Vijay K., Banerjee, Hemanta, Duvvuri, Srinivas, Goldenshteyn, Mark
• Primary Examiner(s): Gaffin, Jeffrey
• Assistant Examiner(s): Wu, Yicun
• Application Number:
  US10/101,664
• Publication Number:
  US 20030182300A1
• Time in Patent Office: 1,484 Days
• Field of Search: 707/1, 707/2, 707/3, 707/4, 707/5, 707/6, 707/7, 707/8, 707/9, 707/10, 707/101, 707/102, 707/103, 707/100, 707/104.1, 705/10
• US Class Current: 1/1
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A method of operating a multi-dimensional database is disclosed. In this method, a multi-dimensional portion of the data is transferred to a multi-dimensional database. A relational portion of the cube is kept in the relational database. When data from the relational portion needs to be accessed, the system produces the SQL queries to obtain data from the relational database.

Claims

1. A method for providing access to data in a hierarchy, the hierarchy having one or more levels, the method comprising:

for each level of the hierarchy, receiving a selection from an administrator as to whether the level is to be stored in a multi-dimension portion, a relational portion, or a blocked portion;

transferring data for each level of the hierarchy selected to be stored in a multi-dimensional portion from a relational database to a multi-dimensional database;

enabling access for users other than said administrator to the relational database for data at levels selected to be stored in a relational portion, while preventing access to data at levels selected to be stored in a blocked portion; and

responding to multi-dimensional data requests by first accessing the multidimensional database and, if necessary, accessing the relational database by constructing queries to the relational database.

2. The method of claim 1, further comprising:

constructing metadata regarding one or more of the levels of the hierarchy selected to be stored in a relational portion; and

displaying, to one of said users, said metadata regarding one or more of the levels of the hierarchy selected to be stored in a relational portion along with metadata regarding one or more of the levels of the hierarchy selected to be stored in a multi-dimensional portion.

3. The method of claim 1, further comprising;

constructing metadata regarding all levels of the hierarchy selected to be stored in a relational portion or a multi-dimensional portion; and

displaying, to one of said users, all of the levels of the hierarchy selected to be stored in a relational portion or a multi-dimensional portion without accessing said relational database by accessing said metadata.

4. An apparatus for providing access to data in a hierarchy, the hierarchy having one or more levels, the apparatus comprising:

means for, for each level of the hierarchy, receiving a selection from an administrator as to whether the level is to be stored in a multi-dimension portion, a relational portion, or a blocked portion;

means for transferring data for each level of the hierarchy selected to be stored in a multi-dimensional portion from a relational database to a multi-dimensional database;

means for enabling access for users other than said administrator to the relational database for data at levels selected to be stored in a relational portion, while preventing access to data at levels selected to be stored in a blocked portion; and

means for responding to multi-dimensional data requests by first accessing the multidimensional database and, if necessary, accessing the relational database by constructing queries to the relational database.

5. The apparatus of claim 4, further comprising:

means for constructing metadata regarding one or more of the levels of the hierarchy selected to be stored in a relational portion; and

means for displaying, to one of said users, said metadata regarding one or more of the levels of the hierarchy selected to be stored in a relational portion along with metadata regarding one or more of the levels of the hierarchy selected to be stored in a multi-dimensional portion.

6. The apparatus of claim 4, further comprising;

means for constructing metadata regarding all levels of the hierarchy selected to be stored in a relational portion or a multi-dimensional portion; and

means for displaying, to one of said users, all of the levels of the hierarchy selected to be stored in a relational portion or a multi-dimensional portion without accessing said relational database by accessing said metadata.

7. A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform a method for providing access to data in a hierarchy, the hierarchy having one or more levels, the method comprising:

for each level of the hierarchy, receiving a selection from an administrator as to whether the level is to be stored in a multi-dimension portion, a relational portion, or a blocked portion;

transferring data for each level of the hierarchy selected to be stored in a multi-dimensional portion from a relational database to a multi-dimensional database;

enabling access for users other than said administrator to the relational database for data at levels selected to be stored in a relational portion, while preventing access to data at levels selected to be stored in a blocked portion; and

responding to multi-dimensional data requests by first accessing the multidimensional database and, if necessary, accessing the relational database by constructing queries to the relational database.

8. The program storage device of claim 7, wherein the method further comprises:

constructing metadata regarding one or more of the levels of the hierarchy selected to be stored in a relational portion; and

displaying, to one of said users, said metadata regarding one or more of the levels of the hierarchy selected to be stored in a relational portion along with metadata regarding one or more of the levels of the hierarchy selected to be stored in a multi-dimensional portion.

9. The program storage device of claim 8, wherein the method further comprises;

constructing metadata regarding all levels of the hierarchy selected to be stored in a relational portion or a multi-dimensional portion; and

displaying, to one of said users, all of the levels of the hierarchy selected to be stored in a relational portion or a multi-dimensional portion without accessing said relational database by accessing said metadata.