Invention Grant
- Patent Title: Transaction commit protocol with recoverable commit identifier
-
Application No.: US16944015Application Date: 2020-07-30
-
Publication No.: US11874746B2Publication Date: 2024-01-16
- Inventor: Christian Bensberg , Steffen Geissinger , Juchang Lee , Chang Gyoo Park , Kyu Hwan Kim , Deok Koo Kim
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Klarquist Sparkman, LLP
- Main IPC: G06F11/14
- IPC: G06F11/14

Abstract:
Technologies are described for facilitating database system recovery in a distributed database environment having a master node and at least one slave node. The master node maintains an in-memory reference that includes transaction identifiers and their corresponding commit identifiers. When a slave node requests that a commit identifier be assigned to a transaction, the transaction and commit identifiers for the transaction are added to the in-memory reference. The commit identifier is sent by the master node to the slave node. The slave node writes a log entry to a commit log that includes the transaction identifier and the assigned commit identifier. If the database system is interrupted before the slave node writes the commit log entry, the slave node can request the commit identifier for the transaction from the master node, which retrieves the identifier from the in-memory reference.
Information query