Cargando…

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

First book on how to improve physical database design to achieve performance.

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: San Francisco, CA : Morgan Kaufmann/Elsevier, ©2007.
Colección:Morgan Kaufmann series in data management systems.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover Page; Physical Database Design; Copyright Page; Contents; Preface; Chapter 1. Introduction to Physical Database Design; Chapter 2. Basic Indexing Methods; Chapter 3. Query Optimization and Plan Selection; Chapter 4. Selecting Indexes; Chapter 5. Selecting Materialized Views; Chapter 6. Shared-nothing Partitioning; Chapter 7. Range Partitioning; Chapter 8. Multidimensional Clustering; Chapter 9. The Interdependence Problem; Chapter 10. Counting and Data Sampling in Physical Design Exploration; Chapter 11. Query Execution Plans and Physical Design.
  • Chapter 12. Automated Physical Database DesignChapter 13. Down to the Metal: Server Resources and Topology; Chapter 14. Physical Design for Decision Support, Warehousing, and OLAP; Chapter 15. Denormalization; Chapter 16. Distributed Data Allocation; Appendix A. Simple A Performance Model for Databases; Appendix B. Technical Comparison of DB2 HADR with Oracle Data Guard for Database Disaster Recovery; Glossary; Bibliography; Index; About the Authors.