Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-11-27
2007-11-27
Huong, Cam Y. (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
10824856
ABSTRACT:
In various embodiments, a method, apparatus, and article of manufacture collect statistics in a database management system. A workload comprising a plurality of database queries is received. Query statistics for the database queries are identified. The query statistics for the database queries are consolidated to provide consolidated statistics. One or more statistics collection requests are generated based on the consolidated statistics.
REFERENCES:
patent: 5689698 (1997-11-01), Jones 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: 6085223 (2000-07-01), Cariño, Jr. 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: 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: 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/0177137 (2003-09-01), MacLeod et al.
patent: 2003/0182276 (2003-09-01), Bossman et al.
patent: 2006/0149695 (2006-07-01), Bossman et al.
United States Patent Application title, “Method, System, and Program for Statistics Management,” to Patrick Dooling Bossman, You-Chin Fuh, and Chan-Hua Liu, Filed Jan. 7, 2004, U.S. Appl. No. 10/752,915, IBM Docket No. SVL920030089US1.
A. Shibamiya et al., “DB2 Cost Formula,” May 1992, International Business Machines (IBM) Technical Disclosure Bulletin (TDB), Publication No. 12, pp. 389-394.
J.M. Cheng et al., “Multiple Indexed Access Path in a Relational Database System,” Mar. 1990, International Business Machines (IBM) Technical Disclosure Bulletin (TDB), Publication No. 10b, pp. 388-392.
M.M. Astrahan et al., “Access Path Selection in a Relational Database Management System,” Sep. 1979, International Business Machines (IBM) Technical Disclosure Bulletin (TDB), pp. 1657-1660.
Microsoft Corp., “Creating and Maintaining Databases. Statistical Information,” pp. 1-3 retreived on Sep. 2, 2003 from http://msdn.microsoft.com/library/en-us/createdb/cm—8—des—o5—72r9.asp?frame+true.
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 rejection <11 pages>.
Office Action mailed Jul. 1, 2006 for U.S. Appl. No. 10/752,915, titled “Method, system, and program for statistics management”, non-final rejection <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>.
Bossman Patrick Dooling
Fuh You-Chin
Guo Shuanglin
Liu Chan-Hua
Tsuji Yoichi
Foerster Ingrid M.
Huong Cam Y.
International Business Machines - Corporation
Le Thu-Nguyet
Plow Gregory M.
LandOfFree
Query workload statistics collection in a database... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Query workload statistics collection in a database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Query workload statistics collection in a database... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3889761