Method and apparatus for efficiently recovering from a failure in a database that includes unlogged objects
US6567928B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | May 23, 2000 |
| Grant date | May 20, 2003 |
| Priority date | — |
| Expiry date | May 23, 2020 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99953
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Database tables which are to be loaded with large data objects (LOBs) are defined with a special logging attribute value. This attribute value causes the database management system to suspend recovery logging for the databases so defined, but to continue with the logging of control information, such as space management changes. Certain control information recovery log entries have a special status indicator. For LOBs, this status indicator is set to cause the associated LOB entry to be marked as invalid when the log entry is reapplied, for example, during a recovery operation from a media failure. Rather than invalidating the entire table, the database management system will only prevent access to the entries which have been invalidated during the recovery process.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.