System and method for transaction-selective rollback reconstruction of database objects
US6769074B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | May 21, 2001 |
| Grant date | Jul 27, 2004 |
| Priority date | — |
| Expiry date | Jan 3, 2023 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99952
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Most commercial database systems provide a recovery mechanism that is used to restore data integrity in the event of a hardware or software failure. Many of these systems restore the database from the most recent backup file by rolling forward all transactions from the most recent undamaged transaction log. The present invention discloses a novel system and method for recovering data from user or application errors. Embodiments of the present invention selectively target and undo only those transactions that caused data corruption. In this way, the present invention is able to recover fine-grained database objects such as a table or a row within a table. The present invention has the further advantage of minimizing the number of transactions that are lost after recovery.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.