Optimization of exclusive access database consistent change locks
AssigneeSap SE
InventorsDirk Thomsen, Thorsten Glebe
Life of this patent
Estimating the term…
Abstract
Execution of an exclusive lock of a page in a database is initiated. Thereafter, subsequent to the initiation of the execution of the exclusive lock, at least one non-exclusive lock for the page in the database is received. The execution of the exclusive lock is selectively timed out based on at least one savepoint statistic. While the exclusive lock is timed out, at least one of the received non-exclusive locks is executed. Further, the exclusive lock can be restarted after the execution of the at least one of the received non-exclusive locks.
Claims20
A computer-implemented method comprising:
- initiating execution of an exclusive lock of a page in a database;
- receiving, subsequent to the initiation of the execution of the exclusive lock and prior to the completion of the exclusive lock, at least one non-exclusive lock for the page in the database;
- determining that at least one savepoint statistic is above a pre-defined threshold;
- selectively timing out the execution of the exclusive lock based on the determining;
- executing, while the exclusive lock is timed out, at least one of the received non-exclusive locks;
- and
- restarting the exclusive lock after the execution of the at least one of the received non-exclusive locks.
A system comprising:
- at least one data processor;
- and
- memory storing instructions which, when executed by the at least one data processor, resulting in operations comprising:
- initiating execution of an exclusive lock of a page in a database;
- receiving, subsequent to the initiation of the execution of the exclusive lock and prior to the completion of the exclusive lock, at least one non-exclusive lock for the page in the database;
- determining that at least one savepoint statistic is above a pre-defined threshold;
- selectively timing out the execution of the exclusive lock based on the determining;
- executing, while the exclusive lock is timed out, at least one of the received non-exclusive locks;
- and
- restarting the exclusive lock after the execution of the at least one of the received non-exclusive locks.
A non-transitory computer program product storing instructions which, when executed by at least one data processor forming part of at least one computing device, resulting in operations comprising:
- initiating execution of an exclusive lock of a page in a database;
- receiving, subsequent to the initiation of the execution of the exclusive lock and prior to the completion of the exclusive lock, at least one non-exclusive lock for the page in the database;
- determining that at least one savepoint statistic is above a pre-defined threshold;
- selectively timing out the execution of the exclusive lock based on the determining;
- executing, while the exclusive lock is timed out, at least one of the received non-exclusive locks;
- and
- restarting the exclusive lock after the execution of the at least one of the received non-exclusive locks.
Dependencies are inferred from the claim text.