Management of database statistics

Details Management of database statistics Management of database statistics

2004-12-30

2010-10-12

Mahmoudi, Tony (Department: 2169)

Data processing: database and file management or data structures

Data integrity

Statistics maintenance

C707S689000

Reexamination Certificate

active

07814072

ABSTRACT:
A method of, a computer program product for and a computer system for managing statistics in a database management system are provided. A value of a volatility of a statistic is determined. A value of a staleness of the statistic is determined using the value of the volatility. A statistics collection task is generated in response to, at least in part, the value of the staleness exceeding a value of a staleness threshold. The statistics collection task is executed to collect an additional value of the statistic. The additional value of the statistic is stored.

REFERENCES:
patent: 5754841 (1998-05-01), Cariño, Jr.
patent: 5794250 (1998-08-01), Cariño, Jr. et al.
patent: 5864843 (1999-01-01), Cariño, Jr. et al.
patent: 5873083 (1999-02-01), Jones et al.
patent: 5899986 (1999-05-01), Ziauddin
patent: 5913206 (1999-06-01), Chaudhuri et al.
patent: 5913207 (1999-06-01), Chaudhuri et al.
patent: 5926813 (1999-07-01), Chaudhuri et al.
patent: 5930786 (1999-07-01), Cariño, Jr. et al.
patent: 5950186 (1999-09-01), Chaudhuri et al.
patent: 6085223 (2000-07-01), Cariño, Jr. et al.
patent: 6105020 (2000-08-01), Lindsay et al.
patent: 6243703 (2001-06-01), Couch et al.
patent: 6249791 (2001-06-01), Osborn et al.
patent: 6353818 (2002-03-01), Carino, Jr.
patent: 6363371 (2002-03-01), Chaudhuri et al.
patent: 6370522 (2002-04-01), Agarwal et al.
patent: 6397207 (2002-05-01), Bleizeffer et al.
patent: 6401083 (2002-06-01), Agarwal et al.
patent: 6401087 (2002-06-01), Yanagimoto
patent: 6493700 (2002-12-01), Couch et al.
patent: 6529901 (2003-03-01), Chaudhuri et al.
patent: 6539371 (2003-03-01), Bleizeffer et al.
patent: 6763352 (2004-07-01), Cochrane et al.
patent: 6847962 (2005-01-01), Cochrane et al.
patent: 6985904 (2006-01-01), Kaluskar et al.
patent: 6990484 (2006-01-01), Ghazal et al.
patent: 7080062 (2006-07-01), Leung et al.
patent: 7302422 (2007-11-01), Bossman et al.
patent: 7412439 (2008-08-01), Bossman et al.
patent: 2002/0049700 (2002-04-01), Couch et al.
patent: 2003/0009446 (2003-01-01), Agarwal et al.
patent: 2003/0115508 (2003-06-01), Ali et al.
patent: 2003/0158842 (2003-08-01), Levy et al.
patent: 2003/0177137 (2003-09-01), MacLeod et al.
patent: 2004/0181521 (2004-09-01), Simmen
patent: 2004/0243555 (2004-12-01), Bolsius et al.
patent: 2005/0138015 (2005-06-01), Dageville et al.
Patrick Bossman, “Tuning SQL with Statistics” [online] Aug. 1999 [Retrieved on May 4, 2006] The IDUG Solutions Journal, Aug. 1999—vol. 6, No. 2, Retrieved from the Internet: <URL: http://arbaltxp-011870/member/journal/aug99/feature1.html> 5 pages.
Office Action mailed May 4, 2007 for U.S. Appl. No. 10/752,915, titled “Method, system, and program for statistics management”, final <11 pages>.
Office Action mailed Jul. 14, 2006 for U.S. Appl. No. 10/752,915, titled “Method, system, and program for statistics management”, non-final <8 pages>.
Office Action mailed Sep. 12, 2007 for U.S. Appl. No. 10/752,915, titled “Method, system, and program for statistics management” <12 pages>.
Office Action mailed Oct. 16, 2006 for U.S. Appl. No. 10/824,856, titled “Query Workload Statistics Collection in a Database Management System” <10 pages>.
Office Action mailed Mar. 5, 2007 for U.S. Appl. No. 10/824,856, titled “Query Workload Statistics Collection in a Database Management System”, final <8 pages>.
Notice of Allowance mailed Jul. 17, 2007 for U.S. Appl. No. 10/824,856, “Query Workload Statistics Collection in a Database Management System”. <6 pages>.
Communication from USPTO mailed on Oct. 22, 2007 with listing of claims for U.S. Appl. No. 10/824,856, titled “Query Workload Statistics Collection in a Database Management System”. <13 pages>.
Notice of Allowability and Examiner's Amendment from Notice of Allowance mailed on Mar. 18, 2008 for U.S. Appl. No. 10/752,915. <5 pages>.
312 Amendment submitted on Apr. 14, 2008 for U.S. Appl. No. 10/752,915. <6 pages>.
Supplemental Notice of Allowability mailed on May 8, 2008 for U.S. Appl. No. 10/752,915. <1 page>.
Response to Rule 312 Communication mailed on May 14, 2008 for U.S. Appl. No. 10/752,915. <2 pages>.
Office Action for U.S. Appl. No. 11/873,252, having a notification date of Feb. 4, 2010 <5 pages>.

Affiliated with

Also associated with

Rating

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

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4210404