Parallel reads of data staging table

US11740836B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Alexander Becker · Балка Пшехская, DE
• Sebastian Haase · Kronau, DE
• Michael Haberkorn · Bad Mingolsheim, DE
• Dennis Alexander Gauss · Bruchsal, DE

Key dates

• Filing date: Aug 4, 2021
• Grant date: Aug 29, 2023
• Expiry date: Nov 20, 2041

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F16/2379
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

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.