Managing global transactions in hybrid database paradigms

A non-transitory computer-readable storage medium coupled to one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations for executing global transactions that impact records in multiple, disparate database systems, the operations 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.

A system, comprising:

• computing device;
• and
• non-transitory computer-readable storage devices coupled to the computing devices and having instructions stored thereon which, when executed by the computing devices, cause the computing devices to perform operations for executing global transactions that impact records in multiple, disparate database systems, the operations 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.