Automatic database statistics creation

Details Automatic database statistics creation Automatic database statistics creation

2007-10-30

2007-10-30

Mizrahi, Diane (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

10981799

ABSTRACT:
A system for automatic statistics creation comprises a query optimizer which automatically generates statistics derived from data in a database and selects an executable procedure from a plurality of procedures that operate on data in a database using the automatically generated statistics. A counter is maintained of updates made to each statistic that has been automatically generated. If the counter breaches a threshold, the automatically generated statistic is removed from the database.

REFERENCES:
patent: 6052689 (2000-04-01), Muthukrishnan et al.
patent: 6065007 (2000-05-01), Muthukrishnan et al.
patent: 6092062 (2000-07-01), Lohman et al.
patent: 6108658 (2000-08-01), Lindsay et al.
patent: 6178449 (2001-01-01), Forman et al.
patent: 6470330 (2002-10-01), Das et al.

Affiliated with

Also associated with

Rating

Automatic database statistics creation does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Automatic database statistics creation, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Automatic database statistics creation will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3864852