Systems, methods and computer program products to determine useful relationships and dimensions of a database
First Claim
1. A computer-implemented method, said computer having a database having metadata, at least one table with at least one column, and at least one presentation view, said computer having at least one query object directed to said database, said method efficiently navigating quickly between at least two said presentation views, comprising:
- executing said query object against said database;
applying user-specific heuristics as rules to said metadata via said executing query object thereby collecting statistical information about said query object based on said user-specific heuristics;
determining dimensions associated with said database by analyzing said statistical information; and
navigating between said at least two presentation views that present said dimensions.
2 Assignments
0 Petitions
Accused Products
Abstract
Systems, methods, and computer products that efficiently determine useful dimensions associated with a database when employing OLAP processing techniques. 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 may include 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.
78 Citations
60 Claims
-
1. A computer-implemented method, said computer having a database having metadata, at least one table with at least one column, and at least one presentation view, said computer having at least one query object directed to said database, said method efficiently navigating quickly between at least two said presentation views, comprising:
-
executing said query object against said database;
applying user-specific heuristics as rules to said metadata via said executing query object thereby collecting statistical information about said query object based on said user-specific heuristics;
determining dimensions associated with said database by analyzing said statistical information; and
navigating between said at least two presentation views that present said dimensions. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A computer-implemented method, said computer having a database having data, at least one table with at least one column, and at least one presentation view, said computer having at least one query object directed to said database, said method efficiently navigating quickly between at least two said presentation views, comprising:
-
executing said query object against said database;
applying user-specific heuristics as rules to said data via said executing query object thereby collecting statistical information about said query object based on said user-specific heuristics;
determining dimensions associated with said database by analyzing said statistical information; and
navigating between said at least two presentation views that present said dimensions. - View Dependent Claims (7, 8, 9, 10)
-
-
11. A computer system for navigating quickly between at least two presentation views, said database having metadata, at least one table with at least one column, and at least one said presentation view, said computer system having at least one query object directed to said database, comprising:
-
said query object being executed against said database;
user-specific heuristics being applied as rules to said metadata via said executing query object thereby collecting statistical information about said query object based on said user-specific heuristics;
said statistical information being analyzed thereby determining dimensions associated with said database; and
said at least two presentation views that are navigated to present said dimensions. - View Dependent Claims (12, 13, 14, 15)
-
-
16. A computer system for navigating quickly between at least two presentation views, said database having data, at least one table with at least one column, and at least one said presentation view, said computer system having at least one query object directed to said database, comprising:
-
said query object being executed against said database;
user-specific heuristics being applied as rules to said data via said executing query object thereby collecting statistical information about said query object based on said user-specific heuristics;
said statistical information being analyzed thereby determining dimensions associated with said database; and
said at least two presentation views that are navigated to present said dimensions. - View Dependent Claims (17, 18, 19, 20)
-
-
21. An article of manufacture comprising a computer usable medium embodying one or more instructions executable by said computer for navigating quickly between at least two presentation views, said database having metadata, at least one table with at least one column, and at least one said presentation view, said computer having at least one query object directed to said database wherein:
-
said computer usable instructions execute said query object against said database;
said computer usable instructions apply user-specific heuristics as rules to said metadata via said executing query object thereby collecting statistical information about said query object based on said user-specific heuristics;
said computer usable instructions determine dimensions associated with said database by analyzing said statistical information; and
said computer usable instructions navigate between said at least two presentation views that present said dimensions. - View Dependent Claims (22, 23, 24, 25)
-
-
26. An article of manufacture comprising a computer usable medium embodying one or more instructions executable by said computer for navigating quickly between at least two presentation views, said database having data, at least one table with at least one column, and at least one said presentation view, said computer having at least one query object directed to said database, wherein:
-
said computer usable instructions execute said query object against said database;
said computer usable instructions apply user-specific heuristics as rules to said data via said executing query object thereby collecting statistical information about said query object based on said user-specific heuristics;
said computer usable instructions determine dimensions associated with said database by analyzing said statistical information; and
said computer usable instructions navigate between said at least two presentation views that present said dimensions. - View Dependent Claims (27, 28, 29, 30)
-
-
31. A computer-implemented method, said computer having a database having metadata, at least one table with at least one column, and at least one presentation view, said computer having at least one query object directed to said database, said method efficiently navigating quickly between at least two said presentation views, comprising:
-
executing said query object against said database;
applying user-specific heuristics as rules to said metadata via said executing query object thereby collecting statistical information about said query object based on said user-specific heuristics;
determining relationships associated with said database by analyzing said statistical information; and
navigating between said at least two presentation views that present said relationships. - View Dependent Claims (32, 33, 34, 35)
-
-
36. A computer-implemented method, said computer having a database having data, at least one table with at least one column, and at least one presentation view, said computer having at least one query object directed to said database, said method efficiently navigating quickly between at least two said presentation views, comprising:
-
executing said query object against said database;
applying user-specific heuristics as rules to said data via said executing query object thereby collecting statistical information about said query object based on said user-specific heuristics;
determining relationships associated with said database by analyzing said statistical information; and
navigating between said at least two presentation views that present said relationships. - View Dependent Claims (37, 38, 39, 40)
-
-
41. A computer system for navigating quickly between at least two presentation views, said database having metadata, at least one table with at least one column, and at least one said presentation view, said computer system having at least one query object directed to said database, comprising:
-
said query object being executed against said database;
user-specific heuristics being applied as rules to said metadata via said executing query object thereby collecting statistical information about said query object based on said user-specific heuristics;
said statistical information being analyzed thereby determining relationships associated with said database; and
said at least two presentation views that are navigated to present said relationships. - View Dependent Claims (42, 43, 44, 45)
-
-
46. A computer system for navigating quickly between at least two presentation views, said database having data, at least one table with at least one column, and at least one said presentation view, said computer system having at least one query object directed to said database, comprising:
-
said query object being executed against said database;
user-specific heuristics being applied as rules to said data via said executing query object thereby collecting statistical information about said query object based on said user-specific heuristics;
said statistical information being analyzed thereby determining relationships associated with said database; and
said at least two presentation views that are navigated to present said relationships. - View Dependent Claims (47, 48, 49, 50)
-
-
51. An article of manufacture comprising a computer usable medium embodying one or more instructions executable by said computer for causing said computer to navigate quickly between at least two presentation views, said database having metadata, at least one table with at least one column, and at least one said presentation view, said computer having at least one query object directed to said database, wherein:
-
said computer usable instructions execute said query object against said database;
said computer usable instructions apply user-specific heuristics as rules to said metadata via said executing query object thereby collecting statistical information about said query object based on said user-specific heuristics;
said computer usable instructions determine relationships associated with said database by analyzing said statistical information; and
said computer usable instructions navigate between said at least two presentation views that present said relationships. - View Dependent Claims (52, 53, 54, 55)
-
-
56. An article of manufacture comprising a computer usable medium embodying one or more instructions executable by said computer for navigating quickly between at least two presentation views, said database having data, at least one table with at least one column, and at least one said presentation view, said computer having at least one query object directed to said database, wherein:
-
said computer usable instructions execute said query object against said database;
said computer usable instructions apply user-specific heuristics as rules to said data via said executing query object thereby collecting statistical information about said query object based on said user-specific heuristics said computer usable instructions determine relationships associated with said database by analyzing said statistical information; and
said computer usable instructions navigate between said at least two presentation views that present said relationships. - View Dependent Claims (57, 58, 59, 60)
-
Specification