Reduce database monitor workload by employing predictive...

Details Reduce database monitor workload by employing predictive... Reduce database monitor workload by employing predictive...

2005-08-30

2005-08-30

Rones, Charles (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

06938035

ABSTRACT:
Methods, systems and articles of manufacture for selectively maintaining query implementation information. A user is able to set a Predictive Query Threshold which will be honored by a database system to determine for which queries information will be collected. In one embodiment, the decision about whether to collect information for a query is made before the query starts to run (i.e., before the plan is executed) by comparing the Predictive Query Threshold to some cost factor (e.g. estimated runtime). In another embodiment, each query may be monitored but the query implementation information is only selectively logged. Specifically, the determination as to whether query implementation information for a query should be logged is made after the query implementation information is collected.

REFERENCES:
patent: 6353818 (2002-03-01), Carino, Jr.
patent: 6529901 (2003-03-01), Chaudhuri et al.
patent: 6640218 (2003-10-01), Golding et al.

Affiliated with

Also associated with

Rating

Reduce database monitor workload by employing predictive... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Reduce database monitor workload by employing predictive..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Reduce database monitor workload by employing predictive... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3523292