Xplus: A SQL-Tuning-Aware Query Optimizer

Proceedings of the VLDB Endowment

Volumn 3, Issue 1, 2010, Pages 1149-1160

  Herodotou, Herodotos ^a   Babu, Shivnath ^a  

^a Duke University   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

QUERY LANGUAGES;

CORRELATED DATA; EXECUTION PLANS; JOIN ORDERINGS; MULTI-TIER SERVICE; NESTED LOOPS; QUERY OPTIMIZER; SERVICE LEVEL OBJECTIVE; TPC-H QUERIES;

QUERY PROCESSING;

EID: 84859229821     PISSN: None     EISSN: 21508097     Source Type: Conference Proceeding    
DOI: 10.14778/1920841.1920984     Document Type: Article

References (23)

1. M. Andrei and P. Valduriez.User-Optimizer Communication using Abstract Plans in Sybase ASE. In Proc. of VLDB '01. ACM, 2001.
2. G. Antoshenkov and M. Ziauddin.Query Processing and Optimization in Oracle Rdb. VLDB Journal, 5(4):229-237, 1996.
3. R. Avnur and J. M. Hellerstein.Eddies: Continuously Adaptive Query Processing. In Proc. of SIGMOD '00. ACM, 2000.
4. B. Babcock and S. Chaudhuri.Towards a Robust Query Optimizer: A Principled and Practical Approach. In Proc. of SIGMOD '05, 2005.
5. S. Babu, P. Bizarro, and D. DeWitt.Proactive Reoptimization. In Proc. of SIGMOD '05. ACM, 2005.
6. P. Belknap, B. Dageville, K. Dias, and K. Yagoub.Self-Tuning for SQL Performance in Oracle Database 11g. Intl. Conf. on Data Engineering, 2009.
7. N. Bruno, S. Chaudhuri, and R. Ramamurthy.Power Hints for Query Optimization. In Intl. Conf. on Data Engineering, 2009.
8. S. Chaudhuri, V. Narasayya, and R. Ramamurthy. A Pay-As-You-Go Framework for Query Execution Feedback. In Proc. of VLDB '08. VLDB Endowment, 2008.
9. C. M. Chen and N. Roussopoulos.Adaptive Selectivity Estimation using Query Feedback. SIGMOD Record, 23(2):161-172, 1994.
10. A. Deshpande, Z. G. Ives, and V. Raman.Adaptive Query Processing. Foundations and Trends in Databases, 1(1):1-140, 2007.
11. S. Duan, V. Thummala, and S. Babu.Tuning Database Configuration Parameters with iTuned. In Proc. of VLDB '09. ACM, 2009.
12. J. C. Gittins and D. M. Jones.A Dynamic Allocation Index for the Sequential Design of Experiments. Progress in Statistics (European Meeting of Statisticians), 1972.
13. G. Graefe and D. J. DeWitt.The EXODUS Optimizer Generator. In Proc. of SIGMOD '87. ACM, 1987.
14. P. J. Haas, I. F. Ilyas, G. M. Lohman, and V. Markl.Discovering and Exploiting Statistical Properties for Query Optimization in Relational Databases: A Survey. Statistical Analysis and Data Mining, 2009.
15. H. Herodotou and S. Babu.Automated SQL Tuning through Trial and (Sometimes) Error. In Proc. of DBTest '09. ACM, 2009.
16. IBM Corp. DB2 Information Center. http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp.
17. IBM DB2. Giving optimization hints to DB2, 2003. http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.doc.perf/db2zgiveoptimizerhints.htm.
18. A. Kemper, G. Moerkotte, and K. Peithner. A Blackboard Architecture for Query Optimization in Object Bases. In Proc. of VLDB '93. ACM, 1993.
19. V. Markl, P. J. Haas, M. Kutsch, N. Megiddo, U. Srivastava, and T. M. Tran. Consistent Selectivity Estimation via Maximum Entropy. VLDB Journal, 16(1):55-76, 2007.
20. V. Markl, V. Raman, D. Simmen, G. Lohman, and H. Pirahesh.Robust Query Processing through Progressive Optimization. In Proc. of SIGMOD '04. ACM, 2004.
21. F. Olken and D. Rotem.Random Sampling from Databases: A Survey. Statistics and Computing, 5:25-42, 1995.
22. P. G. Selinger, M. M. Astrahan, D. D. Chamberlin, R. A. Lorie, and T. G. Price.Access Path Selection in a Relational Database Management System. In Proc. of SIGMOD '79. ACM, 1979.
23. M. Stillger, G. M. Lohman, V. Markl, and M. Kandil.LEO - DB2's Learning Optimizer. In Proc. of VLDB '01. Morgan Kaufmann Publishers Inc., 2001.