发明授权
- 专利标题: System and method for increasing availability of an index
- 专利标题(中): 提高索引可用性的系统和方法
-
申请号: US11277355申请日: 2006-03-23
-
公开(公告)号: US07650352B2公开(公告)日: 2010-01-19
- 发明人: You-Chin Fuh , Sauraj Goswami , Jeffrey William Josten , James Zu-Chia Teng
- 申请人: You-Chin Fuh , Sauraj Goswami , Jeffrey William Josten , James Zu-Chia Teng
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 代理机构: Gates & Cooper LLP
- 主分类号: G06F7/00
- IPC分类号: G06F7/00 ; G06F17/30
摘要:
A partial index availability system places, in a restricted state, all pages in the index associated with a structure modification, when an error occurs in processing a log of the said structure modification. This maintains traversability of the rest of the index that is not in restricted state. The system locates and marks a left sentinel and a right sentinel associated with a non-leaf page that is in a restricted state preventing an undo of a transaction. The sentinels prevent a transaction from accessing an uncommitted change associated with the non-leaf page. After a recovery procedure is run the entire index is made available. During the period between the placement of the index pages in LPL or rebuild pending to the time of final removal of these pages from their restrictive states as a result of a recovery procedure being run, the users are given access to the non-restricted portion of the index.
公开/授权文献
信息查询