Automated Physical Database Design - Physical Database Design - page 262

12.12 Summary
Utilities for automated physical database design are based on advanced technology with
considerable sophistication. Even so, these technologies are maturing, and for the
moment, most recommendations from these utilities should be reviewed before being
directly applied to a system. If you are the Gary Kasparov of physical database design
chances are you don't need to use these advisors. However, if you're mortal then you
may just find these tools have something to offer because of their ability to evaluate
thousands of alternatives and complex combinations that human designers will not.
Even for the experienced database designers these utilities have been found to be useful,
particularly as a starting point for new ideas.
12.13 Literature Summary
Agrawal, S., Chaudhuri, S., Kollar, L., and Narasayya, V. Index Tuning Wizard for
Microsoft SQL Server 2000, white paper, at http://msdn.microsoft.com/library/
techart/itwforsql.htm.
Agrawal, S., Chaudhuri, S., and Narasayya, V. Automated Selection of Materialized
Views and Indexes for SQL Databases. Proceedings of VLDB , 2000: 496-505.
Agrawal, S., Narasayya, V., and Yang, B. Integrating Vertical and Horizontal Partition-
ing into Automated Physical Database Design. Proceedings of ACM SIGMOD , 2004.
Agrawal, S., Chaudhuri, S., Kollár, L., Marathe, A., Narasayya, V., Syamala, M.: Data-
base Tuning Advisor for Microsoft SQL Server 2005. VLDB 2004 , Toronto, Canada,
pp: 1110-1121
BMC Index Advisor, at http://www.bmc.com.
Bruno, N., and Chaudhuri, S. Automatic Physical Design Tuning: A Relaxation-based
Approach. Proceedings of the ACM SIGMOD , Baltimore, MD, 2005.
Bruno, N., and Chaudhuri, S. Physical Design Refinement. The Merge-Reduce
Approach. Proceedings of EDBT Conference , 2006.
Chaudhuri, S., Gupta, A., and Narasayya, V. Workload Compression. Proceedings of
ACM SIGMOD , 2002.
Chaudhuri, S., Dageville, B., and Lohman, G. M. Self-managing Technology in Data-
base Management Systems. VLDB , 2004: 1243.
Chaudhuri, S., and Narasayya, V. An Efficient Cost-driven Index Selection Tool for
Microsoft SQL Server. VLDB , 1997: 146-155.