Employing spillover tables for data updates
US10032229B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Feb 3, 2014 |
| Grant date | Jul 24, 2018 |
| Priority date | — |
| Expiry date | Nov 16, 2035 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06Q20/10
- WIPO fieldIT methods for management
- WIPO sectorElectrical engineering
Abstract
Disclosed are various embodiments for employing spillover tables that may improve the performance of data store updates. In some embodiments, transaction data that specifies a value by which to adjust a field in a data table is received. The field in the data table is associated with a predefined constraint. An attempt to obtain an exclusive lock for at least a portion of the data table is initiated. Whether the value has a potential to cause the predefined constraint to remain satisfied is identified. The transaction data is stored in a spillover table in response to a failure to obtain the exclusive lock and in further response to the value having the potential to cause the predefined constraint to remain satisfied.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.