Database recovery using logs applied to consistent copies
US8671076B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | May 8, 2007 |
| Grant date | Mar 11, 2014 |
| Priority date | — |
| Expiry date | May 5, 2032 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2365
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A copy utility creates a copy of source database objects that is transactionally consistent to a consistent point-in-time, and a recovery utility applies log records to the consistent copy to make a resulting image that is updated as of an identified point-in-time (i.e., the current time or a point-in-time after the copy was made). To effectively recover and apply the logs so that no previously in-flight transactions are lost, the copy utility registers a starting point indicating a point-in-time for logs to be applied to the copy and also registers a smallest lock size used to block access to target data when the copy was made. The recovery utility bases its recovery operations using the registered starting point and the smallest lock size when applying log records to the copy so as not to lose any previously in-flight transactions.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.