CSU-Carig
Physical database design : the database professional's guide to exploiting indexes, views, storage, and more / Sam Lightstone, Toby Teorey, Tom Nadeau.
by Lightstone, Sam, author.
Series: The Morgan Kaufmann series in data management systems Published by : Morgan Kaufmann/Elsevier, (San Francisco, CA :) Physical details: 1 online resource, xx, 427 pages : illustrations. ISBN: 9780080552316.| Item type | Location | Collection | Call number | Status | Date due | Barcode |
|---|---|---|---|---|---|---|
Electronic Books
|
E-Resource Section | E-Books | 005.74 (Browse shelf) | Available |
Includes bibliographical references and indexes.
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
First book on how to improve physical database design to achieve performance
There are no comments for this item.