Method and apparatus for improved transaction recovery

Details Method and apparatus for improved transaction recovery Method and apparatus for improved transaction recovery

1996-03-19

1998-12-15

Palys, Joseph

Data processing: database and file management or data structures

Database design

Data structure types

39518217, 707202, G06F 1100, G06F 1114

Patent

active

058505075

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.

REFERENCES:
patent: 5065311 (1991-11-01), Masai et al.
patent: 5155678 (1992-10-01), Fukumoto et al.
patent: 5201044 (1993-04-01), Frey, Jr. et al.
patent: 5280611 (1994-01-01), Mohan et al.
patent: 5333303 (1994-07-01), Mohan
patent: 5440727 (1995-08-01), Bhide et al.
patent: 5481699 (1996-01-01), Saether
patent: 5524205 (1996-06-01), Lomet et al.
patent: 5524239 (1996-06-01), Fortier
patent: 5524241 (1996-06-01), Ghoneimy et al.
patent: 5551046 (1996-08-01), Mohan et al.
patent: 5561795 (1996-10-01), Sarkar
patent: 5630047 (1997-05-01), Wang
Mohan et al., Aries-RRH: Restricted Repeating of History in TEH Aries Transaction Recovery Method, Data Engineering, 7th int'l . Conference, IEEE, pp. 718-727. 1991.

Affiliated with

Also associated with

Rating

Method and apparatus for improved transaction recovery does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for improved transaction recovery, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for improved transaction recovery will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1463878