Patent ID: 7647334

Claim:
A method for checking index consistency in a database that includes a main database storing a plurality of data segments and an index database storing a plurality of index segments, comprising the steps of: creating a pointer record that contains pointer values and key values by sequentially reading out the index segments from the index database, by a record creating unit in a computer; creating a segment record that contains storage addresses and search field values of index target segments pointed by the pointer values of the index segments by sequentially reading out the data segments from the main database, by the record creating unit; setting scan points that indicate how much the creation of the pointer record and the segment record proceeds by a scan point setting unit in the computer, respectively; writing, in response to the update of the index segment in the index database or the update of the index target segment in the main database, an update log of the updated segment by an update log writing unit in the computer, on condition that the updated segment is located at a point that precedes the scan point set by the scan point setting unit, while the record creation unit creates the pointer record or a segment record; modifying the pointer record and the segment record by a record modifying unit in the computer on the basis of the update log after the record creation unit creates the pointer record or a the segment record; and verifying index consistency by comparing record entries of the modified pointer record with corresponding record entries of the modified segment record, a consistency verifying unit in the computer.