Patent ID: 6678676
Filing Date: 2004-01-13
Classification: G06F,Y10S

Abstract:
Apparatus for creating summaries of a database, the database being responsive to a query to provide data, the apparatus comprising a processor coupled to a database, the processor being adapted to:a. monitor the usage of the database; and, b. determine one or more summaries in accordance with the usage and in accordance with space available for summary storage; wherein the one or more summaries are determined by causing the processor to: i. determine an item ranking for each query made based on a number of times the query was requested and based on an average elapsed time to respond to the query; ii. determine an order of importance of each query for summary table creation based on a need for performance improvement for each query relative to other queries, the need for performance improvement determined based on the item rankings; iii. determine exact match summary tables for at least a portion of the queries for which an order of importance has been determined; iv. determine, for each query for which an exact match summary table has been determined, a reduction in execution time of the query that will be obtained by using the exact match summary table for the query; and v. select a set of summary tables providing in a reduction execution time for all queries as a whole.