Patents by Inventor Terrence P. Purcell

Terrence P. Purcell has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Patent number: 7644063
    Abstract: An apparatus, system, and method are disclosed for ensuring query execution plan stability in a database management system. The present invention binds a static database query to a new query execution plan (QEP) that produces the same result set as an original QEP bound to the static database query. Next, the present invention identifies one of the original QEP and the new QEP as a primary QEP and automatically collects execution statistics for the original QEP and the new QEP. Finally, the present invention automatically selects one of the original QEP and the new QEP as the primary QEP in response to completion of the automatic collection of execution statistics, the primary QEP selected such that the automatically selected QEP provides optimal execution performance based on performance criteria in comparison to the automatically unselected QEP, the primary QEP selected based on the execution statistics.
    Type: Grant
    Filed: August 17, 2007
    Date of Patent: January 5, 2010
    Assignee: International Business Machines Corporation
    Inventors: Patrick D. Bossman, Frank D. Bower, John J. Campbell, You-Chin Fuh, Adarsh R. Pannu, Terrence P. Purcell