公开(公告)号：US20240126745A1

公开(公告)日：2024-04-18

申请号：US18223824

申请日：2023-07-19

Applicant: Oracle International Corporation

Inventor： VASUDHA KRISHNASWAMY ,  DIETER GAWLICK ,  MAHESH BABURAO GIRKAR ,  AMIT KETKAR ,  JIAQI WANG ,  PAVAS NAVANEY

IPC: G06F16/23

CPC classification number: G06F16/2379 ,  G06F16/2343

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.

公开(公告)号：US20240126741A1

公开(公告)日：2024-04-18

申请号：US18223822

申请日：2023-07-19

Applicant: Oracle International Corporation

Inventor： VASUDHA KRISHNASWAMY ,  DIETER GAWLICK ,  TIRTHANKAR LAHIRI ,  WEIWEI GONG

IPC: G06F16/23

CPC classification number: G06F16/2343 ,  G06F16/2379

Abstract: A Lock-Free Reservation mechanism is provided. When a transaction issues an update that affects a value in a “reservable column” of a row, the database server does not immediately obtain a lock that covers the row. Instead, the database server adds a reservation to a reservation journal. At the time the transaction commits, a lock is obtained and the requested update is made. In one implementation, before adding the reservation to the reservation journal, the database server determines whether making the update would violate any constraints involving the reservable column. In one implementation, the constraint check not only takes into account the current value of the data item that is being updated and the amount of the update, but also pre-existing reservations in the reservation journal that affect the same data item.