Data processing: database and file management or data structures – Database and file access – Query optimization
Reexamination Certificate
2004-09-07
2010-06-29
Cottingham, John R. (Department: 2167)
Data processing: database and file management or data structures
Database and file access
Query optimization
C707S759000
Reexamination Certificate
active
07747606
ABSTRACT:
A method for receiving a database query language statement and performance information about the statement at an optimizer and generating one or more tuning actions for the statement with the performance information is disclosed.
REFERENCES:
patent: 5544355 (1996-08-01), Chaudhuri et al.
patent: 5724569 (1998-03-01), Andres
patent: 5794227 (1998-08-01), Brown
patent: 5860069 (1999-01-01), Wright
patent: 5963933 (1999-10-01), Cheng et al.
patent: 5963934 (1999-10-01), Cochrane et al.
patent: 6052694 (2000-04-01), Bromberg
patent: 6195653 (2001-02-01), Bleizeffer et al.
patent: 6212514 (2001-04-01), Eberhard et al.
patent: 6275818 (2001-08-01), Subramanian et al.
patent: 6321218 (2001-11-01), Guay et al.
patent: 6330552 (2001-12-01), Farrar et al.
patent: 6353818 (2002-03-01), Carino, Jr.
patent: 6366901 (2002-04-01), Ellis
patent: 6366903 (2002-04-01), Agrawal et al.
patent: 6374257 (2002-04-01), Guay et al.
patent: 6397207 (2002-05-01), Bleizeffer et al.
patent: 6460027 (2002-10-01), Cochrane et al.
patent: 6460043 (2002-10-01), Tabbara et al.
patent: 6513029 (2003-01-01), Agrawal et al.
patent: 6529901 (2003-03-01), Chaudhuri et al.
patent: 6571233 (2003-05-01), Beavin et al.
patent: 6594653 (2003-07-01), Colby et al.
patent: 6598038 (2003-07-01), Guay et al.
patent: 6721724 (2004-04-01), Galindo-Legaria et al.
patent: 6728720 (2004-04-01), Lenzie
patent: 6763353 (2004-07-01), Li et al.
patent: 6816874 (2004-11-01), Cotner et al.
patent: 6839713 (2005-01-01), Shi et al.
patent: 6850925 (2005-02-01), Chaudhuri et al.
patent: 6865567 (2005-03-01), Oommen et al.
patent: 6912547 (2005-06-01), Chaudhuri et al.
patent: 6915290 (2005-07-01), Bestgen et al.
patent: 6931389 (2005-08-01), Bleizeffer et al.
patent: 6934701 (2005-08-01), Hall, Jr.
patent: 6947927 (2005-09-01), Chaudhuri et al.
patent: 6999958 (2006-02-01), Carlson et al.
patent: 7007013 (2006-02-01), Davis et al.
patent: 7031958 (2006-04-01), Santosuosso
patent: 7047231 (2006-05-01), Grasshoff et al.
patent: 7058622 (2006-06-01), Tedesco
patent: 7146363 (2006-12-01), Waas et al.
patent: 7155426 (2006-12-01), Al-Azzawe
patent: 7155459 (2006-12-01), Chaudhuri et al.
patent: 7272589 (2007-09-01), Guay et al.
patent: 7302422 (2007-11-01), Bossman et al.
patent: 7353219 (2008-04-01), Markl et al.
patent: 2002/0073086 (2002-06-01), Thompson et al.
patent: 2002/0120617 (2002-08-01), Yoshiyama et al.
patent: 2003/0018618 (2003-01-01), Bestgen et al.
patent: 2003/0065648 (2003-04-01), Driesch et al.
patent: 2003/0088541 (2003-05-01), Zilio et al.
patent: 2003/0093408 (2003-05-01), Brown et al.
patent: 2003/0110153 (2003-06-01), Shee
patent: 2003/0115183 (2003-06-01), Abdo et al.
patent: 2003/0126143 (2003-07-01), Roussopoulos et al.
patent: 2003/0154216 (2003-08-01), Arnold et al.
patent: 2003/0182276 (2003-09-01), Bossman et al.
patent: 2003/0187831 (2003-10-01), Bestgen et al.
patent: 2003/0200204 (2003-10-01), Limoges et al.
patent: 2003/0200537 (2003-10-01), Barsness et al.
patent: 2003/0229621 (2003-12-01), Carlson et al.
patent: 2004/0002957 (2004-01-01), Chaudhuri et al.
patent: 2004/0003004 (2004-01-01), Chaudhuri et al.
patent: 2004/0034643 (2004-02-01), Bonner et al.
patent: 2004/0181521 (2004-09-01), Simmen et al.
patent: 2004/0210563 (2004-10-01), Zait et al.
patent: 2004/0215626 (2004-10-01), Colossi et al.
patent: 2005/0033734 (2005-02-01), Chess et al.
patent: 2005/0097078 (2005-05-01), Lohman et al.
patent: 2005/0102305 (2005-05-01), Chaudhuri et al.
patent: 2005/0125427 (2005-06-01), Dageville et al.
patent: 2006/0167883 (2006-07-01), Boukobza
patent: 2007/0038618 (2007-02-01), Kosciusko et al.
Office Action dated Apr. 20, 2007 for U.S. Appl. No. 10/936,449.
Office Action dated May 2, 2007 for U.S. Appl. No. 10/935,908.
Office Action dated Apr. 19, 2007 for U.S. Appl. No. 10/936,205.
Office Action dated Sep. 6, 2007 for U.S. Appl. No. 10/936,205.
Office Action dated Feb. 7, 2007 for U.S. Appl. No. 10/936,781.
Office Action dated Jul. 30, 2007 for U.S. Appl. No. 10/936,781.
Office Action dated Feb. 22, 2007 for U.S. Appl. No. 10/936,468.
Office Action dated Aug. 22, 2007 for U.S. Appl. No. 10/936,468.
Office Action dated Jan. 25, 2007 for U.S. Appl. No. 10/935,906.
Office Action dated Aug. 9, 2007 for U.S. Appl. No. 10/935,906.
Office Action dated Jan. 24, 2007 for U.S. Appl. No. 10/936,779.
Office Action dated Aug. 22, 2007 for U.S. Appl. No. 10/936,779.
Office Action dated Mar. 9, 2007 for U.S. Appl. No. 10/936,469.
Office Action dated Oct. 17, 2007 for U.S. Appl. No. 10/936,469.
Office Action dated May 1, 2007 for U.S. Appl. No. 10/936,426.
Office Action dated Sep. 6, 2007 for U.S. Appl. No. 10/936,426.
Office Action dated Jan. 26, 2007 for U.S. Appl. No. 10/936,427.
Office Action dated Aug. 22, 2007 for U.S. Appl. No. 10/936,427.
Avnur, R. et al. “Eddies: Continuously Adaptive Query Processing” Proceedings of the 2000 ACM SIGMOD International Conference on Management of Data (SIGMOD '00), Dallas, TX, May 15-18, 2000, pp. 261-272.
Blakeley, J.A. et al. “Experiences Building the Open OODB Query Optimizer” Proceedings of the 1993 ACM SIGMOD International Conference on Management of Data (SIGMOD '93), Washington, DC, May 25-28, 1993, pp. 287-296.
Bruno, N. et al. “STHoles: A Multidimensional Workload-Aware Histogram” Proceedings of the 2001 ACM SIGMOD International Conference on Management of Data (SIGMOD '01), Santa Barbara, CA, May 21-24, 2001, pp. 211-222.
Bruno, N. et al. “Exploiting Statistics on Query Expressions for Optimization” Proceedings of the 2002 ACM SIGMOD International Conference on Data Management (SIGMOD '02), Madison, WI, Jun. 4-6, 2002, pp. 263-274.
Chaudhuri, S. “An Overview of Query Optimization in Relational Systems” Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (PODS '98), Seattle, WA, Jun. 1-4, 1998, pp. 34-43.
Chaudhuri, S. et al. “Rethinking Database System Architecture: Towards a Self-Tuning RISC-style Database System” Proceedings of the 26th International Conference on Very Large Databases (VLDB 2000), Cairo, Egypt, Sep. 10-14, 2000, pp. 1-10.
Chen, C.M. et al. “Adaptive Selectivity Estimation Using Query Feedback” Proceedings of the 1994 ACM SIGMOD International Conference on Management of Data (SIGMOD '94), Minneapolis, MN, May 24-27, 1994, pp. 161-172.
Derr, M.A. “Adaptive Query Optimization in a Deductive Database System” Proceedings of the 2nd International Conference on Information and Knowledge Management (CIKM '93), Washington, DC, Nov. 1-5, 1993, pp. 206-215.
Ganek, A.G. et al. “The dawning of the autonomic computing era” IBM Systems Journal, 2003, vol. 42, No. 1, pp. 5-18.
Gassner, P. et al. “Query Optimization in the IBM DB2 Family” Data Engineering, Dec. 1993, vol. 16, No. 4, pp. 4-18.
Getoor, L. et al. “Selectivity Estimation using Probabilistic Models” Proceedings of the 2001 ACM SIGMOD International Conference on Management of Data (SIGMOD '01), Santa Barbara, CA, May 21-24, 2001, pp. 461-472.
Gorman, T. “The Search for Intelligent Life in the Cost-Based Optimizer” Jul. 2001, v1.0, pp. 1-11.
IBM “DB2 Universal Database Slashes Administration Costs by Reducing Time Spent on Administrative Tasks by up to 65 Percent” MarketWire, Sep. 9, 2004, pp. 1-3, located at http://www.marketwire.com/mw/release—html-b1?release—id=72387.
Ives, Z.G. et al. “An Adaptive Query Execution System for Data Integration” Proceedings of the 1999 ACM SIGMOD International Conference on Management of Data (SIGMOD '99), Philadelphia, PA, Jun. 1-3, 1999, pp. 299-310.
Lightstone, S.S. et al. “Toward Autonomic Computing with DB2 Universal Database” ACM SIGMOD Record, Sep. 2002, vol. 31, No. 3, pp. 55-61.
Markl, V. et al. “LEO: An autonomic query optimizer for DB2” IBM Systems Journal, 2003, vol. 42, No. 1, pp. 98-106.
Scheuermann, P. et al. “Adaptive Algorithms for Join Processing in Distributed Database Systems” D
Dageville Benoit
Das Dinesh
Dias Karl
Ramacher Mark
Tan Leng Leng
Cottingham John R.
Oracle International Corporation
Pham Michael
Vista IP Law Group LLP.
LandOfFree
Automatic SQL tuning advisor does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Automatic SQL tuning advisor, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Automatic SQL tuning advisor will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4163296