Sap Se

Alexander Becker

Michael Haberkorn

Sebastian Haase

Andrey Martynov

Dennis Alexander Gauss

Milan Spasic

Systems and methods to read records of a data staging table, where each record of the data staging table is associated with a package identifier, a key value of a record of a first database table, values of one or more non-key fields of the record of the first database table, and a database operation, include reading of one or more records of the data staging table, each of the read one or more records associated with a package identifier indicating the record is not being processed, and not including a same key value as any other record of the data staging table associated with a package identifier indicating the record is being processed, updating the package identifier of each of the read records of the data staging table to a first package identifier indicating that the record is being processed, creating a transaction record of a transaction queue associating the data staging table and the first package identifier, determining that the read one or more records have been processed, and, in response to the determination, deleting the one or more read rows from the data staging table and the transaction record.

Parallel reads of data staging table

Disclosed herein are system, method, and computer program product embodiments for replicating data from table in a source database to a target database. In some embodiments, data replication includes access plan delimitation and access plan calculation steps and is performed on a table having multiple partitions. A table may be divided into one or more partitions and each partition may be further divided into one or more access plans. Access plan delimitation may involve calculating, in parallel, boundaries of access plans within partitions of the table. Access plan calculation may be initiated on the first partition that has completed the access plan delimitation steps, and may involve transferring data from each delimited partition from the table in the source database to the target database.

Parallel calculation of access plans delimitation using table partitions

Systems and methods include determination of an augmented view of a source system to be created in a target system, the augmented view including a structured query language view and annotations, and the augmented view associated with an object hierarchy, determination of a structured query language statement to create the augmented view in the source system, conversion of the structured query language statement to include augmented view names and augmented view field names, modification of one or more session context variables of the converted structured query language statement, creation of a target augmented view in the target system using the converted and modified structure query language statement, and creation of each object of the object hierarchy which is not an augmented view in the target system.

Replication of complex augmented views

Systems and methods include reception of a request for changed data of an object from a subscriber, determination of a logging table associated with the object, determination of a pointer to a last-processed entry of the logging table based on the object and the subscriber, determination of one or more entries of the logging table subsequent to the last-processed entry, determination of a last entry of the determined one or more entries, buffering of a pointer to the last entry, transferring of data reconstructed based on the one or more entries to the subscriber, and, in response to a determination that the transfer of data was successful, updating of the pointer to the last-processed entry of the logging table with the buffered pointer.

Growing community of inventors

Mühlhausen, Germany

Alexander Becker