Robustness in automatic physical database design

Advances in Database Technology - EDBT 2008 - 11th International Conference on Extending Database Technology, Proceedings

Volumn , Issue , 2008, Pages 145-156

  El Gebaly, Kareem ^a   Aboulnaga, Ashraf ^b  

^a ERICSSON RESEARCH   (Sweden)

^b UNIVERSITY OF WATERLOO   (Canada)

Author keywords

[No Author keywords available]

Indexed keywords

OPTIMIZATION; PROBLEM SOLVING; ROBUSTNESS (CONTROL SYSTEMS); SYSTEMS ANALYSIS;

DATABASE DESIGN; POSTGRESQL;

QUERY LANGUAGES;

EID: 43349101821     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1353343.1353365     Document Type: Conference Paper

References (26)

1. PostgreSQL. http://www.postgresql.org.
2. A. Aboulnaga and S. Chaudhuri. Self-tuning histograms: building histograms without looking at data. In Proc. SIGMOD, 1999.
3. A. Aboulnaga, P. J. Haas, S. Lightstone, G. M. Lohman, V. Markl, I. Popivanov, and V. Raman. Automated statistics collection in DB2 UDB. In Proc. VLDB, 2004.
4. S. Agrawal, S. Chaudhuri, L. KoMr, A. P. Marathe, V. R. Narasayya, and M. Syamala. Database tuning advisor for Microsoft SQL Server 2005. In Proc. VLDB, 2004.
5. S. Agrawal, S. Chaudhuri, and V. R. Narasayya. Automated selection of materialized views and indexes in SQL databases. In Proc. VLDB, 2000.
6. S. Agrawal, E. Chu, and V. R. Narasayya. Automatic physical design tuning: Workload as a sequence. In Proc. SIGMOD, 2006.
7. B. Babcock and S. Chaudhuri. Towards a robust query optimizer: A principled and practical approach. In Proc. SIGMOD, 2005.
8. S. Babu, P. Bizarro, and D. DeWitt. Proactive re-optimization. In Proc. SIGMOD, 2005.
9. N. Bruno and S. Chaudhuri. Exploiting statistics on query expressions for optimization. In Proc. SIGMOD, 2002.
10. N. Bruno and S. Chaudhuri. Efficient creation of statistics over query expressions. In Proc. ICDE, 2003.
11. N. Bruno and S. Chaudhuri. Conditional selectivity for statistics on query expressions. In Proc. SIGMOD, 2004.
12. N. Bruno and S. Chaudhuri. Automatic physical database tuning: A relaxation-based approach. In Proc. SIGMOD, 2005.
13. N. Bruno and S. Chaudhuri. Physical design refinement: The "merge-reduce" approach. In Proc. EDBT, 2006.
14. N. Bruno and S. Chaudhuri. To tune or not to tune? A lightweight physical design alerter. In Proc. VLDB, 2006.
15. N. Bruno and S. Chaudhuri. An online approach to physical design tuning. In Proc. ICDE, 2007.
16. N. Bruno, S. Chaudhuri, and L. Gravano. STHoles: A multidimensional workload-aware histogram. In Proc. SIGMOD, 2001.
17. S. Chaudhuri, A. K. Gupta, and V. R. Narasayya. Compressing SQL workloads. In Proc. SIGMOD, 2002.
18. S. Chaudhuri and V. Narasayya. Autoadmin "what-if" index analysis utility. In Proc. SIGMOD, 1998.
19. S. Chaudhuri and V. R. Narasayya. An efficient cost-driven index selection tool for Microsoft SQL Server. In Proc. VLDB, 1997.
20. B. Dageville, D. Das, K. Dias, K. Yagoub, M. Zaït, and M. Ziauddin. Automatic SQL tuning in Oracle 10g. In Proc. VLDB, 2004.
21. K. El Gebaly. Robustness in automatic physical database design. Master's thesis, University of Waterloo, 2007. Also available as University of Waterloo Computer Science Technical Report CS-2007-29.
22. A. C. König and S. U. Nabar. Scalable exploration of physical database design. In Proc. ICDE, 2006.
23. M. Stillger, G. M. Lohman, V. Markl, and M. Kandil. LEO - DB2's LEarning Optimizer. In Proc. VLDB, 2001.
24. Transaction Processing Performance Council. TPC-H, the Ad-hoc Decision Support Benchmark. http://www.tpc.org.
25. G. Valentin, M. Zuliani, D. C. Zilio, G. M. Lohman, and A. Skelley. DB2 advisor: An optimizer smart enough to recommend its own indexes. In Proc. ICDE, 2000.
26. D. C. Zilio, J. Rao, S. Lightstone, G. M. Lohman, A. Storm, C. Garcia-Arellano, and S. Fadden. DB2 design advisor: Integrated automatic physical database design. In Proc. VLDB, 2004.