- Patent Title: Database redo log optimization by skipping MVCC redo log records
-
Application No.: US15410701Application Date: 2017-01-19
-
Publication No.: US10915413B2Publication Date: 2021-02-09
- Inventor: Martin Heidel , Andreas Tonder , Shiping Chen
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Jones Day
- Main IPC: G06F11/14
- IPC: G06F11/14 ; G06F16/21

Abstract:
Restoring of a database table in the database system (e.g., an in-memory insert-only database system, etc.) is initiated. Thereafter, a transaction log volume storing data log records and multi-version concurrency control (MVCC) log records corresponding to the database table is accessed. Based on such access, data log records corresponding to the database table are replayed while insert and update MVCC log records corresponding to the database table are skipped. Subsequently, restoring of the database table in the database system is finalized. Related apparatus, systems, techniques and articles are also described.
Public/Granted literature
- US20180203771A1 Database Redo Log Optimization by Skipping MVCC Redo Log Records Public/Granted day:2018-07-19
Information query