Patent ID: 8095535

Claim:
A database system for searching items stored in a database, said database system comprising: a computer processor for storing items in the database; the database storing item tables of items appended by timestamps, said items each being categorized by timestamp into said tables, and said item tables being indexed by indexing data; an indexing table for said indexing data, listing the earliest timestamp of said item tables together with said indexing data; a system manager for searching said item tables using said indexing table; a maintenance module for said indexing table, said maintenance module comprising a monitor tool for monitoring said item tables and updating said indexing table to maintain a correlation between said item tables and said indexing table, wherein: said monitor tool invokes from said item tables with said indexing data the item with the newest timestamp together with said indexing data and examines said correlation of said indexing table using said invoked timestamp and said indexing data as examination keys; said database system includes a repair tool for repairing said indexing table; said repair tool appends records to said indexing table in response to results of said examination of said monitor tool according to said timestamp and said indexing data; the insert sequence of the corresponding parts table id is determined for use in appending of the records in the indexing table; and said monitor tool updates the indexing table upon the creation of a new parts table.