Patent · US Active

Systems and methods for recovery of consistent database indexes

US10565070B2 · kind B2 · utility

0Cited by

2References

30Claims

0Family size

Assignee

BMC Software, Inc. · US

Inventors

William J. Pothoff · Austin, US
Thomas Price · San Francisco, US
Vladimir Prasolov · Ramat Gan, IL

Key dates

Filing date	Nov 29, 2017
Grant date	Feb 18, 2020
Priority date	—
Expiry date	Jun 30, 2038

Classification

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

Abstract

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.

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