Table-and-cache-based database assist method

摘要

A database assist method is adapted to a data processing system which includes a first processing unit, an input/output unit which is coupled to the first processing unit, a second processing unit, a database and cache memory. The database assist method assists a database related process which includes selection of items from records stored in the database and includes the steps of (a) forming an execution procedure table which defines a procedure for retrieving information of interest from the database in response to a processing request from a request source, (b) generating at least a column information table which defines item structures within the records and a selection/projection table which defines the items to be extracted and extracting conditions based on the execution procedure table, (c) storing a block group of interest into cache memory from the database based on the column information table and the selection/projection table and carrying out a specified process with respect to the stored block group for a specified item, and (d) returning a result of the specified process carried out in step (c) to the request source by a batch processing.