Multiversion concurrency control of database records with uncommitted transactions
US11416470B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | May 30, 2019 |
| Grant date | Aug 16, 2022 |
| Priority date | — |
| Expiry date | Dec 7, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2329
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Systems and methods provide multi-version concurrency control of database records with uncommitted transactions. The system and methods may include receiving a query regarding a transaction counter number. When a transaction header identifying data is updated with the assigned transaction counter number, the updated transaction header may be used in identifying data as an instance of multiversion concurrency control information by the received query. A key lookup may be performed, and when the key lookup encounters an uncommitted row for a transaction number, a corresponding transaction header identifying data to identify a data array element to determine whether the transaction number is committed, and determining the transaction counter number when the transaction number is committed. The transaction counter number may be stamped on the row version record when it is determined that the row is committed.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.