US 8,412,690 B2Granted

In-memory processing for a data warehouse

AssigneeSap SE

InventorsAlexander Hermann, Thorsten Winsemann, Martin Heidel, Andreas Thumfart, Andreas Bader

Life of this patent

Estimating the term…

Loading patent…

Abstract

Embodiments of the present invention include in-memory processing for data warehouse applications. In one embodiment, data records from a data warehouse application are stored in a data storage structure of an in-memory database. Data received from the data warehouse may be stored in a queue and loaded into the data storage structure according to predefined rules. Stored data records are associated with in-memory database transactions that caused the stored data record to be stored, and may further be associated with transactions that caused the stored data records to be changed. A mapping is generated to associate requests from the data warehouse application with in-memory database transactions. The data warehouse application may retrieve data in a change data format calculated on-the-fly.

Claims20

Dependent claims

A method comprising:

receiving a plurality of data storage requests to store a plurality of first data records, wherein the data storage requests are received in an in-memory database from a data warehouse application, and wherein the data warehouse application and the in-memory database operate on a computer system;
storing the plurality of first data records in a first data storage structure of the in-memory database in a memory of the computer system to produce a plurality of stored data records, wherein said storing the plurality of first data records is performed using in-memory database transactions generated by the in-memory database, and wherein particular in-memory database transactions cause previously stored data records to change;
associating the in-memory database transactions with the plurality of stored data records in the first data storage structure, wherein each stored data record is associated with a first corresponding in-memory database transaction that caused the stored data record to be stored, and wherein one or more of the plurality of stored data records are associated with a second corresponding in-memory database transaction that caused the one or more of the plurality of stored data records to be changed;
generating, in the in-memory database, a mapping, wherein the mapping associates particular data storage requests from the data warehouse application with a corresponding in-memory database transaction;
receiving a second request from the data warehouse application to retrieve data;
calculating a plurality of second data records in a change data format from the plurality of stored data records based on the mapping, in-memory database transactions associated with particular stored data records, and particular data values in particular stored data records;
and
sending the second data records to the data warehouse application.

5 more elements

A non-transitory computer readable storage medium including instructions executable by a computer system to perform a method, the method comprising:

receiving a plurality of data storage requests to store a plurality of first data records, wherein the data storage requests are received in an in-memory database from a data warehouse application, and wherein the data warehouse application and the in-memory database operate on a computer system;
storing the plurality of first data records in a first data storage structure of the in-memory database in a memory of the computer system to produce a plurality of stored data records, wherein said storing the plurality of first data records is performed using in-memory database transactions generated by the in-memory database, and wherein particular in-memory database transactions cause previously stored data records to change;
associating the in-memory database transactions with the plurality of stored data records in the first data storage structure, wherein each stored data record is associated with a first corresponding in-memory database transaction that caused the stored data record to be stored, and wherein one or more of the plurality of stored data records are associated with a second corresponding in-memory database transaction that caused the one or more of the plurality of stored data records to be changed;
generating, in the in-memory database, a mapping, wherein the mapping associates particular data storage requests from the data warehouse application with a corresponding in-memory database transaction;
receiving a second request from the data warehouse application to retrieve data;
calculating a plurality of second data records in a change data format from the plurality of stored data records based on the mapping, in-memory database transactions associated with particular stored data records, and particular data values in particular stored data records;
and
sending the second data records to the data warehouse application.

5 more elements

Dependencies are inferred from the claim text.