Redo avoidance during database recovery
US12253916B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jan 31, 2023 |
| Grant date | Mar 18, 2025 |
| Priority date | — |
| Expiry date | Jan 31, 2043 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F2201/84
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Techniques are disclosed relating to a database recovery routine to start up a database system in response to a database failure. The database system accesses checkpoint information identifying a set of active database transactions that were active at a flush point that occurred before the database failure. As a part of the database recovery routine, the database system replays database transactions that occurred between a recovery point and the flush point. The database transactions include the set of active database transactions but exclude any committed or aborted database transactions that occurred between the recovery point and the flush point such that less than a total number of database transactions occurring between the recovery point and the flush point are replayed. The database system further replays, without excluding committed or aborted database transactions, database transactions occurring between the flush point and a recovery end point at which the database failure occurred.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.