Time-efficient lock release in database systems
US11113262B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 1, 2019 |
| Grant date | Sep 7, 2021 |
| Priority date | — |
| Expiry date | Jan 20, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2379
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Implementations of the present disclosure include associating a first transaction executed within a database system with a first transaction control block (TCB) index, setting a status of the first transaction to active and a lock status of the first transaction to holding in response to a first set of locks being established for the first transaction, the first set of locks including one or more locks that each inhibit access to a respective resource within the database system, providing a lock table that records, for a set of locks within the database system, a set of lock owners including one or more transactions identified based on respective TCB indexes and a wait queue, and determining that the first transaction has completed, and in response setting the status of the first transaction to indicate completion of the transaction and the lock status of the first transaction to released.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.