The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Nov. 04, 2008
Filed:
May. 10, 2002
Christian Andersch, Schwerin, DE;
Marlene L. Coates, Hayward, CA (US);
Guilherme Saueressig, San Jose, CA (US);
Christian Andersch, Schwerin, DE;
Marlene L. Coates, Hayward, CA (US);
Guilherme Saueressig, San Jose, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
Systems, methods, 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.