An automated, yet interactive and portable DB designer

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2010, Pages 1183-1186

  Alagiannis, Ioannis ^a   Dash, Debabrata ^a,b   Schnaitter, Karl ^c   Ailamaki, Anastasia ^a   Polyzotis, Neoklis ^c  

^a EPFL   (Switzerland)

^b CARNEGIE MELLON UNIVERSITY   (United States)

^c UNIVERSITY OF CALIFORNIA   (United States)

Author keywords

continuous tuning; index interaction; physical design tuning

Indexed keywords

APRIORI; AUTOMATED TUNING; COMBINATORIAL OPTIMIZATION PROBLEMS; CONTINUOUS TUNING; DATA SETS; DATABASE ADMINISTRATORS; DESIGN FEATURES; GREEDY HEURISTICS; OFFLINE; OPEN SOURCES; OPTIMAL PERFORMANCE; OPTIMAL SETS; PHYSICAL DESIGN TUNING; PHYSICAL STRUCTURES; POSTGRESQL; REAL-WORLD;

COMBINATORIAL OPTIMIZATION; DESIGN; TUNING;

PROBLEM SOLVING;

EID: 77954711590     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1807167.1807314     Document Type: Conference Paper

References (14)

1. S. Agrawal et al. Database Tuning Advisor for Microsoft SQL Server 2005. In Proceedings of the International Conference on Very Large Databases (VLDB), 2004.
2. N. Bruno and S. Chaudhuri. An Online Approach to Physical Design Tuning. ICDE'07.
3. N. Bruno and Surajit Chaudhuri. Automatic physical database tuning: a relaxation-based approach. In Proceedings of the SIGMOD Conference, 2005.
4. D. Dash, A. Ailamaki. CoPhy: Automated Physical Design with Quality Guarantees. Technical Report CMU-CS-10-109.
5. S. Finkelstein,M. Schkolnick,P. Tiberio: Physical database design for relational databases. ACM ToDS. 1988.
6. Kao, K., Liao, I. 2009. An index selection method without repeated optimizer estimations. Inf. Sci. 179, 13 (Jun. 09)
7. Monteiro, J. M., Lifschitz, S. and Brayner, A.: An Architecture for Automated Index Tuning. In V Ph.D. and M.S. SBBD, 2006.
8. S. Papadomanolakis, A. Ailamaki, AutoPart: Automating Schema Design for Large Scientific Databases Using Data Partitioning, 6th International Conference on Scientific and Statistical Database Management (SSDBM'04), 2004.
9. S. Papadomanolakis, D. Dash, A. Ailamaki. Efficient Use of the Query Optimizer for Automated Physical Design. VLDB 2007.
10. Performance Tuning using the SQLAccess Advisor. http://www.oracle.com/ technology/products/bi/db/10g/pdf/twp-general-perf-tuning-using-sqlaccess- advisor-10gr1-1203.pdf
11. K. Schnaitter, S. Abiteboul, T. Milo, and N. Polyzotis. Colt: continuous on-line tuning. In proceedings of the 2006 ACM SIGMOD, pages 793-795, 2006.
12. K. Schnaitter, N. Polyzotis, L. Getoor: Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications. PVLDB 2(1): 1234-1245 (2009).
13. Sloan Digital Sky Survey, http://www.sdss.org/
14. D. C. Zilio, J. Rao, et al. DB2 Design Advisor: Integrated Automatic Physical Data-base Design. VLDB'04.