Data processing: database and file management or data structures – Database and file access – Record – file – and data search and comparisons
Reexamination Certificate
2004-11-22
2010-06-15
Fleurantin, Jean B (Department: 2162)
Data processing: database and file management or data structures
Database and file access
Record, file, and data search and comparisons
C707S768000
Reexamination Certificate
active
07739293
ABSTRACT:
The present invention relates to collecting statistics automatically for data in a database. There is provided a method for automated statistics collection comprising determining a likelihood that statistics for data have changed; and collecting statistics for data in response to the likelihood. Indicators of the likelihood that statistics have changed may be useful to trigger automated statistics collection. Tables having statistics that change significantly may be collected more often than statistics of tables that are stable. A preferred model is provided to facilitate the collection of statistics that are more relevant: a table is scheduled for collection in accordance with observed patterns of table activity; a table is considered for collection if it meets a threshold level of activity; and a table is sampled to predict whether the statistics to be collected have changed. When collecting statistics, throttling and lock contention can minimize impact on a database user's response experience.
REFERENCES:
patent: 5542089 (1996-07-01), Lindsay et al.
patent: 5781735 (1998-07-01), Southard
patent: 5813002 (1998-09-01), Agrawal et al.
patent: 5870752 (1999-02-01), Gibbons et al.
patent: 5950185 (1999-09-01), Alon
patent: 6029163 (2000-02-01), Ziauddin
patent: 6434570 (2002-08-01), Rangan
patent: 6477523 (2002-11-01), Chiang
patent: 6529901 (2003-03-01), Chaudhuri et al.
patent: 6535870 (2003-03-01), Friske et al.
patent: 7302422 (2007-11-01), Bossman et al.
patent: 2002/0087518 (2002-07-01), Ellis et al.
patent: 2002/0124001 (2002-09-01), Chaudhuri et al.
patent: 2004/0034643 (2004-02-01), Bonner et al.
patent: WO 01/04798 (2001-01-01), None
IBM Technical Disclosure NB9003388.
“Automate database upkeep with the SQL Server Maintenance Plan Wizard” (2002).
Denk et al., Statistical composites: a transformation-bound representation of statistical datasets, Jul. 24-26, 2002, IEEE, 217-226.
Malvestuto et al., Query evaluability in statistical databases, Dec. 1990, IEEE, vol. 2, 425-430.
Lightstone, S.S., et al.,Smarter DB2: IBM Puts DB2 on a Path toward Self-maintenance that Promises to Help DBAs Stay on Top of their Workloads, DB2Magazine vol. 7, Issue 4, Quarter 4, 2002, p. 32-41.
Bauchot, et al., U.S. Appl. No. 10/835,015,Method and System in an Electronic Data Table for Managing Order Oriented Criterias, filed Apr. 29, 2004. Filed in EP Apr. 29, 2003, application # 033680448. All pages.
Lightstone Sam Sampson
Popivanov Ivan
Rose Kevin R.
Fleurantin Jean B
International Business Machines - Corporation
Sughrue & Mion, PLLC
LandOfFree
Method, system, and program for collecting statistics of... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method, system, and program for collecting statistics of..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, system, and program for collecting statistics of... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4172608