Data processing: database and file management or data structures – Database and file access – Query optimization
Reexamination Certificate
2008-10-21
2011-11-15
Lewis, Cheryl (Department: 2155)
Data processing: database and file management or data structures
Database and file access
Query optimization
Reexamination Certificate
active
08060495
ABSTRACT:
An apparatus, system, and method are disclosed for improving query execution plan efficiency in a database management system. The present invention binds both static database queries and dynamic database queries to new query execution plans (QEPs) that produce the same result set as a former QEP bound to the database queries. Next, the present invention identifies one of the former QEPs and the new QEP as an active QEP and automatically collects execution statistics for one of the former QEPs and the new QEP. Finally, the present invention automatically selects one of the former QEPs and the new QEP as the active QEP in response to completion of the automatic collection of execution statistics, the active QEP selected such that the automatically selected QEP provides optimal execution performance based on performance criteria in comparison to the automatically unselected QEP, the active QEP selected based on the execution statistics.
REFERENCES:
patent: 5940819 (1999-08-01), Beavin et al.
patent: 6006220 (1999-12-01), Haderle et al.
patent: 6219660 (2001-04-01), Haderle et al.
patent: 6763359 (2004-07-01), Lohman et al.
patent: 6985904 (2006-01-01), Kaluskar et al.
patent: 7080062 (2006-07-01), Leung et al.
patent: 7275051 (2007-09-01), Hrle
patent: 7552110 (2009-06-01), Hrle et al.
patent: 2004/0019587 (2004-01-01), Fuh et al.
patent: 2004/0039729 (2004-02-01), Boger et al.
patent: 2004/0181521 (2004-09-01), Simmen
patent: 2004/0243555 (2004-12-01), Bolsius
patent: 2005/0065921 (2005-03-01), Hrle et al.
patent: 2005/0091196 (2005-04-01), Day et al.
patent: 2005/0097091 (2005-05-01), Ramacher et al.
patent: 2005/0177557 (2005-08-01), Ziauddin et al.
patent: 2006/0074874 (2006-04-01), Day et al.
patent: 2006/0106839 (2006-05-01), Shen et al.
patent: 2006/0129542 (2006-06-01), Hinshaw et al.
patent: 2006/0212428 (2006-09-01), Nelson
patent: 2007/0271218 (2007-11-01), Lim et al.
patent: 2008/0104014 (2008-05-01), Burger et al.
patent: 2008/0133458 (2008-06-01), Zabback et al.
patent: 2008/0222093 (2008-09-01), Fan et al.
patent: 2009/0030888 (2009-01-01), Sahu et al.
patent: 2009/0049012 (2009-02-01), Bossman et al.
patent: 2009/0327214 (2009-12-01), Richardson et al.
patent: 2010/0114868 (2010-05-01), Beavin et al.
patent: 2010/0198808 (2010-08-01), Graefe et al.
Purcell et al., “Insurance for Your Access Paths Across REBINDS”, Intelligent Optimizer, www.idug.org , pp. 37-39, available from as early as Nov. 20, 2007.
http://www.orafaq.com/wiki/Oracle—database—Performance—Tuning—FAQ <retrieved on Oct. 25, 2008>, See section: “My query was fine last week and now it is slow. Why?”
Zhu et al. Building Multistates Cost Models for Dynamic Multidatabase Enivronments.
Office Action received from USPTO, U.S. Appl. No. 12/395,836, Mar. 18, 2011.
Final Office Action Received from USPTO, U.S. Appl. No. 12/395,836, Received Aug. 26, 2011.
Beavin Thomas A.
Bossman Patrick D.
Fuh You-Chin
Pannu Adarsh R.
Purcell Terence P.
International Business Machines - Corporation
Kunzler Needham Masssey & Thorpe
Lewis Cheryl
LandOfFree
Query execution plan efficiency in a database management system does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Query execution plan efficiency in a database management system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Query execution plan efficiency in a database management system will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4281456