Invention Grant
- Patent Title: Alleviation of index hot spots in data sharing environment with remote update and provisional keys
-
Application No.: US14960352Application Date: 2015-12-05
-
Publication No.: US10311033B2Publication Date: 2019-06-04
- Inventor: Robert W. Lyle
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: North Shore Patents, P.C.
- Agent Michele Liu Baillie
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F16/22 ; G06F16/23

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.
Public/Granted literature
- US20160196291A1 Alleviation of Index Hot Spots in Datasharing Environment with Remote Update and Provisional Keys Public/Granted day:2016-07-07
Information query