Technique for supplying a data warehouse whilst ensuring a consistent data view

A system for supplying a data warehouse with data generated in the context of transaction-based Online Transaction Processing (OLTP), whilst ensuring a consistent data view per time threshold, comprising:

• at least one processing unit for accessing memory and executing computer executable instructions;
• an interface having computer executable instructions stored in memory that when executed, are configured to receive data elements which are assigned to individual OLTP transactions and require processing before delivery into the data warehouse;
• a process control component having computer executable instructions stored in memory that when executed, are configured to:
• determine the respective assignment of a data element to a particular processing operation;
• control the distribution of the data elements to associated processing branches;
• and
• distribute a plurality of data elements assigned to a single OLTP transaction to different processing branches;
• at least one first buffer storage provided downstream from the process control component, configured to temporarily store the distributed data elements, wherein time-control information is assigned to each stored data element;
• two or more processing branches having computer executable instructions stored in memory in which there is respectively provided a processing component having computer executable instructions stored in memory that when executed, are configured to process the data elements read-out from the at least one first buffer storage, the processing branches having different throughput times;
• at least one mode control component having computer executable instructions stored in memory that when executed, are configured to, in a first mode, initiate a processing of the data elements that is non-dependent on the time control information and, in a second mode, processes particular data elements with time control information that is older than a predefined time threshold, and holding in abeyance the processing of particular data elements with time control information younger than the predefined time threshold until the predefined time threshold is reached such that the consistent data view per time threshold is maintained in the second mode of operation;
• and
• a transfer component having computer executable instructions stored in memory, which is disposed downstream from the processing branches, the computer executable instructions of the transfer component, when executed, being configured to transfer the processed data elements to the data warehouse.