Invention Grant
- Patent Title: Providing consistent database recovery after database failure for distributed databases with non-durable storage leveraging background synchronization point
-
Application No.: US16522419Application Date: 2019-07-25
-
Publication No.: US11188516B2Publication Date: 2021-11-30
- Inventor: Derek Taylor , Chi-Kim Hoang , Yu-Han Chou , Varadarajan Aravamudhan
- 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
- Agency: Hickman Becker Bingham Ledesma LLP
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F16/27

Abstract:
An approach for consistent database recovery for distributed database systems uses “synchronization points”. A synchronization point is a global timestamp for which across all nodes of a distributed database system, the nodes have stored change records for any transaction occurring at and before the synchronization point in persistent logs. Each node may employ asynchronous flushing. However, on a periodic basis, each node coordinates to establish a synchronization point, which may entail ensuring change records for transactions that committed at or before the synchronization point are stored in persistent logs. In effect, a synchronization point represents that any transaction committed at or before the synchronization point has been durably committed.
Public/Granted literature
Information query