Automatic database statistics creation

Details Automatic database statistics creation Automatic database statistics creation

2004-11-05

2009-11-24

Robinson, Greta L (Department: 2169)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07624094

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: 5542089 (1996-07-01), Lindsay et al.
patent: 5873075 (1999-02-01), Cochrane et al.
patent: 6029163 (2000-02-01), Ziauddin
patent: 6272487 (2001-08-01), Beavin et al.
patent: 6353826 (2002-03-01), Seputis
patent: 6397204 (2002-05-01), Liu et al.
patent: 6915301 (2005-07-01), Hirsch
patent: 2007/0255730 (2007-11-01), Mack
patent: 2007/0255732 (2007-11-01), Moss
patent: 2007/0255734 (2007-11-01), Morimoto
patent: 2007/0255735 (2007-11-01), Taylor 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-4100840