Sap Ag

Sap Se

Winfried Schmitt

Andreas Balzar

Helmut Hofmann

Carsten Ziegler

Radim Sykora

Hofmann Helmut

An online transactional data processing (OLTP) system is provided that includes a relational database for storing transactional data, an OLTP application program for processing the transactional data, and a change log for storing a set of change documents that describe transformations performed on the transactional data by the OLTP application program. To correct a run of the OLTP application program, the set of change documents is used to re-establish the original state. A re-run of the OLTP application program may produce a new set of change documents in the random access memory (RAM) of the OLTP system. Further, the original set of change documents stored in the change log may be at least partly overwritten by the new set of change documents.

Systems and methods for online transactional data processing

Data processing methods and systems are provided. The data processing methods and systems may include providing a set of database tables in a data warehouse, each one of the database tables being assigned to an entity type and storing entities of its entity type, providing at least one application program for processing of classes of database tables, assigning at least one of the database tables to each one of the classes of database tables of the application program, and processing entities stored in the assigned database tables by the application program.

Systems and methods for data processing

Data processing systems and methods are provided having an on-line transaction processing (OLTP) database and an on-line analysis processing (OLAP) database. The OLAP and OLTP databases are synchronized periodically. In response to a user's query, OLAP cube data that is available in the OLAP database is complimented with data from the OLTP database for inclusion of up-to-date data into the on-line analysis processing.

Data processing systems and methods

Systems and methods are provided for data processing. As disclosed herein, such systems and methods may include providing a data model with a set of entity types and set of attributes for each entity type, providing customizing data for the data model, the customizing data indicating data sources for the attributes and describing data structures being provided by the data sources, querying the attribute data for at least a first attribute of the set of attributes of one of the entity types, determining from the customizing data, if a single data source for the first attribute data of the one of the entity types is available, if such a single data source is not available, determining at least first and second ones of the data sources which in combination comprise the first attribute data of the one of the entity types, generating a sub-query for each one of the at least first and second data sources, and combining the results of the sub-queries to provide a query result.

Disclosed is a data processing system, such as a data warehouse, having a number of application programs that each require a certain class of input database tables. A class is defined by means of a set of predefined attributes that needs to be present in a database table in order to be used as an input database table for a given application program. A user may enter a combination database table by combining two or more database tables. The combination database tables are classified by means of the predefined attributes and the assignment of database tables and combination database tables to classes is entered into a mapping table.

Data processing systems and methods for processing a plurality of application programs requiring an input database table having a predefined set of attributes

Systems and methods are disclosed for providing validity logic. The disclosed systems and methods may include receiving at least one data value, determining validity data corresponding to the received at least one data value, and providing the validity data corresponding to the received at least one data value. Furthermore, the disclosed systems and methods may include receiving at least one data value, receiving validity data corresponding to the received at least one data value, and determining, based on the received validity data, a validity value, the validity value indicating the validity of the received at least one data value.

Growing community of inventors

Walldorf, Germany

Winfried Schmitt