System with multiple conditional commit databases
A system for processing a transaction is disclosed. The system comprises a processor and a memory. The processor is configured to check a condition using data in a first database, wherein the data is associated with a transaction, wherein the data in the first database is latched before checking the condition and is unlatched after checking the condition. The processor is further configured to indicate to a second database to check the condition using data in the second database, wherein the data is associated with the transaction. The data in the second database is latched before checking the condition and is unlatched after checking the condition. The memory is coupled to the processor and configured to provide the processor with instructions.
1. A method for processing a transaction, comprising:
receiving a transaction;
checking, using a processor, a condition using data in a first database, wherein the data in the first database is associated with the transaction, wherein the data in the first database is latched before checking the condition and is unlatched after checking the condition;
in the event that checking the condition using the data in the first database passes, indicating to a second database to check the condition using data in the second database, wherein the data in the second database is associated with the transaction, wherein the data in the second database is latched before checking the condition and is unlatched after checking the condition; and
in the event that checking the condition using the data in the second database passes:
implementing a first commit state associated with the transaction in the first database, wherein the data in the first database is latched before implementing the first commit state in the first database and is unlatched after the implementing of the first commit state in the first database; and
indicating to the second database that a second commit state is to be implemented in the second database, wherein the data in the second database is latched before implementing the second commit state in the second database and is unlatched after the implementing of the second commit state in the second database.
2. The method as in claim 1 , further comprising receiving an indication that the condition check using the data in the second database passes.
3. The method as in claim 1 , wherein checking the condition using the data in the first database is part of processing a prepare.
4. The method as in claim 1 , wherein checking the condition using the data in the second database is part of processing a prepare.
5. The method as in claim 1 , further comprising determining whether to proceed with processing the transaction based at least in part on whether checking the condition using data in the first database passes.
6. The method as in claim 1 , wherein in the event that checking the condition using the data in the first database passes, allocating a transaction buffer.
7. The method as in claim 6 , wherein the transaction buffer stores a transaction condition list.
8. The method as in claim 6 , wherein the transaction buffer stores a transaction command.
9. The method as in claim 5 , wherein in the event that checking the condition using the data in the first database passes, creating or allocating an update buffer.
10. The method as in claim 9 , wherein the update buffer stores a maximum value.
11. The method as in claim 9 , wherein the update buffer stores a minimum value.
12. The method as in claim 9 , wherein the update buffer stores a number of transactions.
13. The method as in claim 1 , wherein implementing a first commit state comprises updating a data.
14. The method as in claim 1 , wherein implementing a first commit state comprises updating an update buffer.
15. The method as in claim 1 , wherein implementing a first commit state comprises updating a transaction buffer.
16. A system for processing a transaction, comprising:
an interface configured to receive a transaction;
a processor configured to:
check a condition using data in a first database, wherein the data in the first database is associated with the transaction, wherein the data in the first database is latched before checking the condition and is unlatched after checking the condition; and
in the event that checking the condition using, the data in the first database passes, indicate to a second database to check the condition using data in the second database, wherein the data in the second database is associated with the transaction, wherein the data in the second database is latched before checking the condition and is unlatched after checking the condition; and
in the event that checking the condition using data in the second database passes:
implement a first commit state associated with the transaction in the first database, wherein the data in the first database is latched before implementing the first commit state in the first database and is unlatched after the implementing of the first commit state in the first database; and
indicate to the second database that a second commit state is to be implemented in the second database, wherein the data in the second database is latched before implementing, the second commit state in the second database and is unlatched after the implementing of the second commit state in the second database; and
a memory coupled to the processor and configured to provide the processor with instructions.
17. A computer program product for processing a transaction, the computer program product comprising a non-transitory computer readable storage medium storing computer instructions for:
receiving a transaction;
checking a condition using data in a first database, wherein the data in the first database is associated with the transaction, wherein the data in the first database is latched before checking the condition and is unlatched after checking the condition; and
in the event that the condition check using data in the first database is passed, indicating to a second database to check the condition using data in the second database, wherein the data is associated with the transaction, wherein the data in the second database is latched before checking the condition and is unlatched after checking the condition; and
in the event that checking the condition using data in the second database passes:
implementing a first commit state associated with the transaction in the first database, wherein the data in the first database is latched before implementing the first commit state in the first database and is unlatched after the implementing of the first commit state in the first database; and
indicating to the second database that a second commit state is to be implemented in the second database, wherein the data in the second database is latched before implementing the second commit state in the second database and is unlatched after the implementing of the second commit state in the second database.