Method and apparatus for improved transaction recovery
US5850507A · kind A · utility
Assignee
Inventors
Key dates
| Filing date | Mar 19, 1996 |
| Grant date | Dec 15, 1998 |
| Priority date | — |
| Expiry date | Mar 19, 2016 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99953
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and system for recovering after a crash of an instance in a database is disclosed. According to the method, transaction information corresponding to all the transactions that existed in the failed instance is inspected. These transactions that were active at the time the instance crashed are marked as "dead." The database is made available to users after updating the transaction information and before undoing all of the changes or updates performed by dead transactions. The changes made by the dead transactions may be undone by new transactions on a on-demand basis after the database is made available. Specifically, when a new transaction is waiting to obtain a lock on a resource held by another transaction, the new transaction determines whether the owner of the lock is one of the dead transactions. If so, the new transaction rolls back some or all of the changes made by the dead transaction.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.