Data processing: database and file management or data structures – Database and file access – Query optimization
Reexamination Certificate
2011-04-12
2011-04-12
Le, Debbie (Department: 2168)
Data processing: database and file management or data structures
Database and file access
Query optimization
C707S718000, C707S719000
Reexamination Certificate
active
07925648
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.
REFERENCES:
patent: 5301317 (1994-04-01), Lohman et al.
patent: 5659786 (1997-08-01), George et al.
patent: 5918229 (1999-06-01), Davis et al.
patent: 6339773 (2002-01-01), Rishe
patent: 6353818 (2002-03-01), Carino, Jr.
patent: 6779016 (2004-08-01), Aziz et al.
patent: 6789074 (2004-09-01), Hara et al.
patent: 2003/0065648 (2003-04-01), Driesch, Jr. et al.
patent: 2004/0030677 (2004-02-01), Young-Lai
Barsness Eric Lawrence
Majd Mahdad
Ruhlow Randy William
Santosuosso John Matthew
International Business Machines - Corporation
Le Debbie
Meng Thomas
Truelson Roy W.
LandOfFree
Dynamically selecting alternative query access plans does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Dynamically selecting alternative query access plans, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Dynamically selecting alternative query access plans will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2742096