Query workload statistics collection in a database...

Data processing: database and file management or data structures – Database design – Data structure types

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

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>.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

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.

Rate now

     

Profile ID: LFUS-PAI-O-3889761

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.