Providing transaction undo without logging
AssigneeInternational Business Machines Corporation
InventorsJulie Ann Watts, Steven John Watts
Life of this patent
Estimating the term…
Abstract
A technique for undoing a transaction that changes data in a database. In accordance with the present invention, the database contains at least one data unit. The database is stored in a data storage device connected to a computer. A lock, transaction identifier, transaction operation indicator, and data unit, are associated with the transaction. The invention undoes the transaction using the associated lock, transaction identifier, transaction operation indicator, and data unit.
Claims57
A method for undoing a transaction that changes data in a database, the database having at least one data unit, wherein the database is stored in a data storage device connected to a computer, the method comprising the steps of:
- associating a lock, transaction identifier, transaction operation indicator, and data unit with the transaction;
- and
- undoing the transaction by interrogating the associated lock, and using the transaction identifier, transaction operation indicator, and data unit.
An apparatus for undoing a transaction that changes data in a database, comprising:
- a computer having a data storage device connected thereto, wherein the data storage device stores a database having at least one data unit;
- and
- one or more computer programs, performed by the computer, for associating a lock, transaction identifier, transaction operation indicator, and data unit with the transaction, and by interrogating the associated lock, and using the transaction identifier, transaction operation indicator, and data unit to undo the transaction.
An article of manufacture comprising a computer program carrier readable by a computer and embodying one or more instruction executable by the computer to perform method steps for undoing an transaction that changes data in a database, the database having at least one data unit, wherein the database is stored in a data storage device connected to the computer, the method comprising the steps of:
- associating a lock, transaction identifier, transaction operation indicator, and data unit with the transaction;
- and
- undoing the transaction by interrogating the associated lock, and using the transaction identifier, transaction operation indicator, and data unit.
Dependencies are inferred from the claim text.