Employing spillover tables for data updates
US8706619B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Jun 25, 2010 |
| Grant date | Apr 22, 2014 |
| Priority date | — |
| Expiry date | Jun 3, 2031 |
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 to improve performance of data store updates. A request to update a data field is received, and if an exclusive lock on a data table cannot be obtained, the request is placed in a spillover table until the exclusive lock can be obtained. If the request causes a constraint on the data field to be violated or causes the data field to move closer to the constraint, the request is not placed in the spillover table. A spillover task can collapse entries in the spillover table into the data store when an exclusive lock can be obtained.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.