US Patent No: 6,647,510
Number of patents in Portfolio can not be more than 2000
Method and apparatus for making available data that was locked by a dead transaction before rolling back the entire dead transaction
Stats
-
Nov 11, 2003
Issued date -
Dec 22, 2000
filing date -
09/748,408
serial no -
In Force
status
Importance
Loading Importance Indicators...
Abstract
A method and apparatus for removing changes made by a dead transaction is provided. According to the method, a first change is performed by the dead transaction prior to a second change. The first change made by the dead transaction is then undone prior to undoing the second change made by the dead transaction. According to another aspect of the invention, a method and apparatus for applying changes in redo records to make a particular resource reflect changes made to the particular resource in volatile memory before a failure is provided. The method includes establishing links that link together a set of redo records that contain changes made to the particular resource. The links are then followed to apply the changes contained in the set of redo records to cause the particular resource to reflect the changes made to the particular resource in volatile memory before the failure. According to another aspect of the invention, a method and apparatus for applying changes in two or more redo records in parallel is provided. According to the method, a plurality of resources are locked by a dead transaction. A plurality of sets of redo records are established that do not contain any redo records that depend on any redo records in any other set of redo records. The plurality of sets of redo records are applied in parallel relative to one another.
Loading the Abstract Image...
First Claim
Related Publications
Loading Related Publications...
International Classification(s)
- [Classification Symbol]
- [Patents Count]
Cited Art
| Patent Info | (Count) | # Cites | Year |
|---|---|---|---|
|
|
|||
| 5,155,678 Data availability in restartable data base system | 74 | 1985 | |
| 5,170,480 Concurrently applying redo records to backup database in a log sequence using single queue server per queue at a time | 198 | 1989 | |
| 5,201,044 Data processing method for file status recovery includes providing a log file of atomic transactions that may span both volatile and non volatile memory | 211 | 1990 | |
| 5,333,303 Method for providing data availability in a transaction-oriented system during restart after a failure | 49 | 1991 | |
| 5,280,611 Method for managing database recovery from failure of a shared store in a system including a plurality of transaction-based systems of the write-ahead logging type | 145 | 1991 | |
| 5,551,046 Method for non-hierarchical lock management in a multi-system shared data environment | 101 | 1994 | |
| 5,440,727 Asynchronous replica management in shared nothing architectures | 110 | 1994 | |
| 6,185,699 Method and apparatus providing system availability during DBMS restart recovery | 35 | 1998 | |
|
|
|||
| 5,524,205 Methods and apparatus for optimizing undo log usage | 112 | 1993 | |
| 5,485,608 Methods and apparatus for updating information in a computer system using logs and state identifiers | 74 | 1994 | |
| 5,850,507 Method and apparatus for improved transaction recovery | 54 | 1996 | |
| 6,185,577 Method and apparatus for incremental undo | 51 | 1998 | |
| 6,182,241 Method and apparatus for improved transaction recovery | 26 | 1998 | |
| 6,295,610 Recovering resources in parallel | 40 | 1998 | |
|
|
|||
| 5,335,343 Distributed transaction processing using two-phase commit protocol with presumed-commit without log force | 57 | 1992 | |
| 5,596,710 Method for managing roll forward and roll back logs of a transaction object | 21 | 1994 | |
| 5,481,699 Durable atomic storage update manager | 80 | 1995 | |
| 5,524,241 System and method for executing, tracking and recovering long running computations | 49 | 1995 | |
|
|
|||
| 5,065,311 Distributed data base system of composite subsystem type, and method fault recovery for the system | 73 | 1988 | |
| 5,333,314 Distributed data base system of composite subsystem type, and method of fault recovery for the system | 71 | 1991 | |
|
|
|||
| 5,819,020 Real time backup system | 159 | 1995 | |
| 5,974,563 Real time backup system | 405 | 1998 | |
|
|
|||
| 5,561,795 Method and apparatus for audit trail logging and data base recovery | 84 | 1994 | |
| 5,734,817 Method for making a data base available to a user program during data base recovery | 30 | 1995 | |
|
|
|||
| 5,857,204 Restoring the state of a set of files | 45 | 1996 | |
|
|
|||
| 5,630,047 Method for software error recovery using consistent global checkpoints | 80 | 1995 | |
|
|
|||
| 6,067,550 Database computer system with application recovery and dependency handling write cache | 45 | 1997 | |
|
|
|||
| 5,933,838 Database computer system with application recovery and recovery log sequence numbers to optimize recovery | 86 | 1997 | |
|
|
|||
| 5,524,239 Replay recovery protocol for real-time database management systems | 7 | 1994 | |
Patent Citation Ranking
Maintenance Fees
| Fee | Large entity fee | small entity fee | micro entity fee | due date |
|---|---|---|---|---|
| 11.5 Year Payment | $7400.00 | $3700.00 | $1850.00 | May 11, 2015 |
| Fee | Large entity fee | small entity fee | micro entity fee |
|---|---|---|---|
| Surcharge - 11.5 year - Late payment within 6 months | $160.00 | $80.00 | $40.00 |
| Surcharge after expiration - Late payment is unavoidable | $700.00 | $350.00 | $175.00 |
| Surcharge after expiration - Late payment is unintentional | $1,640.00 | $820.00 | $410.00 |