System with multiple conditional commit databases

• US 8,266,126 B2
• Filed: 03/24/2010
• Issued: 09/11/2012
• Est. Priority Date: 03/24/2010
• Status: Active Grant

• Current Assignee: MATRIXX Software, Inc.
• Original Assignee: MATRIXX Software, Inc.
• Inventors: Labuda, David, Brefczynski, Keith
• Primary Examiner(s): Cao, Phuong Thao
• Application Number:
  US12/661,897
• Publication Number:
  US 20110238641A1
• Time in Patent Office: 902 Days
• Field of Search: 707/703, 707/704, 707/615
• US Class Current: 707/703
• CPC Class Codes: G06F 16/2343 Locking methods, e.g. distributed locking or locking implementation details
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: H04B 17/318 Received signal strength
• CPC Class Codes: H04W 4/023 using mutual or relative location information between multiple location based services [LBS] targets or of distance thresholds
• CPC Class Codes: H04W 4/06 Selective distribution of broadcast services, e.g. multimedia broadcast multicast service [MBMS]; Services to user groups; One-way selective calling services
• CPC Class Codes: H04W 4/80 Services using short range communication, e.g. near-field communication [NFC], radio-frequency identification [RFID] or low energy communication
• CPC Class Codes: H04W 52/0216 using a pre-established activity schedule, e.g. traffic indication frame
• CPC Class Codes: Y02D 30/70 in wireless communication networks

Abstract

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.

Claims

1. A system for processing a transaction, comprising:

a processor configured to check a condition using a data in a first database associated with the transaction, wherein the transaction comprises a conditional update to the data in the first database, wherein the data in the first database is latched before checking the condition and is unlatched after checking the condition, wherein checking the condition comprises reading a value of the data in the first database and comparing the value to the condition;

in the event that the condition is satisfied, allocate a first update buffer, wherein the first update buffer comprises a first maximum value of the data and a first minimum value of the data being conditionally updated;

the processor is further configured to indicate to a second database to check the same condition using a data in the second database associated with the transaction, wherein the transaction comprises a conditional update to the data in the second database, wherein the data in the second database is latched before checking the condition and is unlatched after checking the condition, wherein checking the condition comprises reading a value of the data in the second database and comparing the value to the condition;

in the event that the condition is satisfied, allocate a second update buffer, wherein the second update buffer comprises a second maximum value of the data and a second minimum value of the data being conditionally updated; and

a memory coupled to the processor and configured to provide the processor with instructions.

2. The system as in claim 1, wherein the processor is further configured to receive an indication that a check of the condition was satisfied.

3. The system as in claim 1, wherein the check of the condition using data in a first database is part of processing a prepare.

4. The system as in claim 1, wherein the check of the condition using data in the second database is part of processing a prepare.

5. The system as in claim 1, wherein the processor is further configured to determine whether to proceed with processing the transaction based at least in part on a received result of a check of the condition.

6. The system as in claim 5, wherein in the event that the condition is satisfied, a first transaction buffer is allocated.

7. The system as in claim 6, where in the first transaction buffer comprises a transaction condition list.

8. The system as in claim 6, where in the first transaction buffer comprises a transaction command.

9. The system as in claim 5, wherein allocating the first update buffer comprises creating a new update buffer.

10. The system as in claim 1, wherein the first update buffer further comprises a maximum reserved value and a minimum reserved value.

11. The system as in claim 1, wherein the first update buffer comprises a number of transactions.

12. The system as in claim 1, wherein the processor is further configured to:

implement a commit state associated with the transaction in the first database, wherein the data in the first database is latched before implementing the commit state in the first database and is unlatched after the implementing of the commit state in the first database;

indicate to the second database that the commit state is to be implemented in the second database, wherein the data in the second database is latched before implementing the commit state in the second database and is unlatched after the implementing of the commit state in the second database.

13. The system as in claim 12, wherein implementing the commit state comprises updating a data.

14. The system as in claim 12, wherein implementing the commit state in the first database comprises updating the first update buffer.

15. The system as in claim 12, wherein implementing the commit state comprises updating a first transaction buffer.

16. A method for processing a transaction, comprising:

checking a condition using a data in a first database associated with the transaction, wherein the transaction comprises a conditional update to the data in the first database, wherein the data in the first database is latched before checking the condition and is unlatched after checking the condition, wherein checking the condition comprises reading a value of the data in the first database and comparing the value to the condition;

in the event that the condition is satisfied, allocating a first update buffer, wherein the first update buffer comprises a first maximum value of the data and a first minimum value of the data being conditionally updated; and

indicating to a second database to check the condition using a data in the second database associated with the transaction, wherein the transaction comprises a conditional update to the data in the second database;

wherein the data in the second database is latched before checking the condition and is unlatched after checking the condition, wherein checking the condition comprises reading a value of the data in the second database and comparing the value to the condition;

in the event that the condition is satisfied, allocating a second update buffer, wherein the second update buffer comprises a second maximum value of the data and a second minimum value of the data being conditionally updated.

17. A computer program product for processing a transaction, the computer program product being embodied in a non-transitory computer readable storage medium and comprising computer instructions for:

checking a condition using a data in a first database associated with the transaction, wherein the transaction comprises a conditional update to the data in the first database, wherein the data in the first database is latched before checking the condition and is unlatched after checking the condition, wherein checking the condition comprises reading a value of the data in the first database and comparing the value to the condition;

in the event that the condition is satisfied, allocating a first update buffer, wherein the first update buffer comprises a first maximum value of the data and a first minimum value of the data being conditionally updated; and

indicating to a second database to check the condition using a data in the second database associated with the transaction, wherein the transaction comprises a conditional update to the data in the second database, wherein the data in the second database is latched before checking the condition and is unlatched after checking the condition, wherein checking the condition comprises reading a value of the data in the second database and comparing the value to the condition;

wherein in the event that the condition is satisfied, allocating a second update buffer, wherein the second update buffer comprises a second maximum value of the data and a second minimum value of the data being conditionally updated.