Patent ID: 7529729
Filing Date: 2009-05-05
Classification: G06F,Y10S

Abstract:
1. A method of analyzing table access in a database system, comprising: defining an incorrect rule set and a related correct rule set from a database model associated with the database system; retrieving index definitions for the database system; comparing the index definitions with the incorrect rule set to identify improper indexes, wherein the improper indexes are identified independently of any SQL processing; generating a list of index definitions that match a rule in the incorrect rule set; retrieving application programs for the database system; comparing application programs with the index definitions that match a rule in the incorrect rule set; generating a list of application programs which match a rule in the incorrect rule set; merging the list of index definitions with the list of application programs; reporting the merged list of index definitions and application programs; identifying and storing to memory application programs that depend on the improper indexes; and using the related correct rule set to propose changes to the improper indexes and the application programs that depend on the improper indexes.