The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Nov. 15, 2011
Filed:
Oct. 21, 2008
Thomas A. Beavin, Milpitas, CA (US);
Patrick D. Bossman, Alexandria, VA (US);
You-chin Fuh, San Jose, CA (US);
Adarsh R. Pannu, San Jose, CA (US);
Terence P. Purcell, New Berlin, IL (US);
Thomas A. Beavin, Milpitas, CA (US);
Patrick D. Bossman, Alexandria, VA (US);
You-Chin Fuh, San Jose, CA (US);
Adarsh R. Pannu, San Jose, CA (US);
Terence P. Purcell, New Berlin, IL (US);
International Business Machines Corporation, Armonk, NY (US);
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.