US 12,436,943 B2
Mechanisms for efficient point-in-time creation and maintenance in a distributed database
Erez Webman, Petach Tikva (IL); Irit Yadin-Lempel, Caesarea (IL); Eran Borovik, Zikhron Ya'akov (IL); and Hilla Atzmon, Haifa (IL)
Assigned to Regatta Data Ltd., Bet Hanania (IL)
Filed by Regatta Data Ltd., Bet Hanania (IL)
Filed on Feb. 2, 2024, as Appl. No. 18/431,285.
Claims priority of provisional application 63/499,566, filed on May 2, 2023.
Prior Publication US 2024/0370427 A1, Nov. 7, 2024
Int. Cl. G06F 16/23 (2019.01); G06F 16/215 (2019.01); G06F 16/27 (2019.01)
CPC G06F 16/2379 (2019.01) [G06F 16/215 (2019.01); G06F 16/27 (2019.01)] 45 Claims
OG exemplary drawing
 
1. A method for managing execution of database transactions by facilitating point-in-time image (PiT), comprising:
receiving at least one statement being part of a transaction, wherein the transaction is initiated by a client to be executed on a distributed database system;
sending a single request to a sequencer server (SEQ-server) to create at least one PiT, wherein the SEQ-server provides a logical timestamp counter (LTC) value as a timestamp of the PiT;
upon creation of the at least one PiT, causing execution of the at least one statement, wherein a PiT provides a state and content of committed data in the distributed database system;
upon receiving a commit statement, performing a commitment process of the transaction, wherein the commitment process is based on a commitment timestamp (CMTS) set by the SEQ-server based on an incremented value of the LTC; and
returning an acknowledgment of the transaction commitment to the client.