Managing global transactions in hybrid database paradigms
Methods, systems, and computer-readable storage media for executing, by a first database system, a first sub-transaction of a global transaction, the first sub-transaction impacting a primary record in a first database, in response to successful execution of the first sub-transaction, executing, by a second database system, a second sub-transaction including setting a status of a secondary record to a pending status in a status column of a table that stores data of the secondary record, 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.
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.
2. The method of claim 1 , wherein the pending status comprises an invalidate pending status and one of:
the first final status comprises an invalid status that is set in response to determining that the changes to the primary record are successfully committed; and
the first final status comprises a valid status that is set in response to determining that the changes to the primary record failed to be committed.
3. The method of claim 1 , wherein the pending status comprises a validate pending status and one of:
the second final status comprises a valid status that is set in response to determining that the changes to the primary record are successfully committed; and
the second final status comprises an invalid status that is set in response to determining that the changes to the primary record failed to be committed.
4. The method of claim 1 , wherein execution of the second sub-transaction results in one of adding the secondary record to the secondary database and deleting the secondary record from the secondary database.
5. The method of claim 1 , wherein selectively setting the status to one of a first final status and a second final status comprises at least one retry to set the status to one of a first final status and a second final status.
6. The method of claim 1 , wherein the primary record and the secondary record are representative of an entity.
7. The method of claim 1 , wherein the first database comprises a relational database management system (RDBMS) database and the second database comprises a non-RDBMS database.
8. 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.
9. The non-transitory computer-readable storage medium of claim 8 , wherein the pending status comprises an invalidate pending status and one of:
the first final status comprises an invalid status that is set in response to determining that the changes to the primary record are successfully committed; and
the first final status comprises a valid status that is set in response to determining that the changes to the primary record failed to be committed.
10. The non-transitory computer-readable storage medium of claim 8 , wherein the pending status comprises a validate pending status and one of:
the second final status comprises a valid status that is set in response to determining that the changes to the primary record are successfully committed; and
the second final status comprises an invalid status that is set in response to determining that the changes to the primary record failed to be committed.
11. The non-transitory computer-readable storage medium of claim 8 , wherein execution of the second sub-transaction results in one of adding the secondary record to the secondary database and deleting the secondary record from the secondary database.
12. The non-transitory computer-readable storage medium of claim 8 , wherein selectively setting the status to one of a first final status and a second final status comprises at least one retry to set the status to one of a first final status and a second final status.
13. The non-transitory computer-readable storage medium of claim 8 , wherein the primary record and the secondary record are representative of an entity.
14. The non-transitory computer-readable storage medium of claim 8 , wherein the first database comprises a relational database management system (RDBMS) database and the second database comprises a non-RDBMS database.
15. A system, comprising:
computing devices; 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.
16. The system of claim 15 , wherein the pending status comprises an invalidate pending status and one of:
the first final status comprises an invalid status that is set in response to determining that the changes to the primary record are successfully committed; and
the first final status comprises a valid status that is set in response to determining that the changes to the primary record failed to be committed.
17. The system of claim 15 , wherein the pending status comprises a validate pending status and one of:
the second final status comprises a valid status that is set in response to determining that the changes to the primary record are successfully committed; and
the second final status comprises an invalid status that is set in response to determining that the changes to the primary record failed to be committed.
18. The system of claim 15 , wherein execution of the second sub-transaction results in one of adding the secondary record to the secondary database and deleting the secondary record from the secondary database.
19. The system of claim 15 , wherein selectively setting the status to one of a first final status and a second final status comprises at least one retry to set the status to one of a first final status and a second final status.
20. The system of claim 15 , wherein the primary record and the secondary record are representative of an entity.