Statistics management

Details Statistics management Statistics management

2011-07-19

2011-07-19

Kim, Paul (Department: 2169)

Data processing: database and file management or data structures

Data integrity

Statistics maintenance

C707S687000, C707S689000, C707S690000

Reexamination Certificate

active

07984024

ABSTRACT:
Disclosed is a technique for maintaining statistics. A query is received. Column group generation is performed to form one or more column groups. Column group refinement is performed based on statistics data generated for a previously received query. A statistics check is automatically performed. A statistics collection command is generated to obtain statistics.

REFERENCES:
patent: 5689698 (1997-11-01), Jones et al.
patent: 5734884 (1998-03-01), Eberhard et al.
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: 6023695 (2000-02-01), Osborn et al.
patent: 6026391 (2000-02-01), Osborn et al.
patent: 6029163 (2000-02-01), Ziauddin
patent: 6085223 (2000-07-01), Cariño, Jr. et al.
patent: 6105020 (2000-08-01), Lindsay et al.
patent: 6195653 (2001-02-01), Bleizeffer et al.
patent: 6243703 (2001-06-01), Couch et al.
patent: 6249791 (2001-06-01), Osborn et al.
patent: 6351742 (2002-02-01), Agarwal et al.
patent: 6353818 (2002-03-01), Carino, Jr.
patent: 6363371 (2002-03-01), Chaudhuri et al.
patent: 6366901 (2002-04-01), Ellis
patent: 6370522 (2002-04-01), Agarwal et al.
patent: 6370523 (2002-04-01), Anderson
patent: 6397207 (2002-05-01), Bleizeffer et al.
patent: 6401083 (2002-06-01), Agarwal et al.
patent: 6401087 (2002-06-01), Yanagimoto
patent: 6434745 (2002-08-01), Conley, Jr. et al.
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: 6744449 (2004-06-01), MacLeod 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: 7139749 (2006-11-01), Bossman et al.
patent: 7302422 (2007-11-01), Bossman et al.
patent: 7412439 (2008-08-01), Bossman et al.
patent: 7814072 (2010-10-01), Bossman et al.
patent: 2002/0049700 (2002-04-01), Couch et al.
patent: 2002/0087518 (2002-07-01), Ellis et al.
patent: 2003/0009446 (2003-01-01), Agarwal et al.
patent: 2003/0065648 (2003-04-01), Driesch, Jr. et al.
patent: 2003/0088579 (2003-05-01), Brown et al.
patent: 2003/0093408 (2003-05-01), Brown et al.
patent: 2003/0115183 (2003-06-01), Abdo et al.
patent: 2003/0115508 (2003-06-01), Ali et al.
patent: 2003/0154216 (2003-08-01), Arnold et al.
patent: 2003/0158842 (2003-08-01), Levy et al.
patent: 2003/0177137 (2003-09-01), MacLeod et al.
patent: 2003/0182276 (2003-09-01), Bossman et al.
patent: 2004/0010488 (2004-01-01), Chaudhuri et al.
patent: 2004/0034643 (2004-02-01), Bonner et al.
patent: 2004/0059743 (2004-03-01), Burger
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.
patent: 2008/0033912 (2008-02-01), Bossman et al.
Microsoft Corporation, “Statistical Information: Creating and Maintaining Databases (SQL Server)”, [online]. © 2003 Microsoft Corporation, [Retrieved on Sep. 2, 2003]. Retrieved from the Internet at <URL: http://msdn.microsoft.com/library/en-us/createdb/cm—8—des—05—72r9.asp?frame+true>, 3 pp.
Amendment after Notice of Allowance Under 37 CFR 1.312/Comments on Statements of Reasons for Allowance, Apr. 14, 2008, for U.S. Appl. No. 10/752,915, Total 8 pp.
Astrahan et al., “Access Path Selection in a Relational Database Management System”, [online], IBM Technical Disclosure Bulletin, Sep. 1979, [Retrieved on Nov. 26, 2003]. Retrieved from the Internet at <URL: https://www.delphion.com/tdbs/tdb?order=79A+05833>, Total 4 pp.
Bossman, P., “Tuning SQL with Statistics”, The IDUG Solutions Journal, Aug. 1999, vol. 6, No. 2, Total 5 pp.
Bruni, P., M. Antonelli, T. Crocker, D. Goethals, R. Naidoo, and B. Steegmans, “DB2 for z/OS and OS/390 Version 7 Using the Utilities Suite”, IBM Aug. 2001, Total 60 pp.
Cheng et al., “Multiple Indexed Access Path in a Relational Database System”, [online], IBM Technical Disclosure Bulletin, Mar. 1990, [Retrieved on Nov. 26, 2003]. Retrieved from the Internet at <URL: https://wwww.delphion.com/tdbs/tdb?order=90a+61127>, Total 4 pp.
Final Office Action 1, May 4, 2007, for U.S. Appl. No. 10/752,915, Total 11 pp.
IBM Corp., “DB2 Universal Database for OS/390 and z/OS, Utility Guide and Reference Version 7”, Jun. 2003, Total 27 pp.
IBM Corp., “Gathering Monitor and Update Statistics”, IBM Corporation 1982, 2004, last updated: Mar. 2004, Total 2 pp.
IBM Corp., “Querying the Catalog for Statistics”, IBM Corporation 1982, 2004, last updated: Mar. 2004, Total 1 p.
IBM Corp., “TDB: DB2 Cost Formula”, [online], IBM Technical Disclosure Bulletin, May 1992, [Retrieved on Nov. 26, 2003]. Retrieved from the Internet at <URL: https://www.delphion.com/tdbs/tdb?order=92A+61329>, Total 4 pp.
Microsoft Corp., “Statistical Information (Creating and Maintaining Databases (SQL Server))”, © 2003 Microsoft Corporation, Total 3 pp.
Notice of Allowance 1, Jul. 17, 2007, for U.S. Appl. No. 10/824,856, Total 17 pp.
Notice of Allowance 1, Mar. 18, 2008, for U.S. Appl. No. 10/752,915, Total 7 pp.
Office Action 1, Jul. 14, 2006, for U.S. Appl. No. 10/752,915, Total 11 pp.
Office Action 1, Oct. 16, 2006, for U.S. Appl. No. 10/824,856, Total 18 pp.
Final Office Action 1, Mar. 5, 2007, for U.S. Appl. No. 10/824,856, Total 12 pp.
Office Action 1, Feb. 4, 2010, for U.S. Appl. No. 11/873,252, Total 29 pp.
Office Action 3, Sep. 12, 2007, for U.S. Appl. No. 10/752,915, Total 12 pp.
Response to Rule 312 Communication, May 14, 2008, for U.S. Appl. No. 10/752,915, Total 2 pp.
Response to Rule 312 Communication, Oct. 22, 2007, for U.S. Appl. No. 10/824,856, Total 15 pp.
Sanjeev, “Working with History: DB2 Catalog History Tables”, [online], [Retrieved on Jul. 19, 2004]. Retrieved from the Internet at <URL: http://www.idug.org/idug/member/journal/Mar02/articl09.cfm>, Total 10 pp. Sanjeev, “Working with History: DB2 Catalog History Tables”, [online], [Retrieved on Jul. 19, 2004]. Retrieved from the Internet at <URL: http://www.idug.org/idug/member/journal/Mar02/artic109.cfm>, Total 10 pp.
Supplemental Notice of Allowability, May 8, 2008, for U.S. Appl. No. 10/752,915, Total 3 pp.
Amendment 1, Jan. 16, 2007, for U.S. Appl. No. 10/824,856, Total 23 pp.
Amendment 1, Aug. 17, 2009, for U.S. Appl. No. 11/028,186, Total 67 pp.
Amendment 2, May 7, 2007, for U.S. Appl. No. 10/824,856, Total 24 pp.
RCE and Amendment 3, Jun. 5, 2007, for U.S. Appl. No. 10/824,856, Total 25 pp.
312 Amendment, Oct. 15, 2007, for U.S. Appl. No. 10/824,856, Total 21 pp.
Amendment 1, Oct. 16, 2006, for U.S. Appl. No. 10/752,915, Total 15 pp.
Amendment 2, Aug. 6, 2007, for U.S. Appl. No. 10/752,915, Total 17 pp.
Amendment 3, Dec. 10, 2007, for U.S. Appl. No. 10/752,915, Total 13 pp.
NOA & Examiner's Amendment, Mar. 18, 2008, for U.S. Appl. No. 10/752,915, Total 7 pp.
Notice of Allowance 1, Jun. 4, 2010, for U.S. Appl. No. 11/028,186, Total 56 pp.
Final Office Action 1, Nov. 16, 2009, for U.S. Appl. No. 11/028,186, Total 71 pp.
Office Action 1, Apr. 17, 2009, for U.S. Appl. No. 11/028,186, Total 70 pp.
RCE and Amendment, Mar. 16, 2010, for U.S. Appl. No. 11/028,186, Total 34 pp.

Affiliated with

Also associated with

Rating

Statistics management does not yet have a rating. At this time, there are no reviews or comments for this patent.

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2675343