Loading…

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...

Full description

Bibliographic Details
Call Number:Libro Electrónico
Main Author: Lightstone, Sam
Other Authors: Teorey, Toby J., Nadeau, Tom, 1958-
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.