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

Mostrar otras versiones (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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Lightstone, Sam
Otros Autores: Teorey, Toby J., Nadeau, Tom, 1958-
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Amsterdam ; Boston : Morgan Kaufmann/Elsevier, ©2007.
Colección:Morgan Kaufmann series in data management systems.
Temas:
Database design.
Bases de données > Conception.
COMPUTERS > Desktop Applications > Databases.
COMPUTERS > Database Management > General.
COMPUTERS > System Administration > Storage & Retrieval.
Database design
Acceso en línea:Texto completo
Tabla de Contenidos:
  • 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.

Ejemplares similares