Systems and methods for estimating query response times in a com

Details Systems and methods for estimating query response times in a com Systems and methods for estimating query response times in a com

1997-10-31

2000-02-15

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

707 3, 707 4, 707 5, G06F 1730

Patent

active

060263911

ABSTRACT:
A query performance prediction ("QPP") module is provided as part of an applications layer residing on respective user stations operating in conjunction with a centralized host computer system. The QPP module correlates estimated system cost information for a database query provided from a database management system associated with the computer system with statistics compiled from previous queries in order to estimate the system response time. In particular, an estimated CPU time for executing the present query is derived by extrapolating actual CPU times recorded for past queries having the closest estimated costs for accessing the same, or similar, tables and items in the database, using a form of a "nearest neighbor" algorithm to match the present query to either identical or statistically closest past queries. The estimated CPU time for the present query is then multiplied by a current ratio of total elapsed times-to-CPU times for the system to produce an estimated total elapsed time for responding to the query.

REFERENCES:
patent: 4803614 (1989-02-01), Banba et al.
patent: 4956774 (1990-09-01), Shibamiya et al.
patent: 5287459 (1994-02-01), Gniewek
patent: 5315580 (1994-05-01), Phaal
patent: 5379424 (1995-01-01), Morimoto et al.
patent: 5412806 (1995-05-01), Du et al.
patent: 5444820 (1995-08-01), Tzes et al.
patent: 5459837 (1995-10-01), Caccavale
patent: 5469560 (1995-11-01), Beglin
patent: 5504894 (1996-04-01), Fegurson et al.
patent: 5572640 (1996-11-01), Schettler
patent: 5694591 (1997-12-01), Du et al.
patent: 5764912 (1998-06-01), Rosborough
patent: 5794227 (1998-08-01), Brown
patent: 5852820 (1998-12-01), Burrows

Affiliated with

Also associated with

Rating

Systems and methods for estimating query response times in a com does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Systems and methods for estimating query response times in a com, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Systems and methods for estimating query response times in a com will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1914576