Database tuning principles, experiments, and troubleshooting techniques
Tuning your database for optimal performance means more than following a few short steps in a vendor-specific guide. For maximum improvement, you need a broad and deep knowledge of basic tuning principles, the ability to gather data in a systematic way, and the skill to make your system run faster....
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
San Francisco, CA :
Morgan Kaufmann Publishers
c2003.
|
| Edición: | [Rev. ed.] |
| Colección: | Morgan Kaufmann series in data management systems.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627697206719 |
Tabla de Contenidos:
- Front Cover; Database Tuning: Principles, Experiments, and Troubleshooting Techniques; Copyright Page; Contents; Foreword; Preface; CHAPTER 1. BASIC PRINCIPLES; 1.1 The Power of Principles; 1.2 Five Basic Principles; 1.3 Basic Principles and Knowledge; CHAPTER 2. TUNING THE GUTS; 2.1 Goal of Chapter; 2.2 Locking and Concurrency Control; 2.3 Logging and the Recovery Subsystem; 2.4 Operating System Considerations; 2.5 Hardware Tuning; Bibliography; Exercises; CHAPTER 3. INDEX TUNING; 3.1 Goal of Chapter; 3.2 Types of Queries; 3.3 Key Types; 3.4 Data Structures; 3.5 Sparse Versus Dense Indexes
- 3.6 To Cluster or Not to Cluster3.7 Joins, Foreign Key Constraints, and Indexes; 3.8 Avoid Indexes on Small Tables; 3.9 Summary: Table Organization and Index Selection; 3.10 Distributing the Indexes of a Hot Table; 3.11 General Care and Feeding of Indexes; Bibliography; Exercises; CHAPTER 4. TUNING RELATIONAL SYSTEMS; 4.1 Goal of Chapter; 4.2 Table Schema and Normalization; 4.3 Clustering Two Tables; 4.4 Aggregate Maintenance; 4.5 Record Layout; 4.6 Query Tuning; 4.7 Triggers; Bibliography; Exercises; CHAPTER 5. COMMUNICATING WITH THE OUTSIDE; 5.1 Talking to the World
- 5.2 Client-Server Mechanisms5.3 Objects, Application Tools, and Performance; 5.4 Tuning the Application Interface; 5.5 Bulk Loading Data; 5.6 Accessing Multiple Databases; Bibliography; CHAPTER 6. CASE STUDIES FROM WALL STREET; 6.1 Techniques for Circumventing Superlinearity; 6.2 Perform Data Integrity Checks at Input Time; 6.3 Distribution and Heterogeneity; 6.4 Trading Space for Time in History-Dependent Queries; 6.5 Chopping to Facilitate Global Trades; 6.6 Clustering Index Woes; 6.7 Beware the Optimization; 6.8 Disaster Planning and Performance; 6.9 Keeping Nearly Fixed Data Up to Date
- 6.10 Deletions and Foreign Keys6.11 Partitioning Woes: The Hazards of Meaningful Keys; 6.12 The Problem of Time; Bibliography; Exercises; CHAPTER 7. TROUBLESHOOTING; 7.1 Introduction; 7.2 How to Gather Information: The Tools; 7.3 Queries from Hell; 7.4 Are DBMS Subsystems Working Satisfactorily?; 7.5 Is the DBMS Getting All It Needs?; 7.6 Conclusion; Bibliography; CHAPTER 8. TUNING E-COMMERCE APPLICATIONS; 8.1 Goal; 8.2 E-commerce Architecture; 8.3 Tuning the E-commerce Architecture; 8.4 Case Study: Shop Comparison Portal; 8.5 Capacity Planning in a Nutshell; Bibliography; Exercises
- CHAPTER 9. CELKO ON DATA WAREHOUSES: TECHNIQUES, SUCCESSES, AND MISTAKES9.1 Early History; 9.2 Forget What the Elders Taught You; 9.3 Building a Warehouse Is Hard; 9.4 The Effect on the Bottom Line; CHAPTER 10. DATA WAREHOUSE TUNING; 10.1 What's Different About Data Warehouses; 10.2 Tuning for Customer Relationship Management Systems; 10.3 Federated Data Warehouse Tuning; 10.4 Product Selection; Bibliography; Exercises; APPENDIX A. REAL-TIME DATABASES; A.1 Overview; A.2 Replicated State Machine Approach; APPENDIX B. TRANSACTION CHOPPING; B.1 Assumptions; B.2 Correct Choppings
- B.3 Finding the Finest Chopping
