Systems and computer program products to browse database query information
First Claim
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.
1 Assignment
0 Petitions
Accused Products
Abstract
Systems and computer products that efficiently determine how columns, tables, and queries associated with a database are related to each other. The present invention enables a user to see at a glance in which queries certain columns and tables are used. The present invention may be implemented with a query miner module that includes a query browser module that improves browsing through queries and their components over the past. The preferred embodiment of the present invention provides an easy to use graphical interface showing the queries, tables, and columns in a tree structure. Further, the preferred embodiment of the present invention presents information about relationships and dimensions associated with a database and about columns, tables, and queries to the user without discernable lag time between the user'"'"'s request and the generated information.
-
Citations
10 Claims
-
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 Dependent Claims (2, 3, 4, 5)
-
-
6. An article of manufacture comprising a program usable storage medium embodying one or more computer usable instructions executable by a computer system to generate a user-specific report, said computer having a database having metadata, said computer having said at least one query object directed to said database, wherein said computer usable instructions executed by the computer system for:
-
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 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 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. - View Dependent Claims (7, 8, 9, 10)
-
Specification