US 9,811,549 B2
Applying a database transaction log record directly to a database table container
Ivan Schreter, Mannheim (DE); Shiping Chen, San Francisco, CA (US); David Wein, Saint Paul, MN (US); and Steffen Geiβinger, Stuttgart (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by Ivan Schreter, Mannheim (DE); Shiping Chen, San Francisco, CA (US); David Wein, Saint Paul, MN (US); and Steffen Geiβinger, Stuttgart (DE)
Filed on Nov. 25, 2014, as Appl. No. 14/552,914.
Prior Publication US 2016/0147778 A1, May 26, 2016
Int. Cl. G06F 17/30 (2006.01)
CPC G06F 17/30371 (2013.01) [G06F 17/30368 (2013.01)] 18 Claims
OG exemplary drawing
 
1. A computer implemented method for restoring a database from a log volume, comprising:
reading, by one or more computing devices, a log record from the log volume, wherein the log record includes information for restoring a database transaction that is not savepointed to a persistent storage;
interpreting, by the one or more computing devices, a page of a table in the database that is associated with the database transaction as a portion of an index vector that identifies one or more values in a column of the table, wherein the page is stored in the persistent storage;
performing, by the one or more computing devices, a direct modification of the portion of the index vector and a dictionary based on the log record, wherein the dictionary is associated with the index vector; and
applying, by the one or more computing devices, the database transaction to the database without replaying the log record as a query, wherein the applying comprises updating the table in the database on the persistent storage based on the modified portion of the index vector and the modified dictionary.