Automated Physical Database Design and Tuning

by Nicolas Bruno

Overview

Due to the increasing complexity in application workloads and query engines, database administrators are turning to automated tuning tools that systematically explore the space of physical design alternatives. A critical element of such tuning is physical database design since the choice of physical structures has a significant impact on the perfor

Product Details

ISBN-13:	9781040068977
Publisher:	CRC Press
Publication date:	02/07/2011
Series:	Emerging Directions in Database Systems and Applications
Sold by:	Barnes & Noble
Format:	eBook
Pages:	253
File size:	3 MB

About the Author

Nicolas Bruno is a researcher in the Data Management, Exploration and Mining group at Microsoft Research. He earned his Ph.D. in computer science from Columbia University. Dr. Bruno's research interests include physical database design, query processing and optimization, and database testing.

Table of Contents

BACKGROUND: Declarative Query Processing in Relational Database Systems. Query Optimization in Relational Database Systems. Physical Database Design. AUTOMATED PHYSICAL DATABASE DESIGN: Characterizing the Search Space. Designing a Cost Model. Enumerating the Search Space. Practical Aspects in Physical Database Design. ADVANCED TOPICS: Handling Materialized Views. Incorporating Other Physical Structures. Continuous Physical Database Design. Constrained Physical Database Design. New Challenges in Physical Database Design. Index.