Systems, methods and computer program products to determine useful relationships and dimensions of a database
US6947929B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | May 10, 2002 |
| Grant date | Sep 20, 2005 |
| Priority date | — |
| Expiry date | Aug 14, 2023 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99935
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.