
Physical Database Design
The Database Professional's Guide to Exploiting Indexes, Views, Storage, and More
Resources
Description
Key Features
- The first complete treatment on physical database design, written by the authors of the seminal, Database Modeling and Design: Logical Design, Fourth Edition
- Includes an introduction to the major concepts of physical database design as well as detailed examples, using methodologies and tools most popular for relational databases today: Oracle, DB2 (IBM), and SQL Server (Microsoft)
- Focuses on physical database design for exploiting B+tree indexing, clustered indexes, multidimensional clustering (MDC), range partitioning, shared nothing partitioning, shared disk data placement, materialized views, bitmap indexes, automated design tools, and more!
Readership
Table of Contents
- 1 Introduction to Physical Database Design
2 Basic Indexing Methods
3 Query Optimization and Plan Selection
4 Selecting Indexes
5 Selecting Materialized Views
6 Shared-nothing Partitioning
7 Range Partitioning
8 Multidimensional Clustering
9 The Interdependence Problem
10 Counting and Data Sampling in Physical Design Exploration
11 Query Execution Plans and Physical Design
12 Automated Physical Database Design
13 Down to the Metal: Server Resources and Topology
14 Physical Design for Decision Support, Warehousing, and OLAP
15 Denormalization
16 Distributed Data Allocation
Appendix A A Simple Performance Model for Databases
Appendix B Technical Comparison of DB2 HADR with Oracle Data Guard for Database Disaster Recovery
Product details
- No. of pages: 448
- Language: English
- Copyright: © Morgan Kaufmann 2007
- Published: March 21, 2007
- Imprint: Morgan Kaufmann
- eBook ISBN: 9780080552316
About the Authors
Sam Lightstone
Affiliations and Expertise
Toby Teorey
Toby J. Teorey is a professor in the Electrical Engineering and Computer Science Department at the University of Michigan, Ann Arbor. He received his B.S. and M.S. degrees in electrical engineering from the University of Arizona, Tucson, and a Ph.D. in computer sciences from the University of Wisconsin, Madison. He was general chair of the 1981 ACM SIGMOD Conference and program chair for the 1991 Entity-Relationship Conference. Professor Teorey’s current research focuses on database design and data warehousing, OLAP, advanced database systems, and performance of computer networks. He is a member of the ACM and the IEEE Computer Society.