Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-05-23
2006-05-23
Ali, Mohammad (Department: 2166)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
07051013
ABSTRACT:
The present invention is directed towards a diagnostic system for a database system. The diagnostic system includes a grouping module for assigning a grouping identifier to each query received by the database system; and a statistics collection module. The statistics collection module includes a query processing statistics module for obtaining processing statistics corresponding to each query; a group statistics compilation module for compiling processing statistics for each query by the query's grouping identifier; and group data storage for storing compiled processing statistics. A method is also disclosed for generating database diagnostic data.
REFERENCES:
patent: 5537590 (1996-07-01), Amado
patent: 5598559 (1997-01-01), Chaudhuri
patent: 5706494 (1998-01-01), Cochrane et al.
patent: 5819255 (1998-10-01), Celis et al.
patent: 5822749 (1998-10-01), Agarwal
patent: 5875334 (1999-02-01), Chow et al.
patent: 5918232 (1999-06-01), Pouschine et al.
patent: 6016394 (2000-01-01), Walker
patent: 6021405 (2000-02-01), Celis et al.
patent: 6044366 (2000-03-01), Graffe et al.
patent: 6944366 (2000-03-01), Graffe et al.
patent: 6801903 (2004-10-01), Brown et al.
Chengwen Liu and Andrei Ursu,A Framework for Global Optimization of Aggregate Queries,Proceedings of the Sixth International Conference on Information and Knowledge Management, 1997, pp. 262-269.
Ambuj Shatdal and Jeffrey F. Naughton,Adaptive Parallel Aggregation Algorithms,SIGMOD Record, vol. 24, No. 2, pp. 104-114, Jun. 1995.
J. Bradley,Application of SQL/N to the Attribute-Relation Associations Implicit in Functional Dependencies,International Journal of Computer & Information Sciences, vol. 12, No. 2, pp. 65-86, Apr. 1983.
A.C. Bloesch and T.A. Halpin,Conceptual Queries using ConQuer-II,Conceptual Modeling—ER '97, 16thInternational Conference on Conceptual Modeling Proceedings, pp. 113-126, Published: Berlin, Germany, 1997.
W. Paul Yan and Paul Larson,Data Reduction Through Early Grouping,Department of Computer Science, University of Waterloo, Waterloo, Ontario, Canada pp. 1-9, 1994.
D. Chatzianotoniou and K.A. Ross,Groupwise Processing of Relational Queries,Proceedings of the Twenty-Third International Conference on Very Large Databases, pp. 476-485, Published: San Francisco, CA 1997.
Patrick O'Neil and Dallan Quass,Improved Query Performance with Variant Indexes,SIGMOD Record, vol. 26, No. 2, pp. 38-49, Jun. 1997.
Andreas Bauer and Wolfgang Lehner,The Cube-Query-Language(CQL)for Multidimensional Statistical and Scientific Database Systems,Database Systems for Advanced Applications '97, Proceedings of the Fifth International Conference, pp. 263-272, Published: Singapore, 1997.
Guozhu Dong, et al.,Local Properties of Query Languages,Theoretical Computer Science, vol. 239, No. 2, pp. 277-308, May 28, 2000.
Andrew Eisenberg,New Standard for Stored Procedures in SQL,SIGMOD Record, vol. 25, No. 4, pp. 81-88, Dec. 1996.
David A. Kellogg,Optimising Queries,Computer Systems Europe, pp. 53-56, May 1989.
Surajit Chaudhuri and Kyuseok Shim,Optimizing Queries with Aggregate Views,Advances in Database Technology—EDBT '96, 5thInternational Conference on Extending Database Technology Proceedings, pp. 167-183, Published: Berlin, Germany, 1996.
Alon Y. Levy and Inderpal S. Mumick,Reasoning with Aggregation Constraints,Advances in Database Technology—EDBT '96, 5thInternational Conference on Extending Database Technology Proceedings, pp. 514-534, Published: Berlin, Germany, 1996.
Piyush Goel and Bala Iyer,SQL Query Optimization: Reordering for a General Class of Queries,SIGMOD Record, vol. 25, No. 2, pp. 47-56, Jun. 1996.
Umeshwar Dayal,Of Nests and Trees: A Unified Approach to processing Queries that Contain Nested Subqueries, Aggregates, and Quantifiers,Proceedings of the 13thInternational Conference on Very Large Data Bases, 1987 13thVLDB, pp. 197-208, Published: Los Altos, CA, 1987.
Don Chamberlin,Super Groups DB2 Database,DB2 Magazine, vol. 3, No. 4, pp. 49-50, 52, 54-55, 1998.
Horman Randall W.
Lightstone Sam S.
Valentin Gary
Ali Mohammad
Sawyer Law Group LLP
LandOfFree
Database diagnostic system and method does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Database diagnostic system and method, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database diagnostic system and method will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3596420