Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2005-09-20
2005-09-20
Wassum, Luke (Department: 2167)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
06947929
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.
REFERENCES:
patent: 5692107 (1997-11-01), Simoudis et al.
patent: 5748188 (1998-05-01), Hu et al.
patent: 5832475 (1998-11-01), Agrawal 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: 6134532 (2000-10-01), Lazarus et al.
patent: 6144962 (2000-11-01), Weinberg 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: 6339776 (2002-01-01), Dayani-Fard et al.
patent: 6385609 (2002-05-01), Barshefsky et al.
patent: 6604110 (2003-08-01), Savage et al.
patent: 6633885 (2003-10-01), Agrawal et al.
patent: 6643661 (2003-11-01), Polizzi et al.
patent: 6654764 (2003-11-01), Kelkar
patent: 6671689 (2003-12-01), Papierniak
patent: 6711579 (2004-03-01), Balakrishnan
patent: 6711585 (2004-03-01), Copperman et al.
patent: 6714940 (2004-03-01), Kelkar
patent: 2001/0047355 (2001-11-01), Anwar
patent: 2001/0051947 (2001-12-01), Morimoto et al.
patent: 2003/0055813 (2003-03-01), Chaudhuri et al.
patent: 2003/0115183 (2003-06-01), Abdo et al.
patent: 09106331 (1997-04-01), None
patent: 09146962 (1997-06-01), None
patent: 10247197 (1998-09-01), None
patent: WO 00/65479 (2000-02-01), None
patent: WO 00/22493 (2000-04-01), None
Oracle9i OLAP Services Concepts and Administration Guide, Release 9.0.1, Jun. 2001, ORACLE®.
Query Optimization in Oracle9i, an Oracle White Paper, Feb. 2002, ORACLE®.
Database Query Optimizer with Rule Based Search Engine, Carlo Pires et al., SugarloafPLoP 2002 Procedings.
IBM Query Management Facility™,QMF High Performance Option User's Guide For z/OS and OS/390, Version 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.
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.
Bruce Jay M
Coates Marlene L.
Robinson Gary
Saueressig Guilherme
International Business Machines - Corporation
Lu Kuen S.
Smith Christine H.
Wassum Luke
LandOfFree
Systems, methods and computer program products to determine... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Systems, methods and computer program products to determine..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Systems, methods and computer program products to determine... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3444878