Invention Grant
- Patent Title: Efficient database undo / redo logging
-
Application No.: US14553833Application Date: 2014-11-25
-
Publication No.: US09779104B2Publication Date: 2017-10-03
- Inventor: Mihnea Andrei , Ivan Schreter , David Wein , Shiping Chen , Panfeng Zhou , Steffen Geissinger
- Applicant: Mihnea Andrei , Ivan Schreter , David Wein , Shiping Chen , Panfeng Zhou , Steffen Geissinger
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Mintz Levin Cohn Ferris Glovsky and Popeo, P.C.
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F11/14

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.
Public/Granted literature
- US20160147786A1 Efficient Database Undo / Redo Logging Public/Granted day:2016-05-26
Information query