Method and apparatus for improved transaction recovery

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 5850507
SERIAL NO

08618443

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

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.

Loading the Abstract Image... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddress
ORACLE INTERNATIONAL CORPORATION500 ORACLE PARKWAY M/S 50P7 REDWOOD SHORES CA 94065

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Ngai, Gary C Saratoga, CA 18 1129
Rizvi, Hasan Fremont, CA 14 815
Tan, Leng Leng Sunnyvale, CA 11 649

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation