Invention Grant
- Patent Title: Method and apparatus for building index of source data
- Patent Title (中): 构建源数据索引的方法和装置
-
Application No.: US10990609Application Date: 2004-11-17
-
Publication No.: US07933927B2Publication Date: 2011-04-26
- Inventor: Stanley J Dee , Michael S Murley , William J Pothoff
- Applicant: Stanley J Dee , Michael S Murley , William J Pothoff
- Applicant Address: US TX Houston
- Assignee: BMC Software, Inc.
- Current Assignee: BMC Software, Inc.
- Current Assignee Address: US TX Houston
- Agency: Wong, Cabello, Lutsch, Rutherford & Brucculeri, L.L.P.
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
An online index building operation is disclosed for building an index from source data with minimal loss of availability to the source data. The source data can be maintained in a relational database system, such as in a tablespace of a DB2® environment. The disclosed operation creates a consistent image of the source data as of a point-in-time and creates an index from the consistent image. Then, the disclosed operation repeats the acts of making the image consistent as of a subsequent point-in-time and updating the index to reflect the subsequent consistent image until substantially caught up with the current changes to the source data. If not caught up, the disclosed operation continues unless it is falling behind at which point the operation terminates. If it is caught up, the disclosed operation locks access to the source data, updates the image to reflect any final changes, updates the index, and allows access to the index.
Public/Granted literature
- US20060106860A1 Method and apparatus for building index of source data Public/Granted day:2006-05-18
Information query