Invention Grant
- Patent Title: Parallel reads of data staging table
-
Application No.: US17393562Application Date: 2021-08-04
-
Publication No.: US11740836B2Publication Date: 2023-08-29
- Inventor: Alexander Becker , Sebastian Haase , Michael Haberkorn , Dennis Alexander Gauss
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Buckley, Maschoff & Talwalkar LLC
- Main IPC: G06F3/00
- IPC: G06F3/00 ; G06F3/06 ; G06F16/23

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.
Public/Granted literature
- US20230044115A1 PARALLEL READS OF DATA STAGING TABLE Public/Granted day:2023-02-09
Information query