MECHANISM FOR UPDATING OLAP SYSTEM STRUCTURE AND OLTP SYSTEM STRUCTURE STRUCTURE

• US 20130073520A1
• Filed: 05/04/2012
• Published: 03/21/2013
• Est. Priority Date: 09/20/2011
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Ng, Rondy, Zwiebach, Robert C., Siauw, Djiao Mei, Haimes, David, Roth, Gregory David, Banerjee, Arunesh, Matam, Santosh Kumar, Murthy Kosuri, Venkata Ramana
• Granted Patent: US 9,959,330 B2
• Time in Patent Office: Days
• US Class Current: 707/610
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: G06F 16/907 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
• CPC Class Codes: G06F 16/9537 Spatial or temporal dependent retrieval, e.g. spatiotemporal queries

Abstract

In an embodiment, for any structural change that is made to a relational database, a corresponding change is also made to the multidimensional database. In an embodiment, the system determines that a particular structure is not implemented on the multidimensional database system. Based on metadata that defines the structure that is supposed to exist in the multidimensional database, the appropriate structure is created.

Claims

1. A system, comprising:

a processor;

a computer-readable storage medium;

a metadata repository configured to store structure metadata, wherein the structure metadata defines one or more structures for storing data in both;

a) a relational database, and b) a multidimensional database;

metadata generation logic configured to automatically generate first structure metadata that describes the first structure in response to receiving a first request to generate a first structure for storing data;

wherein the metadata repository is further configured to store the first metadata.

2. The system of claim 1, further comprising structure generation logic configured to:

generate a structure in the relational database based at least in part on the first metadata; and

generate a structure in the multidimensional database based at least in part on the first metadata.

3. The method of claim 1, further comprising metadata generation logic configured to change the metadata associated with the structure in response to receiving a second request to change a particular structure that is defined by the structure metadata.

4. The system of claim 3, wherein the structure generation logic is further configured to:

change a structure in the relational database to conform to the structure metadata; and

change a structure in the multidimensional database to conform to the structure metadata.

5. The system of claim 4, further comprising:

synchronization component logic configured to store data in the structure in the multidimensional database in response to receiving a third request to store the data.

6. The system of claim 4, further comprising:

synchronization component logic configured to store data in the structure in the relational database and the structure in the multidimensional database in response to receiving a third request to store the data.

7. A method, comprising:

maintaining a metadata repository that stores structure metadata, wherein the structure metadata defines one or more structures for storing data in both;

a) a relational database, and b) a multidimensional database;

in response to receiving a first request to generate a first structure for storing data, automatically generating first structure metadata that describes the first structure;

storing the first metadata in the metadata repository;

wherein the method is performed by one or more computing devices.

8. The method of claim 7, further comprising:

generating a structure in the relational database based at least in part on the first metadata; and

generating a structure in the multidimensional database based at least in part on the first metadata.

9. The method of claim 7, further comprising:

receiving a second request to change a particular structure, wherein the structure is defined by the structure metadata;

in response to receiving the second request, changing the metadata associated with the structure.

10. The method of claim 9, further comprising:

in response to receiving the second request;

changing a structure in the relational database to conform to the structure metadata; and

changing a structure in the multidimensional database to conform to the structure metadata.

11. The method of claim 10, further comprising:

in response to receiving a third request to store data, storing the data in the structure in the multidimensional database.

12. The method of claim 10, further comprising:

in response to receiving a third request to store data, storing the data in both;

a) the structure in the relational database, and b) the structure in the multidimensional database.

13. A computer-readable non-transitory storage medium storing a plurality of instructions executable by one or more processors, the plurality of instructions comprising:

maintaining a metadata repository that stores structure metadata, wherein the structure metadata defines one or more structures for storing data in both;

a) a relational database, and b) a multidimensional database;

in response to receiving a first request to generate a first structure for storing data, automatically generating first structure metadata that describes the first structure;

storing the first metadata in the metadata repository.

14. The computer-readable non-transitory storage medium of claim 13, wherein the instructions further include instructions that cause the one or more processors to perform:

generating a structure in the relational database based at least in part on the first metadata; and

generating a structure in the multidimensional database based at least in part on the first metadata.

15. The computer-readable non-transitory storage medium of claim 13, wherein the instructions further include instructions that cause the one or more processors to perform:

receiving a second request to change a particular structure, wherein the structure is defined by the structure metadata;

in response to receiving the second request, changing the metadata associated with the structure.

16. The computer-readable non-transitory storage medium of claim 15, wherein the instructions further include instructions that cause the one or more processors to perform:

in response to receiving the second request;

changing a structure in the relational database to conform to the structure metadata; and

changing a structure in the multidimensional database to conform to the structure metadata.

17. The computer-readable non-transitory storage medium of claim 16, wherein the instructions further include instructions that cause the one or more processors to perform:

in response to receiving a third request to store data, storing the data in the structure in the multidimensional database.

18. The computer-readable non-transitory storage medium of claim 16, wherein the instructions further include instructions that cause the one or more processors to perform:

in response to receiving a third request to store data, storing the data in both;

a) the structure in the relational database, and b) the structure in the multidimensional database.