Patent ID: 7447687
Filing Date: 2008-11-04
Classification: G06F,Y10S

Abstract:
1. A computer-implemented method, said computer having a database having metadata, said computer having at least one query object directed to said database, said method generating a user-specific report, said method comprising: executing said query object against said database by applying user-specific heuristics as rules to said metadata via said executing query object and applying a data-mining statistical tabulation against data in said database and said metadata and thereby collecting statistical information about said query object based on said user specific heuristics, wherein the user-specific heuristics are embodied in Structural Query Language (SQL) statements; retrieving at least one view of said statistical information that satisfies said user-specific heuristics, wherein said at least one view includes one of a table view, a column view, and a query view, wherein said table view presents information about columns in a table and query objects that use said table, wherein said column view that presents information about query objects that use a column and tables used in each of said query objects that use said column, and wherein the query view presents information about columns and tables that are used in said query object; rating said statistical information that satisfies said user-specific heuristics via said at least one view, wherein rating includes rating said query object according to a level of compliance with said heuristics; and presenting said rated statistical information in said user-specific report.