Patent · US Active

Database redo log optimization by skipping MVCC redo log records

US10915413B2 · kind B2 · utility

0Cited by

0References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Martin Heidel · Walldorf, DE
Andreas Tonder · Weinheim, DE
Shiping Chen · Pleasanton, US

Key dates

Filing date	Jan 19, 2017
Grant date	Feb 9, 2021
Priority date	—
Expiry date	Nov 24, 2037

Classification

Technology area (CPC G)Physics
CPC primaryG06F2201/80
WIPO fieldComputer technology
WIPO sectorElectrical engineering

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.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.