Physical database design : the database professional's guide to exploiting indexes, views, storage, and more /

Afficher d'autres versions (3)

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

Description complète

Détails bibliographiques
Cote:Libro Electrónico
Auteur principal: Lightstone, Sam
Autres auteurs: Teorey, Toby J., Nadeau, Tom, 1958-
Format: Électronique eBook
Langue:Inglés
Publié: Amsterdam ; Boston : Morgan Kaufmann/Elsevier, ©2007.
Collection:Morgan Kaufmann series in data management systems.
Sujets:
Database design.
Bases de données > Conception.
COMPUTERS > Desktop Applications > Databases.
COMPUTERS > Database Management > General.
COMPUTERS > System Administration > Storage & Retrieval.
Database design
Accès en ligne:Texto completo
Table des matières:
  • 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.

Documents similaires