Scalable exploration of physical database design

Proceedings - International Conference on Data Engineering

Volumn 2006, Issue , 2006, Pages 37-

  König, Arnd Christian ^a   Nabar, Shubha U ^b  

^a MICROSOFT RESEARCH   (United States)

^b STANFORD UNIVERSITY   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

DATABASE DESIGNS; LARGE SCALE DBMS; SCALABLE SELECTION PROCEDURES; SKEWED COST DISTRIBUTIONS;

AUTOMATION; COMPUTER AIDED DESIGN; LARGE SCALE SYSTEMS; MAXIMUM LIKELIHOOD ESTIMATION; SOFTWARE PROTOTYPING; TUNING;

RELATIONAL DATABASE SYSTEMS;

EID: 84858485399     PISSN: 10844627     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICDE.2006.133     Document Type: Conference Paper

References (20)

1. S. Agrawal, S. Chaudhuri, et al. Database Tuning Advisor for Microsoft SQL Server. Proc. of the 30th VLDB Conf., Toronto, Canada, 2004.
2. N. Bruno and S. Chaudhuri. Automatic Physical Database Tuning: a Relaxation-based Approach. In ACM SIGMOD Conf., 2005.
3. G. Casella and R. L. Berger. Statistical Interference. Duxbury, 2002.
4. S. Chaudhuri, G. Das, et al. A Robust, Optimization-Based Approach for Aprroximate Answering of Aggregate Queries. In Proc. of ACM SIGMOD Conf., 2001.
5. S. Chaudhuri, A. Gupta, et al. Compressing SQL Workloads. In Proc. of ACM SIGMOD Conf., 2002.
6. S. Chaudhuri, A. C. König, et al. SQLCM: A Continuous Monitoring Framework for Relational Database Engines. In Proc. of 20th ICDE Conf., 2004.
7. S. Chaudhuri and V. R. Narasayya. An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server. In Proc. the 23rd VLDB Conf., Athens, Greece, 1997.
8. S. Chaudhuri and V. R. Narasayya. AutoAdmin "What-If" Index Analysis Utility. In Proc. of ACM SIGMOD Conf., Seattle, WA, USA, 1998.
9. W. G. Cochran. Sampling Techniques. Wiley, 1977.
10. B. Dageville, D. Das, et al. Automatic SQL Tuning in Oracle 10g. In Proc. of the 30th VLDB Conf., 2004.
11. S. Ferson, L. Ginzburg, et al. Computing Variance for Interval Data is NP-Hard. In ACM SIGACT News, Vol. 33, No. 2, pages 108-118, 2002.
12. S. Ferson, L. Ginzburg, et al. Exact Bounds on Finite Populations of Interval Data. Technical Report UTEP-CS-02-13d, University of Texas at El Paso, 2002.
13. S. Finkelstein, M. Schikolnick, et al. Physical Database Design for Relational Databases. In ACM TODS, 13(1), 1988.
14. Y. Ioannidis and S. Christodoulakis. Optimal Histograms for limiting Worst-Case Error Propagation in the Size of Join Results. In ACM TODS, 1993.
15. S.-H. Kim and B. L. Nelson. Selecting the Best System: Theory and Methods. In Proc. of the 2003 Winter Simulation Conf., pages 101-112.
16. V. Kreinovich, S. Ferson, et al. Computing Higher Central Moments for Interval Data. Technical Report UTEP-CS-03-14, University of Texas at El Paso, 2003.
17. N. M. Steiger and J. R. Wilson. Improved Batching for Confidence Interval Construction in Steady-State Simulation. In Proc. of the 1999 Winter Simulation Conf., 2000.
18. M. Stillger, G. Lohman, V. Markl, and M. Kandil. LEO - DB2's Learning Optimizer. In Proc. of the 27th Conference on Very Large Databases, 2001.
19. R. Sugden, T. Smith, et al. Cochran's rule for simple random sampling. In Journal of the Royal Statistical Society, pages 787-793, 2000.
20. D. C. Zilio, J. Rao, et al. DB2 Design Advisor: Integrated Automatic Physical Database Design. Proc. of the 30th VLDB Conf, Canada, 2004.