Oracle international corporation (20240126745). DATABASE-NATIVE AUTOMATIC COMPENSATION FOR SAGAS simplified abstract
Contents
- 1 DATABASE-NATIVE AUTOMATIC COMPENSATION FOR SAGAS
- 1.1 Organization Name
- 1.2 Inventor(s)
- 1.3 DATABASE-NATIVE AUTOMATIC COMPENSATION FOR SAGAS - A simplified explanation of the abstract
- 1.4 Simplified Explanation
- 1.5 Potential Applications
- 1.6 Problems Solved
- 1.7 Benefits
- 1.8 Potential Commercial Applications
- 1.9 Possible Prior Art
- 1.10 Unanswered Questions
- 1.11 Original Abstract Submitted
DATABASE-NATIVE AUTOMATIC COMPENSATION FOR SAGAS
Organization Name
oracle international corporation
Inventor(s)
VASUDHA Krishnaswamy of Fremont CA (US)
DIETER Gawlick of Palo Alto CA (US)
MAHESH BABURAO Girkar of Los Altos CA (US)
AMIT Ketkar of Redwood City CA (US)
JIAQI Wang of Redwood City CA (US)
PAVAS Navaney of Redwood City CA (US)
DATABASE-NATIVE AUTOMATIC COMPENSATION FOR SAGAS - A simplified explanation of the abstract
This abstract first appeared for US patent application 20240126745 titled 'DATABASE-NATIVE AUTOMATIC COMPENSATION FOR SAGAS
Simplified Explanation
The abstract describes a database-native lock-free reservation infrastructure that automatically compensates for updates made by local transactions that are part of a saga being aborted.
- The reservation infrastructure tracks reservable column updates in a reservations journal within the database.
- The information is retained beyond the commit of the local transaction until the saga finalization.
- If the saga aborts, the database server uses the reservations journal to compensate for changes made by committed transactions.
Potential Applications
This technology could be applied in distributed systems where compensating actions are needed in case of transaction failures.
Problems Solved
1. Automatic compensation for updates made by aborted transactions. 2. Ensuring data consistency in distributed systems.
Benefits
1. Improved reliability in handling transaction failures. 2. Simplified management of compensating actions in complex distributed systems.
Potential Commercial Applications
"Database-Native Lock-Free Reservation Infrastructure for Distributed Systems" could find applications in e-commerce platforms, financial systems, and any other system requiring robust transaction handling.
Possible Prior Art
There may be prior art related to compensating actions in distributed systems, but specific examples are not provided in the abstract.
Unanswered Questions
How does the infrastructure handle conflicts between compensating actions and other ongoing transactions?
The abstract does not mention how conflicts between compensating actions and other transactions are resolved within the infrastructure.
What is the performance impact of using the reservations journal on database operations?
The abstract does not address the potential performance implications of tracking reservable column updates in the reservations journal.
Original Abstract Submitted
a database-native lock-free reservation infrastructure is used to provide automatic compensation for the reservable column updates made by successful local transactions (or microservice actions) that are part of a saga that is being aborted. the automatic compensation is achieved by tracking the reservable column updates in a reservations journal, within the database, during the execution of the local transaction and remembering them beyond the commit of the local transaction until the finalization of the saga that the transaction is a part of. if the saga aborts, then the database server automatically uses the information retained in the reservations journal to compensate for the changes made by the committed transactions that were part of the saga.
