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:
Apr. 12, 2011
Filed:
Aug. 16, 2007
Eric Lawrence Barsness, Pine Island, MN (US);
Mahdad Majd, Rochester, MN (US);
Randy William Ruhlow, Rochester, MN (US);
John Matthew Santosuosso, Rochester, MN (US);
Eric Lawrence Barsness, Pine Island, MN (US);
Mahdad Majd, Rochester, MN (US);
Randy William Ruhlow, Rochester, MN (US);
John Matthew Santosuosso, Rochester, MN (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A query access plan for executing a database query is dynamically selected from among multiple alternative query access plans based on the availability of computer resources allocated for running the query. Preferably, a first query access plan is generated based on resources then available, and if it is possible to provide additional resources, one or more alternative plans are generated based on the additional resources. If an alternative plan is significantly better than the original plan based on a comparison of query related parameters, the alternative is chosen for executing the query. Additional resources for running the query may be provided from logically partitioned and/or grid environments.