Invention Grant
- Patent Title: System and method for increasing availability of an index
- Patent Title (中): 提高索引可用性的系统和方法
-
Application No.: US11277355Application Date: 2006-03-23
-
Publication No.: US07650352B2Publication Date: 2010-01-19
- Inventor: You-Chin Fuh , Sauraj Goswami , Jeffrey William Josten , James Zu-Chia Teng
- Applicant: You-Chin Fuh , Sauraj Goswami , Jeffrey William Josten , James Zu-Chia Teng
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Gates & Cooper LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
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.
Public/Granted literature
- US20070226235A1 System and Method for Increasing Availability of an Index Public/Granted day:2007-09-27
Information query