US 12,353,403 B2
Managing global transactions in hybrid database paradigms
Hui Li, Shanghai (CN); and Xia Yu, Shanghai (CN)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Nov. 21, 2023, as Appl. No. 18/515,526.
Prior Publication US 2025/0165459 A1, May 22, 2025
Int. Cl. G06F 16/23 (2019.01)
CPC G06F 16/2379 (2019.01) [G06F 16/2365 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method for executing global transactions that impact records in multiple, disparate database systems, the method being executed by one or more processors and comprising:
executing, by a first database system, a first sub-transaction of a global transaction, the first sub-transaction impacting a primary record of a first data table stored within a first database of the database system;
in response to successful execution of the first sub-transaction, executing, by a second database system, a second sub-transaction comprising setting a status of a secondary record to a pending status in a status column of a second data table that stores the secondary record, the pending status inhibiting the second record from being used to generate responses to queries executed over the second data table;
in response to successfully setting the status, executing, by the first database system, one or more operations to commit changes to the primary record; and
selectively setting, by the second database system, the status to one of a first final status and a second final status.