# US 2006/0129598 A1 · Method of splitting a multi-dimensional cube between a multi-dimensional and a relational database

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2006/0129598 A1
- Document ID: US20060129598A1
- Status: Published application
- Kind: A1
- Application number: 11/343,411
- Filed: 2006-01-30
- Published: 2006-06-15
- Earliest claimed: 2002-03-19
- Assignees: Hyperion Solutions Corporation
- Inventors: Vaishnavi Anjur; Vijay Anjur; Hemanta Banerjee; Maya Binkovich; Srinivas Duvvuri; Mark Goldenshteyn; Arun Kumar; Kevin Liao; Igor Nazarenko
- Web page: https://patentgrep.com/patent/US20060129598A1

## CPC

- G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP}
- Y10S 707/99942: Manipulating data structure, e.g. compression, compaction, compilation
- Y10S 707/99943: Generating database or data structure, e.g. via user interface
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- Y10S: TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS

## 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

### Claim at position 1

1-38. (canceled)

### Claim 39

A method comprising:
selecting a multi-dimensional portion, blocked portion and relational portion of at least one hierarchy for at least one dimension;
thereafter; transferring data between a relational database and a multidimensional database for the multi-dimensional portion; and
thereafter, adjusting the size of the blocked and relational portions.

### Claim 40 (depends on 39)

The method of claim 39 wherein the selecting step includes selecting a first level in the hierarchy for which the multi-dimensional portion is built down to and selecting a second level below the first level in which the relational portion is enabled down to.

### Claim 41 (depends on 39)

The method of claim 39 wherein the multi-dimensional portion is not adjusted after the data is transferred between the relational database and the multi-dimensional database.

### Claim 42 (depends on 39)

The method of claim 39 wherein metadata is produced, the metadata indicating the partition between the multi-dimensional portion and relational portion.

### Claim 43 (depends on 43)

The method of claim 43 wherein the metadata for each member of the lowest level of the multi-dimensional portion of the hierarchy indicates whether any child node exists below the partition.

### Claim 44 (depends on 42)

The method of claim 42 wherein the metadata for at least some members of the lowest level of the multi-dimensional portion of the hierarchy indicates relational database access information.

### Claim 45 (depends on 39)

The method of claim 39, wherein a graphical interface is used to display and enable selection of the levels.

### Claim 46

A method comprising:
selecting a multi-dimensional portion, and relational portion of at least one hierarchy for at least one dimension;
producing metadata, the metadata indicating a partition between multidimensional and relational portions and for each member of the lowest level of the multi-dimensional portion of the hierarchy the metadata indicating whether any child nodes exist below the partition; and
obtaining data from the multidimensional portion from a multidimensional database and obtaining data from the relational portion by constructing queries to a relational database, the queries constructed using the metadata.

### Claim 47 (depends on 46)

The method of claim 46 wherein the selection is done by selecting a first level in the hierarchy for which the multi-dimensional portion is built down to and selecting a second level below the first level in which the relational portion is enabled down to.

### Claim 48 (depends on 46)

The method of claim 46 wherein the selection of the multidimensional portion and relational portion is done using a graphical interface.

### Claim 49 (depends on 46)

The system of claim 46 wherein the metadata for at least some members of the lowest level of the multi-dimensional portion of the hierarchy indicates relational database access information.

### Claim 50 (depends on 49)

The method of claim 49 wherein the access information includes related to a dimension table in the relational database.

### Claim 51 (depends on 50)

The method of claim 50 wherein the metadata indicates the dimensional table and column which is used to indicate the members of the next lowest level in the hierarchy.
