Invention Grant
US07650354B2 System, method, and program for checking index consistency in database
失效
用于检查数据库中索引一致性的系统,方法和程序
- Patent Title: System, method, and program for checking index consistency in database
- Patent Title (中): 用于检查数据库中索引一致性的系统,方法和程序
-
Application No.: US11849246Application Date: 2007-08-31
-
Publication No.: US07650354B2Publication Date: 2010-01-19
- Inventor: Toshikazu Takahashi
- Applicant: Toshikazu Takahashi
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Sawyer Law Group
- Priority: JP2006-354038 20061228
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
The present invention provides a system, a method, and a program for checking index consistency online in a database that includes a main database storing a plurality of data segments and an index database storing a plurality of index segments. A system according to an aspect of the present invention includes a record creating unit for sequentially reading out the index segments from the index database and creating a pointer record that contains a pointer value and a key value and for sequentially reading out the data segments from the main database and create a segment record that contains a storage address and an indexed field value of an index target segment to be indexed among the read out segments, a scan point setting unit for setting scan points that indicate progress of creation of the pointer record and the segment record.
Public/Granted literature
- US20080162585A1 SYSTEM, METHOD, AND PROGRAM FOR CHECKING INDEX CONSISTENCY IN DATABASE Public/Granted day:2008-07-03
Information query