Patent ID: 7984024
Filing Date: 2011-07-19
Classification: G06F,Y10S

Abstract:
1. A computer readable medium including a program for maintaining statistics, wherein the computer readable medium is a member of a set of computer readable media consisting of a magnetic storage medium, optical storage, and volatile and non-volatile memory devices, wherein the program, when executed by a computer, causes operations to be performed, the operations comprising: receiving a query; performing column group generation to form one or more column groups; performing column group refinement based on statistics data generated for a previously received query; automatically performing a statistics check by determining whether the statistics include missing statistics, conflicting statistics, obsolete statistics, and volatile statistics; automatically generating a statistics collection command to obtain the statistics based on the determination, wherein the statistics collection command identifies the missing statistics based on recognizing which of the statistics should be available for a particular query and are not available, identifies the conflicting statistics based on whether a set of constraints are met by the statistics, and identifies the obsolete statistics and the volatile statistics by applying heuristic rules to determine whether each of the statistics are at least one of obsolete and volatile; executing the statistics collection command to obtain improved statistics that are stored in a data store; iteratively performing the statistics check, generating the statistics collection command, and executing the statistics collection command until performance of execution of the query with the improved statistics is acceptable; and generating at least one of a preliminary report and an advanced report that includes the generated statistics collection command, wherein the preliminary report is generated in a preliminary analysis phase and includes the statistics collection command, reasons for collecting existing statistics using the statistics collection command, and a report on missing, conflicting, obsolete, and volatile statistics, and wherein the advanced report is generated in advanced analysis phase based on iterative data correlation, skew analysis, and validation, adaptive learning of data profiles using stored statistics data from the previous query, and performing one or more additional statistics checks.