Query optimizer cost model

Details Query optimizer cost model Query optimizer cost model

2005-10-18

2005-10-18

Mizrahi, Diane D. (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

06957211

ABSTRACT:
An embodiment of the invention optimizes a DBMS operation based upon multiple criteria, such as input/outputs and CPU time. Multiple optimization criteria are normalized to a common unit of measurement. Normalized optimization criteria are used in a cost function. Estimated execution times are calculated under a variety of different workload environments. Cost values are scaled to a variety of computer architectures.

REFERENCES:
patent: 5301317 (1994-04-01), Lohman et al.
patent: 5325525 (1994-06-01), Shan et al.
patent: 6212514 (2001-04-01), Eberhard et al.
patent: 6470360 (2002-10-01), Vaitheeswaran
patent: 2002/0004912 (2002-01-01), Fung
patent: 2002/0129003 (2002-09-01), Bakalash et al.
patent: 2002/0184187 (2002-12-01), Bakalash et al.
IBM CorporationAdministration Guide: Performance, Version 7 in IBM® DB2® Universal Database(2000).

Affiliated with

Also associated with

Rating

Query optimizer cost model does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Query optimizer cost model, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Query optimizer cost model will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3449169