Patent · US Active

Applying a database transaction log record directly to a database table container

US9811549B2 · kind B2 · utility

6Cited by

4References

18Claims

0Family size

Assignee

SAP SE · DE

Inventors

Ivan Schreter · Malsch, DE
Shiping Chen · Pleasanton, US
David Wein · Windom, US
Steffen Geiβinger · Stuttgart, DE

Key dates

Filing date	Nov 25, 2014
Grant date	Nov 7, 2017
Priority date	—
Expiry date	Oct 22, 2035

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/2358
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

Disclosed herein are system, method, and computer program product embodiments for directly restoring a database from a log volume. An embodiment operates by reading one or more database transaction log records from a log volume. The embodiment then loads from a database table persistent storage one or more pages containing rows in the database table that will be read from or written to by the one or more database transaction log records. The embodiment then loads a dictionary for each column associated with the one or more database transaction log records. The embodiment then applies the one or more database transaction log records directly into the one or more loaded pages and the one or more dictionaries. Each dictionary and page modified in memory is then written to the database table persistent storage when a savepoint operation is performed.

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