×

SYSTEMS AND COMPUTER PROGRAM PRODUCTS TO BROWSE DATABASE QUERY INFORMATION

  • US 20080133582A1
  • Filed: 01/08/2008
  • Published: 06/05/2008
  • Est. Priority Date: 05/10/2002
  • Status: Active Grant
First Claim
Patent Images

1. A computer system including a processor and a data storage device to generate a user-specific report, said computer system having a database having metadata, said computer system having said at least one query object directed to said database, comprising:

  • executing said query object against said database by user-specific heuristics being applied 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 Structured 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, 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.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×