Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2004-09-22
2009-06-23
Breene, John E (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07552110
ABSTRACT:
Presented is a method to perform a query to retrieve data from a database that is part of a computer system comprising a Data-Base Management System (DBMS) with an optimizer. A Query Execution Plan (QEP) is generated for the query. The QEP is assessed by considering statistical values about previous executions of the query according to the QEP to decide whether to choose the QEP or to generate a new QEP. Furthermore, the statistical values on previous executions of the query are exploited during query optimization. The query is executed according to the chosen QEP. For optimizing the execution of future queries, statistical values about the execution of the query are collected during execution.
REFERENCES:
patent: 5412806 (1995-05-01), Du et al.
patent: 5940819 (1999-08-01), Beavin et al.
patent: 6356889 (2002-03-01), Lohman et al.
patent: 6847978 (2005-01-01), Ellis et al.
patent: 7080062 (2006-07-01), Leung et al.
patent: 7146363 (2006-12-01), Waas et al.
patent: 2002/0198867 (2002-12-01), Lohman et al.
patent: 2004/0122804 (2004-06-01), Zhang et al.
patent: 2005/0125427 (2005-06-01), Dageville et al.
Goldstein et al., “Optimizing Queries Using Materialized Views: A Practical, Scalable Solution”, AMC SIGMOD Record, vol. 30, Issue 2, Jun. 2001, pp. 331-342. Downlowad: http://portal.acm.org/citation.cfm?id=376284.375706.
Selinger et al., “Access Path Election in a Relational Database Management System”, International Conference on Management of Data archive Proceedings of the 1979 ACM SIGMOD international conference on Management of data, 1979. pp. 23-34. Download: http://portal.acm.org/citation.cfm?id=582099.
Subramanian et al., “Cost-Based Optimization of Decision Support Queries using Transient-Views”, International Conference on Management of Data archive Proceedings of the 1998 ACM SIGMOD, Seattle, Washington, United States, 1998. pp. 319-330. Download: http://portal.acm.org/citation.cfm?id=276333.
Ng et al., “Dynamic Query Re-Optimization,” Proceedings of the 11th International Conference on Scientific on Scientific and Statistical Database Management, 1999.
Weikum et al., “Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering,” Proceedings of the 28th VLDB Conference, Hong Kong, China, 2002.
Hrle Namik
Schuetzner Johannes
Breene John E
International Business Machines - Corporation
Jami Hares
Kunzler & McKenzie
LandOfFree
Method for performing a query in a computer system to... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method for performing a query in a computer system to..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for performing a query in a computer system to... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4145702