Physical database design : the database professional's guide to exploiting indexes, views, storage, and more /
I highly recommend Physical Database Design by Lightstone, Teorey, and Nadeau. The book covers fine aspects of physical design -- issues such as the effects of different approaches to indexes, tradeoffs in materializing views, and details of physical data layout. Unlike other books, it does not focu...
Call Number: | Libro Electrónico |
---|---|
Main Author: | |
Other Authors: | , |
Format: | Electronic eBook |
Language: | Inglés |
Published: |
Amsterdam ; Boston :
Morgan Kaufmann/Elsevier,
�2007.
|
Series: | Morgan Kaufmann series in data management systems.
|
Subjects: | |
Online Access: | Texto completo |
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 (i.e. design choices)
- 10: Data sampling in design exploration
- 11: Access plan selection and physical design
- 12: Automated physical database design
- 13: Down to the metal
- 14: Physical design for Decision Support, Warehousing and OLAP
- 15: Denormalization
- 16: Distributed Data Allocation
- Appendix A: A Simple Performance Model for Database.