Sap Se

Sap Ag

Andreas Bader

Stefan A Baeuerle

Timm Falter

Martin Heidel

Daniel Hutzel

Daniel Zoch

Andreas Thumfart

Lior Schejter

Alexander Hermann

Thorsten Winsemann

A database language is extended to define constraints on a data model (e.g., entity-relationship model) rather than the concrete database. The constraints can be declarative (e.g., constraints that are defined using expressions of the database language) or programmatic (e.g., constraints that are defined as a stored procedure implemented in a domain specific language). By storing the constraints at a higher level than the database level, the constraints can be performed without changing the persistency of the database. Also disclosed are techniques for handling of constraints on partially loaded entities.

Advanced data models containing declarative and programmatic constraints

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.

In-memory processing for a data warehouse

Growing community of inventors

Walldorf, Germany

Andreas Bader