Invention Grant
- Patent Title: Database index modification
-
Application No.: US17448882Application Date: 2021-09-25
-
Publication No.: US11645254B2Publication Date: 2023-05-09
- Inventor: Shuo Li , Xiaobo Wang , Sheng Yan Sun , Hong Mei Zhang , Meng Wan
- 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: Yee & Associates, P.C.
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/182

Abstract:
Modifying an index for a database is provided. An index tree for the database is traversed by: identifying a next node in the index tree, requesting a lock of the next node in the index tree, responsive to locking of the next node in the index tree, releasing a lock of a current node of the index tree, and making the next node in the index tree the current node of the index tree, until the current node of the index tree is a leaf node of the index tree. Responsive to determining to split the leaf node, the lock of the leaf node is released and, after releasing the lock of the leaf node, a lock of a non-leaf node parent of the leaf node in the index tree is requested.
Public/Granted literature
- US20230100926A1 Database Index Modification Public/Granted day:2023-03-30
Information query