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.
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Otros Autores: | , |
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.