Optimization of queries using retrieval status of resources...

Details Optimization of queries using retrieval status of resources... Optimization of queries using retrieval status of resources...

2007-12-11

2007-12-11

Pham, Khanh B. (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

10691296

ABSTRACT:
An apparatus, program product and method utilize the retrieval status of a resource to generate an access plan for a database query that uses the resource. The retrieval status, which indicates, for example, what percentage of a given resource is already stored in working memory, and thus need not be separately retrieved during query execution, may be used to generate more accurate input/output cost estimates for access plans, and thus enable a query optimizer to better select an access plan that is optimal under given runtime conditions.

REFERENCES:
patent: 5812996 (1998-09-01), Rubin et al.
patent: 5822749 (1998-10-01), Agarwal
patent: 6073129 (2000-06-01), Levine et al.
patent: 6266658 (2001-07-01), Adya et al.
patent: 6353818 (2002-03-01), Carino, Jr.
patent: 6356890 (2002-03-01), Agrawal et al.
patent: 6763357 (2004-07-01), Deshpande et al.
patent: 2001/0037329 (2001-11-01), Huffman et al.
patent: 2001/0051956 (2001-12-01), Bird
patent: 2002/0107914 (2002-08-01), Charisius et al.
patent: 2003/0065648 (2003-04-01), Driesch et al.
patent: 2004/0073549 (2004-04-01), Turkel et al.
patent: 2004/0243555 (2004-12-01), Bolsius et al.

Affiliated with

Also associated with

Rating

Optimization of queries using retrieval status of resources... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Optimization of queries using retrieval status of resources..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Optimization of queries using retrieval status of resources... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3868585