发明公开
- 专利标题: CREATING A SECONDARY INDEX
-
申请号: US17709723申请日: 2022-03-31
-
公开(公告)号: US20230315707A1公开(公告)日: 2023-10-05
- 发明人: Kelsey L Bruso , James M. PIasek
- 申请人: Kelsey L Bruso , James M. PIasek
- 申请人地址: US MN Minneapolis
- 专利权人: Unisys Corporation
- 当前专利权人: Unisys Corporation
- 当前专利权人地址: US PA Blue Bell
- 主分类号: G06F16/22
- IPC分类号: G06F16/22 ; G06F16/21 ; G06F16/23
摘要:
A processor-based method of creating a secondary index for a B-tree in a database includes creating an empty secondary index; traversing the B-tree to find the left most data page to begin processing; capturing the current system time; placing a read-lock on the data page; retrieving a first primary key value for the data page; writing the first primary key value to a control information for the B-tree; creating a secondary index entry and writing it into the secondary index; and releasing the read-lock.
信息查询