StatAdvisor: Recommending statistical views

Proceedings of the VLDB Endowment

Volumn 2, Issue 2, 2009, Pages 1306-1317

  El Helw, Amr ^a   Ilyas, Ihab ^a   Zuzarte, Calisto ^b  

^a UNIVERSITY OF WATERLOO   (Canada)

^b IBM TORONTO LAB   (Canada)

Author keywords

[No Author keywords available]

Indexed keywords

DATABASE SYSTEMS; QUERY PROCESSING;

COMMERCIAL DATABASE SYSTEM; DATABASE STATISTICS; ENUMERATION METHOD; EXECUTION COSTS; INTERMEDIATE RESULTS; LARGE ESTIMATION ERRORS; ORDERS OF MAGNITUDE; SUB-EXPRESSIONS;

STATISTICS;

EID: 80052897879     PISSN: None     EISSN: 21508097     Source Type: Conference Proceeding    
DOI: 10.14778/1687553.1687556     Document Type: Article

References (24)

1. A. Aboulnaga, P. J. Haas, M. Kandil, S. Lightstone, G. M. Lohman, V. Markl, I. Popivanov, and V. Raman. Automated Statistics Collection in DB2 UDB. In VLDB, 2004.
2. S. Acharya, P. B. Gibbons, V. Poosala, and S. Ramaswamy. Join Synopses for Approximate Query Answering. In SIGMOD, 1999.
3. S. Agrawal, S. Chaudhuri, and V. R. Narasayya. Automated Selection of Materialized Views and Indexes in SQL Databases. In VLDB, 2000.
4. B. Babcock and S. Chaudhuri. Towards a Robust Query Optimizer: A Principled and Practical Approach. In SIGMOD, 2005.
5. S. Babu, P. Bizarro, and D. DeWitt. Proactive Re-optimization. In SIGMOD, 2005.
6. N. Bruno and S. Chaudhuri. Exploiting Statistics on Query Expressions for Optimization. In SIGMOD, 2002.
7. N. Bruno and S. Chaudhuri. Conditional Selectivity for Statistics on Query Expressions. In SIGMOD, 2004.
8. S. Chaudhuri, R. Motwani, and V. Narasayya. On Random Sampling over Joins. In SIGMOD, 1999.
9. S. Chaudhuri and V. Narasayya. Automating Statistics Management for Query Optimizers. IEEE TKDE, 13(1), 2001.
10. A. El-Helw, I. F. Ilyas, W. Lau, V. Markl, and C. Zuzarte. Collecting and Maintaining Just-in-Time Statistics. In ICDE, 2007.
11. C. A. Galindo-Legaria, M. Joshi, F. Waas, and M.-C. Wu. Statistics on Views. In VLDB, 2003.
12. I. F. Ilyas, V. Markl, P. Haas, P. Brown, and A. Aboulnaga. CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies. In SIGMOD, 2004.
13. Y. E. Ioannidis and S. Christodoulakis. On the Propagation of Errors in the Size of Join Results. In SIGMOD, 1991.
14. N. Kabra and D. J. DeWitt. Effcient Mid-query Re-optimization of Sub-optimal Query Execution Plans. In SIGMOD, 1998.
15. P.-Å. Larson, W. Lehner, J. Zhou, and P. Zabback. Cardinality Estimation Using Sample Views with Quality Assurance. In SIGMOD, 2007.
16. W. Lehner, B. Cochrane, H. Pirahesh, and M. Zaharioudakis. fAST Refresh using Mass Query Optimization. In ICDE, 2001.
17. V. Markl, V. Raman, D. Simmen, G. Lohman, H. Pirahesh, and M. Cilimdzic. Robust Query Processing through Progressive Optimization. In SIGMOD, 2004.
18. F. Olken and D. Rotem. Simple Random Sampling from Relational Databases. In VLDB, 1986.
19. U. Srivastava, P. J. Haas, V. Markl, M. Kutsch, and T. M. Tran. ISOMER: Consistent Histogram Construction Using Query Feedback. In ICDE, 2006.
20. M. Stillger, G. M. Lohman, V. Markl, and M. Kandil. LEO - DB2's LEarning Optimizer. In VLDB, 2001.
21. TPC. TPC-DS Benchmark, http://www.tpc.org/tpcds, 2005.
22. 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 ICDE, 2000.
23. M. Zaharioudakis, R. Cochrane, G. Lapis, H. Pirahesh, and M. Urata. Answering Complex SQL Queries using Automatic Summary Tables. In SIGMOD, 2000.
24. 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 VLDB, 2004.