System and method for management of a database system
US11132376B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Feb 28, 2019 |
| Grant date | Sep 28, 2021 |
| Priority date | — |
| Expiry date | Nov 27, 2039 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2423
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system can comprise one or more processors; and one or more non-transitory computer-readable media storing computing instructions configured to run on the one or more processors and perform: receiving a request for a write operation of an input record in a data store associated with a sharded database and an alternate-key-global-index (AKGI) database; generating a new optimistic lock value, the new optimistic lock value being unique in the sharded database; when the data store does not include a data record associated with the input record, creating the dummy data record in the data store; locking the data record for the write operation by setting the DROpLock of the data record to the new optimistic lock value; and performing the write operation of the input record in the AKGI database and the sharded database. In this embodiment, performing the writing operation further comprising inserting or updating an index record derived from the data record before updating the data record and locking the index record before inserting or updating the index record. Other embodiments are disclosed.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.