Methods to browse database query information

Details Methods to browse database query information Methods to browse database query information

2002-05-10

2008-11-04

Fleurantin, Jean Bolte (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07447687

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.

REFERENCES:
patent: 5692107 (1997-11-01), Simoudis et al.
patent: 5692175 (1997-11-01), Davies et al.
patent: 5748188 (1998-05-01), Hu et al.
patent: 5832475 (1998-11-01), Agrawal et al.
patent: 5832496 (1998-11-01), Anand et al.
patent: 5870746 (1999-02-01), Knutson et al.
patent: 5960423 (1999-09-01), Chaudhuri et al.
patent: 5978788 (1999-11-01), Castelli et al.
patent: 6031977 (2000-02-01), Pettus
patent: 6092064 (2000-07-01), Aggarwal et al.
patent: 6115547 (2000-09-01), Ghatate et al.
patent: 6134532 (2000-10-01), Lazarus et al.
patent: 6144962 (2000-11-01), Weinberg et al.
patent: 6205447 (2001-03-01), Malloy
patent: 6226647 (2001-05-01), Venkatasubramanian et al.
patent: 6249791 (2001-06-01), Osborn et al.
patent: 6292797 (2001-09-01), Tuzhilin et al.
patent: 6308168 (2001-10-01), Dovich et al.
patent: 6324533 (2001-11-01), Agrawal et al.
patent: 6327574 (2001-12-01), Kramer et al.
patent: 6339776 (2002-01-01), Dayani-Fard et al.
patent: 6385609 (2002-05-01), Barshefsky et al.
patent: 6418428 (2002-07-01), Bosch et al.
patent: 6477536 (2002-11-01), Pasumansky et al.
patent: 6539371 (2003-03-01), Bleizeffer et al.
patent: 6567796 (2003-05-01), Yost et al.
patent: 6574791 (2003-06-01), Gauthier et al.
patent: 6581054 (2003-06-01), Bogrett
patent: 6604110 (2003-08-01), Savage et al.
patent: 6609123 (2003-08-01), Cazemier et al.
patent: 6615201 (2003-09-01), Seshadri et al.
patent: 6633882 (2003-10-01), Fayyad et al.
patent: 6633885 (2003-10-01), Agrawal et al.
patent: 6643661 (2003-11-01), Polizzi et al.
patent: 6654764 (2003-11-01), Kelkar et al.
patent: 6671689 (2003-12-01), Papierniak
patent: 6684207 (2004-01-01), Greenfield et al.
patent: 6697808 (2004-02-01), Hurwood et al.
patent: 6711579 (2004-03-01), Balakrishnan
patent: 6711585 (2004-03-01), Copperman et al.
patent: 6714940 (2004-03-01), Kelkar
patent: 6768986 (2004-07-01), Cras et al.
patent: 6801992 (2004-10-01), Gajjar et al.
patent: 6823334 (2004-11-01), Vishnubhotla et al.
patent: 6831668 (2004-12-01), Cras et al.
patent: 6842758 (2005-01-01), Bogrett
patent: 6898603 (2005-05-01), Petculescu et al.
patent: 6931418 (2005-08-01), Barnes
patent: 6947929 (2005-09-01), Bruce et al.
patent: 6957225 (2005-10-01), Zait et al.
patent: 7007039 (2006-02-01), Chaudhuri et al.
patent: 7181450 (2007-02-01), Malloy et al.
patent: 7191169 (2007-03-01), Tao
patent: 7203671 (2007-04-01), Wong
patent: 7246116 (2007-07-01), Barsness et al.
patent: 7275024 (2007-09-01), Yeh et al.
patent: 2001/0047355 (2001-11-01), Anwar
patent: 2001/0051947 (2001-12-01), Morimoto et al.
patent: 2002/0073088 (2002-06-01), Beckmann et al.
patent: 2002/0087516 (2002-07-01), Cras et al.
patent: 2002/0091679 (2002-07-01), Wright
patent: 2002/0124002 (2002-09-01), Su et al.
patent: 2002/0138316 (2002-09-01), Katz et al.
patent: 2003/0004942 (2003-01-01), Bird
patent: 2003/0055813 (2003-03-01), Chaudhuri et al.
patent: 2003/0055832 (2003-03-01), Roccaforte
patent: 2003/0061207 (2003-03-01), Spektor
patent: 2003/0071814 (2003-04-01), Jou et al.
patent: 2003/0081002 (2003-05-01), De Vorchik et al.
patent: 2003/0093424 (2003-05-01), Chun et al.
patent: 2003/0101202 (2003-05-01), Kelkar et al.
patent: 2003/0115183 (2003-06-01), Abdo et al.
patent: 2003/0126144 (2003-07-01), O'Halloran et al.
patent: 2003/0212676 (2003-11-01), Bruce et al.
patent: 2004/0098415 (2004-05-01), Bone et al.
patent: 2004/0122646 (2004-06-01), Colossi et al.
patent: 2004/0122844 (2004-06-01), Malloy et al.
patent: 2004/0139061 (2004-07-01), Colossi et al.
patent: 2004/0181502 (2004-09-01), Yeh et al.
patent: 2004/0181538 (2004-09-01), Lo et al.
patent: 2004/0215626 (2004-10-01), Colossi et al.
patent: 2005/0027754 (2005-02-01), Gajjar et al.
patent: 2005/0033730 (2005-02-01), Chaudhuri et al.
patent: 2005/0267868 (2005-12-01), Liebl et al.
patent: 2005/0278290 (2005-12-01), Bruce et al.
patent: 09106331 (1997-04-01), None
patent: 09146962 (1997-06-01), None
patent: 10247197 (1998-09-01), None
patent: 2002-0074435 (2002-11-01), None
patent: WO 00/22493 (2000-04-01), None
patent: WO 00/65479 (2000-11-01), None
patent: WO-01/29690 (2001-04-01), None
Query Optimization in Oracle9i, An Oracle White Paper, Feb. 2002, ORACLE.
“Maintaining data warehouses over changing information sources”- Elke A. Rundensteiner, Andreas Koeller and Xin Zhang- Communications of the ACM - vol. 43, No. 6, Jun. 2000 (pp.: 57-62).
“INFOHARNESS: managing distributed, hetegogeneous information” - Shah, I. and Sheth, A. - Internet Computing, IEEE Nov.-Dec. 1999, vol. 3, Issue: 6 (pp. 18-28).
Warshaw, et al.Rule-Based Query Optimization, Revisited, Proceedings of the Eighth International Conference on Information Knowledge Management, CIKM'99 Nov. 2-6, 1999 Kansas City Missouri. Editor Susan Gauch. pp. 267-275.
Shukla, et al.Materialized View Selection for Multi-cube Data Models, Advances in Database Technology—EDBT 2000, Proceedings 7thInternational Conference on Extending Database Technology Konstanz, Germany, Mar. 27-31, 2000, pp. 269-284.
Goil, et al.,A Parallel Scalable Infrastructure for OLAP and Data Mining, IEEE online library, pp. 1-9.
Hedberg, Sara R.,Parallelism Speeds Data Mining, IEEE Parallel & Distributed Technology, Industry Spotlight, Winter 1995, pp. 3-6.
Toyama, Motomichi,SuperSQL : An Extended SQL for Database Publishing and Presentation, Proceedings of the 1998 ACM SIGMOD International Conf. on Management of Data, Seattle, Washington, USA Jun. 1-4, 1998 vol. 27, No. 2, Jun. 1998, pp. 584-586.
Oracle91 OLAP Services Concepts and Administration Gjuide, Relese 9.0.1, Junes 2001, ORACLE®.
Query Optimization in Oracle 9i, an Oracle White Paper, Feb. 2002, ORACLE®.
IBM Query Management Facility™,QMF High Performance Option User's Guide For z/OS and OS/390Version 7, Release 2, Mar. 2002, SC27-0724-01.
Bhooshan P Kelkar et al., U.S. Appl. No. 09/998.955,Systems, Methods, and Computer Program Products to Interpret, Explain, and Manipulate Exceptions in Multidimensional Data, filed Nov. 15, 2001, Assignee, International Business Machines Corporation.
Bhooshan P Kelkar, U.S. Appl. No. 09/998,960,Systems, Methods, and Computer Program Products to Rank and Explain Dimensions Associated with Exceptions in Multidimensional Data, filed Nov. 15, 2001, Assignee, International Business Machines Corporation.
R. Agrawal et al., U.S. Appl. No. 09/477,257,System and Method for Web-Based Querying, Filed Jan. 4, 2000, Assignee, International Business Machines Corporation.
Reiner Kraft, U.S. Appl. No. 09/602,490,System and Method for Web Based Sharing of Search Engine Queries, filed Jun. 23, 2000, Assignee, International Business Machines Corporation.
Albrecht, J., W. Hummer, W. Lehner, & L. Schlesinger, “Query Optimization by Using Derivability in a Data Warehouse Environment”,Proceedings of the 3rd ACM international workshop on Data warehousing and OLAP, 2000, pp. 49-56.
IBM Corporation, “IBM QMF for Windows for DB2 workstation Databases, V&.2-Business Intelligence Starts Here!”,Software Announcement, Feb. 26, 2002.
Pederson, D., K. Riis, & T.B. Pederson, “A Powerful and SQL-Compatible Data Model and Query Language for OLAP”,Proceedings of

Affiliated with

Also associated with

Rating

Methods to browse database query information does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Methods to browse database query information, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Methods to browse database query information will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4043980