Invention Publication
- Patent Title: DATABASE-NATIVE AUTOMATIC COMPENSATION FOR SAGAS
-
Application No.: US18223824Application Date: 2023-07-19
-
Publication No.: US20240126745A1Publication Date: 2024-04-18
- Inventor: VASUDHA KRISHNASWAMY , DIETER GAWLICK , MAHESH BABURAO GIRKAR , AMIT KETKAR , JIAQI WANG , PAVAS NAVANEY
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Main IPC: G06F16/23
- IPC: G06F16/23

Abstract:
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.
Information query