Automatic database statistics creation

Details Automatic database statistics creation Automatic database statistics creation

2005-01-25

2005-01-25

Mizrahi, Diane D. (Department: 2175)

Data processing: database and file management or data structures

Database design

Data structure types

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.

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-3418741