Bmc Software, Inc.

Vladimir Prasolov

William J Pothoff

Thomas G Price

Konstantin Lavren Bobovich

A captured sequence of log records for a copy of a database may be inspected to identify an obviating log record at a captured sequence position of the captured sequence and related to a page of the plurality of pages, the obviating log record corresponding to an obviating change that replaces an earlier change of an earlier log record. The captured sequence of log records may be sorted into an applied sequence of log records for applying changes of the sequence of changes, in which the obviating log record is moved from the captured sequence position to an applied sequence position that is prior to the earlier sequence position of the earlier log record. The database may then be recovered using the applied sequence of log records.

Optimization of log record application during database recovery

A method to efficiently create a consistent image of a database index at any point-in-time by reversing the effect of uncommitted updates by applying database transaction logs to an index page set in a single pass. The created image can be used to recover the database index to a point in time that is consistent with its associated table, or for physical migration where data and indexes are migrated to another database that may or may not be on the same DBMS and the indexes and data must be consistent as of the same point in time.

Growing community of inventors

Tel Hai, Israel

Vladimir Prasolov