ETL-Less Zero-Redundancy System and Method for Reporting OLTP Data

• US 20090240663A1
• Filed: 09/19/2008
• Published: 09/24/2009
• Est. Priority Date: 09/21/2007
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: Hasso-Plattner-Institut Fur Softwaresytemtechnik GmbH
• Inventors: Bog, Anja, Schaffner, Jan, Krueger, Jens, Plattner, Hasso, Zeier, Alexander
• Granted Patent: US 9,626,421 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/278 Data partitioning, e.g. horizontal or vertical partitioning
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

In one embodiment the present invention includes a relational database management system component and a column-oriented data processing component. The relational database system component stores database information in a row format. The column-oriented data processing component stores the database information in a column format. In response to a database update request, the relational database management system component updates the database information stored in the row format; the relational database management system component notifies the column-oriented data processing component of the database update request; and the column-oriented data processing component updates the database information stored in said column format. In response to a query request, the column-oriented data processing component generates a query response based on the database information stored in said column format. In this manner, an embodiment of the present invention is able to generate up-to-date reports without the need for extraction, translation and loading procedures.

Claims

1. A computer system that implements a computer program for processing database information for both transacting and reporting, said computer program comprising:

a relational database management system component that stores said database information in a row format; and

a column-oriented data processing component that stores said database information in a column format,

wherein in response to a database update request, said relational database management system component updates said database information stored in said row format, said relational database management system component notifies said column-oriented data processing component of said database update request, and said column-oriented data processing component updates said database information stored in said column format, and

wherein in response to a query request, said column-oriented data processing component generates a query response based on said database information stored in said column format.

2. The computer system of claim 1, wherein said computer program further comprises:

a virtual cube interface component that maps an on-line analytical processing query into an aggregation call, and that sends said aggregation call to said column-oriented data processing component as said query request.

3. The computer system of claim 1, wherein said database information stored in said row format and said database information stored in said column format are stored in a main memory of said computer system.

4. The computer system of claim 1, wherein said column-oriented data processing component comprises:

a main index component that stores main data corresponding to said database information;

a delta index component that stores delta data corresponding to a plurality of updated database information; and

a monitoring component that merges said delta data stored in said delta index component into said main data stored in said main index component according to a criterion.

5. The computer system of claim 1, wherein said relational database management system component comprises:

a plurality of database tables;

a queue of index objects; and

a kernel that manages the plurality of database tables, that manages the queue of index objects, and that interacts with a file system.

6. The computer system of claim 1, wherein said relational database management system component communicates with said column-oriented data processing component via a delta updates access.

7. The computer system of claim 1, wherein said column-oriented data processing component communicates with said relational database management system component via a persist data access.

8. A computer-implemented method of processing database information for both transacting and reporting, comprising the steps of:

storing said database information in a row format;

storing said database information in a column format;

in response to a database update request, updating said database information stored in said row format, locking said database information stored in said row format, updating said database information stored in said column format, and unlocking said database information stored in said row format after said database information stored in said column format has been updated; and

in response to a query request, generating a query response based on said database information stored in said column format.

9. A computer program embodied on a computer-readable medium and implemented by a computer system for processing database information for both transacting and reporting, said computer program comprising:

a relational database management system component that stores said database information in a row format; and

a column-oriented data processing component, implemented by a plurality of networked computers, that stores said database information in a column format across said plurality of networked computers,

wherein in response to a database update request, said relational database management system component updates said database information stored in said row format, said relational database management system component notifies said column-oriented data processing component of said database update request, and said column-oriented data processing component updates said database information stored in said column format, and

wherein in response to a query request, said column-oriented data processing component generates a query response based on said database information stored in said column format.