Patent ID: 6023695
Filing Date: 2000-02-08
Classification: G06F,Y10S

Abstract:
A computer implemented method for managing a database, comprising:collecting statistics on past queries submitted to a database management system;generating summary table creation recommendations based on the statistics, in which the generation of summary table creation recommendation includes an evaluation of both the frequency and execution times of the past submitted queries, and in which generating summary table creation recommendations comprises ranking a plurality of past queries submitted over a time period, the ranking of a past query of the plurality of past queries based on the expression;log(f).sup.2 (cpu+1)where f is the frequency with which the past query was submitted during the time period, and cpu is the average CPU execution time for the past query during the time period; andpresenting the summary table creation recommendations to a user, or, automatically generating at least one of the summary tables in the summary table creation recommendations.