Patent · US Active

Efficient database undo / redo logging

US9779104B2 · kind B2 · utility

2Cited by

24References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Mihnea Andrei · Issy-les-Moulineaux, FR
Ivan Schreter · Malsch, DE
David Wein · Windom, US
Shiping Chen · Pleasanton, US
Panfeng Zhou · Dublin, US
Steffen Geissinger · Wiesloch, DE

Key dates

Filing date	Nov 25, 2014
Grant date	Oct 3, 2017
Priority date	—
Expiry date	Oct 30, 2035

Classification

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

Abstract

Log records are accessed as part of a database operation in a database. The log records log insert, update, and delete operations in the database and include, for each row, a row position, a fragment identifier (ID), and a row ID. Thereafter, as part of the database operation, rows specified by the log records are located by: using the fragment identifier and the row position within the corresponding record of the log if the fragment with the corresponding fragment identifier is still available, otherwise, using the row identifier within the corresponding record of the log to look up the row position in an index of a corresponding row identifier column. The database operation is then finalized using the located rows. Related apparatus, systems, techniques and articles are also described.

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