Patent US6397227B1 successfully refreshed from Google Patents.
US6397227B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Database management system and method for updating specified tuple fields upon transaction rollback
Assignee: Compaq Information Technologies Group LP
•
Filing: 1999-07-06
•
Granted: 2002-05-28
•
Expires: 2019-07-06
Abstract
Abstract A database management system includes an execution engine that, upon rollback of an aborted transaction, has the ability to set fields of the rows that are updated or deleted by the transaction prior to aborting. In particular, when a select, update or delete statement includes a “set on rollback” clause, the respective table access operator of the execution engine modifies the “before image” of each row that is stored by the transaction log manager. The modified before image includes the field updates specified by the set on rollback clause. If a transaction associated with the statement aborts, when the transaction log manager restores the before images of each row that was deleted or updated by the transaction, the restored before images include the field updates specified by the set on rollback clause.
Inventors
- 👤 Johannes Klein
- 👤 Robbert C. Van der Linden
- 👤 Raj K. Rathee
- 👤 Anoop Sharma
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-04 17:58
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; G06F16/2455; G06F16/24568; G06F16/23; G06F16/2308; G06F16/2336; G06F16/2343; G06F16/2379; G06F16/242; G06F16/2433; G06F16/2445; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99938
Claims Analysis
Total Claims: 12
Claim 1
Independent Claim
194 words
A method of processing data in a database management system, in accordance with a specified statement, comprising: starting execution of a transaction; establishing a table access operator for accessing a defined range of rows in a database table; using the table access operator, performing an update or delete operation on qualifying rows, if any, from the database table, in accordance with the specified statement; for each updated or deleted row, storing a before image of the row, the before image representing field values of the row prior to the update or delete operation; when the specified statement includes a predefined set on rollback clause that specifies updates to be performed, in the event of a transaction rollback, to one or more fields of each row updated or deleted by the transaction, modifying the before image of said each updated or deleted row, prior to the before image being stored, by performing the specified updates to the one or more fields of the row; in the event that execution of the transaction is aborted, performing a rollback in which the stored before images of the updated or deleted rows are restored to the database table.
Claim 2
Independent Claim
194 words
A method of processing data in a database management system, in accordance with a specified statement, comprising: starting execution of a transaction; establishing a table access operator for accessing a defined range of rows in a database table; using the table access operator, performing an update or delete operation on qualifying rows, if any, from the database table, in accordance with the specified statement; for each updated or deleted row, storing a before image of the row, the before image representing field values of the row prior to the update or delete operation; when the specified statement includes a predefined set on rollback clause that specifies updates to be performed, in the event of a transaction rollback, to one or more fields of each row updated or deleted by the transaction, modifying the before image of said each updated or deleted row, prior to the before image being stored, by performing the specified updates to the one or more fields of the row; in the event that execution of the transaction is aborted, performing a rollback in which the stored before images of the updated or deleted rows are restored to the database table.
Claim 3
Independent Claim
181 words
A method of processing data in a database management system, comprising: starting execution of a transaction; establishing a table access operator for accessing a defined range of rows in a database table in accordance with a specified statement, the specified statement including a clause indicating modifications that are to be performed, in the event of a transaction rollback, to one or more fields of each row that is updated or deleted by the transaction; using the table access operator, performing an update or delete operation on qualifying rows, if any, from the database table, in accordance with the specified statement; and in the event that execution of the transaction is aborted: performing a rollback in which the updated or deleted rows are restored to the database table so as to reverse the update or delete operation performed on the updated or deleted rows, and modifying one or more fields of each row that is restored to the database table in accordance with the clause of the specified statement indicating the modifications that are to be performed upon rollback of the transaction.
Claim 4
Independent Claim
181 words
A method of processing data in a database management system, comprising: starting execution of a transaction; establishing a table access operator for accessing a defined range of rows in a database table in accordance with a specified statement, the specified statement including a clause indicating modifications that are to be performed, in the event of a transaction rollback, to one or more fields of each row that is updated or deleted by the transaction; using the table access operator, performing an update or delete operation on qualifying rows, if any, from the database table, in accordance with the specified statement; and in the event that execution of the transaction is aborted: performing a rollback in which the updated or deleted rows are restored to the database table so as to reverse the update or delete operation performed on the updated or deleted rows, and modifying one or more fields of each row that is restored to the database table in accordance with the clause of the specified statement indicating the modifications that are to be performed upon rollback of the transaction.
Claim 5
Dependent Claim
205 words
A database management system, comprising: a transaction management facility for managing execution of transactions; a database, including a plurality of tables, each table storing data in one or more rows; an execution engine for performing an update or delete operation on qualifying rows, if any, from one of the database tables, in accordance with the specified statement; a transaction log manager for storing, for each updated or deleted row, a before image of the row, the before image representing field values of the row prior to the update or delete operation; before image generation means, operative when the specified statement includes a predefined set on rollback clause that specifies updates to be performed, in the event of a transaction rollback, to one or more fields of each row updated or deleted by the transaction, for modifying the before image of said each updated or deleted row, prior to the before image being stored, by performing the specified updates to the one or more fields of the row; the transaction management facility including means for performing a rollback in the event that execution of the transaction is aborted, so as to restore to the database table the stored before images of the updated or deleted rows.
Claim 6
Dependent Claim
205 words
A database management system, comprising: a transaction management facility for managing execution of transactions; a database, including a plurality of tables, each table storing data in one or more rows; an execution engine for performing an update or delete operation on qualifying rows, if any, from one of the database tables, in accordance with the specified statement; a transaction log manager for storing, for each updated or deleted row, a before image of the row, the before image representing field values of the row prior to the update or delete operation; before image generation means, operative when the specified statement includes a predefined set on rollback clause that specifies updates to be performed, in the event of a transaction rollback, to one or more fields of each row updated or deleted by the transaction, for modifying the before image of said each updated or deleted row, prior to the before image being stored, by performing the specified updates to the one or more fields of the row; the transaction management facility including means for performing a rollback in the event that execution of the transaction is aborted, so as to restore to the database table the stored before images of the updated or deleted rows.
Claim 7
Dependent Claim
167 words
A database management system, comprising: a transaction management facility for managing execution of transactions; a database, including a plurality of tables, each table storing data in one or more rows; an execution engine for performing an update or delete operation on qualifying rows, if any, from one of the database table, in accordance with a specified statement, the specified statement including a clause indicating modifications that are to be performed, in the event of a transaction rollback, to one or more fields of each row that is updated or deleted by the transaction; the transaction management facility including means for: performing a rollback in the event that execution of the transaction is aborted, so as to reverse the update or delete operation performed on the updated or deleted rows, and modifying one or more fields of each row that is restored to the database table in accordance with the clause of the specified statement indicating the modifications that are to be performed upon rollback of the transaction.
Claim 8
Dependent Claim
167 words
A database management system, comprising: a transaction management facility for managing execution of transactions; a database, including a plurality of tables, each table storing data in one or more rows; an execution engine for performing an update or delete operation on qualifying rows, if any, from one of the database table, in accordance with a specified statement, the specified statement including a clause indicating modifications that are to be performed, in the event of a transaction rollback, to one or more fields of each row that is updated or deleted by the transaction; the transaction management facility including means for: performing a rollback in the event that execution of the transaction is aborted, so as to reverse the update or delete operation performed on the updated or deleted rows, and modifying one or more fields of each row that is restored to the database table in accordance with the clause of the specified statement indicating the modifications that are to be performed upon rollback of the transaction.
Claim 9
Dependent Claim
238 words
A computer program product for use in conjunction with a computer system, the computer system including a database, including a plurality of tables, each table storing data in one or more rows; the computer program product comprising a computer readable storage medium and a computer program mechanism embedded therein, the computer program mechanism comprising: a transaction management facility for managing execution of transactions; an execution engine for performing an update or delete operation on qualifying rows, if any, from one of the database tables, in accordance with the specified statement; a transaction log manager for storing, for each updated or deleted row, a before image of the row, the before image representing field values of the row prior to the update or delete operation; before image generation means, operative when the specified statement includes a predefined set on rollback clause that specifies updates to be performed, in the event of a transaction rollback, to one or more fields of each row updated or deleted by the transaction, for modifying the before image of said each updated or deleted row, prior to the before image being stored, by performing the specified updates to the one or more fields of the row; the transaction management facility including means for performing a rollback in the event that execution of the transaction is aborted, so as to restore to the database table the stored before images of the updated or deleted rows.
Claim 10
Dependent Claim
238 words
A computer program product for use in conjunction with a computer system, the computer system including a database, including a plurality of tables, each table storing data in one or more rows; the computer program product comprising a computer readable storage medium and a computer program mechanism embedded therein, the computer program mechanism comprising: a transaction management facility for managing execution of transactions; an execution engine for performing an update or delete operation on qualifying rows, if any, from one of the database tables, in accordance with the specified statement; a transaction log manager for storing, for each updated or deleted row, a before image of the row, the before image representing field values of the row prior to the update or delete operation; before image generation means, operative when the specified statement includes a predefined set on rollback clause that specifies updates to be performed, in the event of a transaction rollback, to one or more fields of each row updated or deleted by the transaction, for modifying the before image of said each updated or deleted row, prior to the before image being stored, by performing the specified updates to the one or more fields of the row; the transaction management facility including means for performing a rollback in the event that execution of the transaction is aborted, so as to restore to the database table the stored before images of the updated or deleted rows.
Claim 11
Dependent Claim
200 words
A computer program product for use in conjunction with a computer system, the computer system including a database, including a plurality of tables, each table storing data in one or more rows; the computer program product comprising a computer readable storage medium and a computer program mechanism embedded therein, the computer program mechanism comprising: a transaction management facility for managing execution of transactions; an execution engine for performing an update or delete operation on qualifying rows, if any, from one of the database table, in accordance with a specified statement, the specified statement including a clause indicating modifications that are to be performed, in the event of a transaction rollback, to one or more fields of each row that is updated or deleted by the transaction; the transaction management facility including means for: performing a rollback in the event that execution of the transaction is aborted, so as to reverse the update or delete operation performed on the updated or deleted rows, and modifying one or more fields of each row that is restored to the database table in accordance with the clause of the specified statement indicating the modifications that are to be performed upon rollback of the transaction.
Claim 12
Dependent Claim
200 words
A computer program product for use in conjunction with a computer system, the computer system including a database, including a plurality of tables, each table storing data in one or more rows; the computer program product comprising a computer readable storage medium and a computer program mechanism embedded therein, the computer program mechanism comprising: a transaction management facility for managing execution of transactions; an execution engine for performing an update or delete operation on qualifying rows, if any, from one of the database table, in accordance with a specified statement, the specified statement including a clause indicating modifications that are to be performed, in the event of a transaction rollback, to one or more fields of each row that is updated or deleted by the transaction; the transaction management facility including means for: performing a rollback in the event that execution of the transaction is aborted, so as to reverse the update or delete operation performed on the updated or deleted rows, and modifying one or more fields of each row that is restored to the database table in accordance with the clause of the specified statement indicating the modifications that are to be performed upon rollback of the transaction.
References Cited (Backward Citations)
US4967341A
Cited
US5386557A
Cited
US5721909A
Cited
US5835757A
Cited
US5884327A
Cited
US6266669B1
Cited
US5951695A
Cited
US5983225A
Cited
US6112209A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-05-27 | 2005-11-26 | 2006-05-28 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-05-27 | 2009-11-26 | 2010-05-28 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-05-27 | 2013-11-26 | 2014-05-28 | $7700.00 | Window Closed / Lapsed |