UID:
almahu_9948026602202882
Format:
1 online resource (441 p.)
Edition:
[Rev. ed.]
ISBN:
1-281-03531-9
,
9786611035310
,
0-08-050378-0
Series Statement:
Morgan Kaufmann series in data management systems
Content:
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. This is an art as well as a science, and Database Tuning: Principles, Experiments, and Troubleshooting Techniques will help you develop portable skills that will allow you to tune a wide variety of database systems on a multitude of hardware and operating systems. Further, these skil
Note:
Includes index.
,
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
,
English
Additional Edition:
ISBN 1-55860-753-6
Language:
English
Bookmarklink