Delegation of database post-commit processing
First Claim
Patent Images
1. A method comprising:
- handling a plurality of transactions in a database, each transaction comprising a plurality of operations on at least one record in the database, at least two of the transactions of the plurality of transactions being handled concurrently by separate handling processes;
assigning a temporary timestamp to each record, the temporary timestamp being based, at least in part, on the corresponding transaction;
committing a first transaction among the plurality of transactions; and
delegating, after committing of the first transaction, re-stamping of at least one temporary timestamp for a first record of the at least one record in the database, the first record being modified by the first transaction, the delegating comprising causing a different process than the handling process for the first transaction to perform the re-stamping, the delegating further comprising passing an undo file identifying a plurality of commit timestamps to be processed to a history manager, re-stamping transaction control block states for a plurality of transaction control blocks corresponding to the commit timestamps, and setting the re-stamped transaction control blocks as free.
2 Assignments
0 Petitions
Accused Products
Abstract
A plurality of transactions are handled in a database. Each transaction comprises a plurality of operations on at least one record in the database with at least two of the transactions being handled concurrently. Thereafter, a temporary timestamp is assigned to each record that is based, at least in part, on the corresponding transaction. A first transaction among the plurality of transactions is subsequently committed. Afterwards, re-stamping of at least one commit timestamp modified by the first transaction is delegated. Related apparatus, systems, techniques and articles are also described.
-
Citations
18 Claims
-
1. A method comprising:
-
handling a plurality of transactions in a database, each transaction comprising a plurality of operations on at least one record in the database, at least two of the transactions of the plurality of transactions being handled concurrently by separate handling processes; assigning a temporary timestamp to each record, the temporary timestamp being based, at least in part, on the corresponding transaction; committing a first transaction among the plurality of transactions; and delegating, after committing of the first transaction, re-stamping of at least one temporary timestamp for a first record of the at least one record in the database, the first record being modified by the first transaction, the delegating comprising causing a different process than the handling process for the first transaction to perform the re-stamping, the delegating further comprising passing an undo file identifying a plurality of commit timestamps to be processed to a history manager, re-stamping transaction control block states for a plurality of transaction control blocks corresponding to the commit timestamps, and setting the re-stamped transaction control blocks as free. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A non-transitory computer program product storing instructions which, when executed by at least one hardware data processor forming part of at least one computing device, result in operations comprising:
-
handling a plurality of transactions in a database, each transaction comprising a plurality of operations on at least one record in the database, at least two of the transactions of the plurality of transactions being handled concurrently by separate handling processes; assigning a temporary timestamp to each record, the temporary timestamp being based, at least in part, on the corresponding transaction; committing a first transaction among the plurality of transactions; and delegating, after committing of the first transaction, re-stamping of at least one temporary timestamp for a first record of the at least one record in the database, the first record being modified by the first transaction, the delegating comprising causing a different process than the handling process for the first transaction to perform the re-stamping, the delegating further comprising passing an undo file identifying a plurality of commit timestamps to be processed to a history manager, re-stamping transaction control block states for a plurality of transaction control blocks corresponding to the commit timestamps, and setting the re-stamped transaction control blocks as free. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17)
-
-
18. A system comprising:
-
at least one hardware data processor; and memory storing instructions which, when executed by the at least one hardware data processor, result in operations comprising; handling a plurality of transactions in a database, each transaction comprising a plurality of operations on at least one record in the database, at least two of the transactions of the plurality of transactions being handled concurrently by separate handling processes; assigning a temporary timestamp to each record, the temporary timestamp being based, at least in part, on the corresponding transaction; committing a first transaction among the plurality of transactions; and delegating, after committing of the first transaction, re-stamping of at least one temporary timestamp for a first record of the at least one record in the database, the first record being modified by the first transaction, the delegating comprising causing a different process than the handling process for the first transaction to perform the re-stamping, the delegating further comprising passing an undo file identifying a plurality of commit timestamps to be processed to a history manager, re-stamping transaction control block states for a plurality of transaction control blocks corresponding to the commit timestamps, and setting the re-stamped transaction control blocks as free.
-
Specification