BULK READ AND WRITE BETWEEN MULTI-DIMENSIONAL DATA STRUCTURES

• US 20140122413A1
• Filed: 10/29/2013
• Published: 05/01/2014
• Est. Priority Date: 10/29/2012
• Status: Abandoned Application

• Current Assignee: Paris Technologies Incorporated
• Original Assignee: Paris Technologies Incorporated
• Inventors: PRESTI, Duane Edward, WILLSON, Roger Allen
• Application Number:
  US14/066,213
• Publication Number:
  US 20140122413A1
• Time in Patent Office: Days
• US Class Current: 707/602
• 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/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A system and method for reading and writing of data values between multidimensional structures that reside in Online Analytical Processing (OLAP) databases are disclosed. Data queries may be performed and updates executed between multidimensional data structures, whether existing on the same server or separate servers. Bulk (being two or more intersections) transfers are allowed between multidimensional structures (or cubes), providing a performance gain that cannot be matched using a standard point-by-point implementation. An intersection only contains a numerical or data value if there is a value for each dimension at that intersection within the database. Multidimensional data structures naturally generate sparse intersections where no data values are found, which can greatly impact performance. Within each cube, only a small intersection of members actually contains values. The system may very quickly calculate reports which include any intersection in any very large cube.

Claims

1. A system for reading or writing data values residing in multidimensional structures, the system comprising:

a. at least one server, wherein the server includes a processor and memory storing at least one multidimensional database;

b. a program stored on a computer readable medium, wherein the program may access the at least one multidimensional database stored on the server;

c. a communication interface, wherein the communication interface receives bulk read or write requests and transmits responses;

d. wherein the processor and server perform bulk reading or writing between multidimensional structures.

2. The system of claim 1, wherein the at least one multidimensional database is an Online Analytical Processing database.

3. The system of claim 1, wherein the at least one server comprises two or more servers, and wherein the bulk reading or writing is performed occurs between multiple databases residing on the first and second servers.

4. The system of claim 1, wherein a single program controls the bulk reading or writing of data.

5. The system of claim 1, wherein separate, interacting programs control the bulk or writing between multidimensional structures.

6. The system of claim 3, wherein separate, interacting programs control the bulk or writing between multidimensional structures.

7. The system of claim 6, wherein each server contains one of the separate, interacting programs.

8. A method of bulk reading or writing data values residing in multidimensional structures, the method comprising:

a. receiving a read or write request;

b. creating at least one intersection of values related to the request;

c. batch sending the at least one intersection of values to a corresponding database for processing.

9. The method of claim 9, wherein the bulk reading or writing occurs between multiple databases running on a single server.

10. The method of claim 9, wherein the bulk reading or writing occurs between multiple databases running on separate servers, wherein the servers communicate over a communication interface.

11. The method of claim 9, wherein a request is initiated by receiving a report calculated by a user which makes a multidimensional request to a first database running on a server.

12. The method of claim 12, wherein the first database determines the intersection of the request and further determines if a bulk query to one or multiple other databases is required to complete the user report request.

13. The method of claim 12, wherein the first database creates a source request intersection between the values the user requested and the intersection with at least one multidimensional structure within the first database.

14. The method of claim 13, wherein the source request is queried to at least one corresponding database, and wherein an updated source request multidimensional data structures is returned to the first database from the at least one corresponding database.

15. The method of claim 14, wherein the first database generates a response from the updated multidimensional data structures, and transmits this response to the user.