Physical design refinement: The "merge-reduce" approach

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

Volumn 3896 LNCS, Issue , 2006, Pages 386-404

  Bruno, Nicolas ^a   Chaudhuri, Surajit ^a  

^a MICROSOFT RESEARCH   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

AUTOMATION; COMPUTER ARCHITECTURE; DATA ACQUISITION; DATA REDUCTION; KNOWLEDGE ACQUISITION; MATHEMATICAL TRANSFORMATIONS; PROBLEM SOLVING;

DATABASE DESIGN TOOL; PHYSICAL DESIGN REFINEMENT; PRIMITIVE OPERATION; TRANSFORMATIONAL ARCHITECTURE; WORKLOAD;

DATABASE SYSTEMS;

EID: 33745603444     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/11687238_25     Document Type: Conference Paper

References (12)

1. S. Agrawal, S. Chaudhuri, L. Kollar, A. Marathe, V. Narasayya, and M. Syamala. Database Tuning Advisor for Microsoft SQL Server 2005. In Proceedings of the 30th International Conference on Very Large Databases (VLDB), 2004.
2. S. Agrawal, S. Chaudhuri, and V. Narasayya. Automated selection of materialized views and indexes in SQL databases. In Proceedings of the International Conference on Very Large Databases (VLDB), 2000.
3. G. Brassard and P. Bratley. Fundamental of Algorithmes. Prentice Hall, 1996.
4. N. Bruno and S. Chaudhuri. Automatic physical database tuning: A relaxation-based approach. In Proceedings of the ACM International Conference on Management of Data (SIGMOD), 05.
5. S. Chaudhuri and V. Narasayya. An efficient cost-driven index selection tool for Microsoft SQL Server. In Proceedings of the 23rd International Conference on Very Large Databases (VLDB), 1997.
6. S. Chaudhuri and V. Narasayya. Index merging. In Proceedings of the International Conference on Data Engineering (ICDE), 1999.
7. B. Dageville, D. Das, K. Dias, K. Yagoub, M. Zait, and M. Ziauddin. Automatic SQL Tuning in Oracle 10g. In Proceedings of the 30th International Conference on Very Large Databases (VLDB), 2004.
8. J. Goldstein and P.-A. Larson. Optimizing queries using materialized views: A practical, scalable solution. In Proceedings of the ACM International Conference on Management of Data (SIGMOD), 2001.
9. TPC Benchmark H. Decision support. Available at http://www.tpc.org.
10. G. Valentin, M. Zuliani, D. Zilio, G. Lohman, and A. Skelley. DB2 advisor: An optimizer smart enough to recommend its own indexes. In Proceedings of the International Conference on Data Engineering (ICDE), 2000.
11. D. Zilio et al. DB2 design advisor: Integrated automatic physical database design. In Proceedings of the 30th International Conference on Very Large Databases (VLDB), 2004.
12. D. Zilio, C. Zuzarte, S. Lightstone, W. Ma, G. Lohman, R. Cochrane, H. Pirahesh, L. Colby, J. Gryz, E. Alton, D. Liang, and G. Valentin. Recommending materialized views and indexes with IBM DB2 design advisor. In International Conference on Autonomic Computing, 2004.