Automatic database statistics creation

Data processing: database and file management or data structures – Database design – Data structure types

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

Reexamination Certificate

active

06847978

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: 5588150 (1996-12-01), Lin et al.
patent: 5630120 (1997-05-01), Vachey
patent: 5668987 (1997-09-01), Schneider
patent: 5806061 (1998-09-01), Chaudhuri et al.
patent: 6012054 (2000-01-01), Seputis
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: 6205441 (2001-03-01), Al-omari et al.
patent: 6327587 (2001-12-01), Forster
patent: 6343288 (2002-01-01), Lindsay et al.
patent: 6366901 (2002-04-01), Ellis
patent: 6460045 (2002-10-01), Aboulnaga et al.
patent: 6470330 (2002-10-01), Das et al.
Soukup, R., “Inside SQL Server™ 6.5”, Microsoft® Programming Series, Microsoft® Press, 1997 pp. 1-32(renumbered).
Chaudhuri, et al., “Automating statistics management for query optimizer,”Knowledge and Data Engineering, IEEE publication Mar. 2000, 13(1), 7-20.
Dietker, et al., “A tool for nesting and clustering large objects,”Scientific and Statistical Database Management Proc., 12thIntern. Confer., IEEE publication Jul. 2000, 169-181.
Soukup, R., “Inside SQL Server™ 6.5,” Microsoft® Programming Series, Microsoft® Press, 1997.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

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

     

Profile ID: LFUS-PAI-O-3418741

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.