Patent ID: 7415458
Filing Date: 2008-08-19
Classification: G06F,Y10S

Abstract:
1. A method of operating a computer system, the computer system comprising a database with a set of data stored therein, at least one host computer connected to the database via a database interface, an application program adapted to be run on the host computer and interacting with the database, and a search engine connected to the application via an application program interface and comprising a plurality of search engine tables and an internal update-mechanism, the method comprising: transferring a subset of data of the set of data as an initial load from the database via the application and function modules of the application program interface to the search engine; storing the initial load in a main memory of the search engine; retaining a set of records of a consistent image of any changes to the subset of data corresponding to at least one logical unit of work, the changes occurring in the database since the steps of transferring and storing the subset of data as the initial load; writing the set of records into a log table, wherein the log table is a shared resource usable to store records for the plurality of search engine tables; reading the set of records using an update reader; copying the set of records to create a persistent file copy of the set of records; updating the initial load on the basis of the set of records using the update reader; storing the updated initial load as updated data in the search engine main memory; determining if the set of records is stored in the search engine main memory; and deleting the set of records from the log table if it is determined that the set of records is stored in the search engine memory and deleting the set of records from the search engine memory if only a portion of the set of records is stored in the search engine memory.