Alleviation of index hot spots in data sharing environment with remote update and provisional keys
US10311033B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Dec 5, 2015 |
| Grant date | Jun 4, 2019 |
| Priority date | — |
| Expiry date | Jan 10, 2038 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2365
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
In a remote index operation, a first system in a datasharing group performs an operation on a data object in a database, determines a second system in the datasharing group has exclusive access to an index page to be updated according to the operation, and sends to the second system a remote request to change the index page according to the operation. In response, the second system changes the index page with an index entry referencing the data object and marks a key in the index entry as a provisional key. When a third system in the datasharing group reads the index entry, it determines that the key in the index entry is the provisional key. In response, the third system determines whether the data object exists in the database and a committed state of the transaction, and accordingly determines a current state of the data object.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.