Database tuning : principles, experiments, and troubleshooting techniques
Author(s)
Bibliographic Information
Database tuning : principles, experiments, and troubleshooting techniques
(The Morgan Kaufmann series in data management systems)
Morgan Kaufmann, c2003
Available at / 5 libraries
-
No Libraries matched.
- Remove all filters.
Note
Includes bibliographical references (p.361-386) and index
Description and Table of Contents
Description
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 skills, combined with the scripts provided for validating results, are exactly what you need to evaluate competing database products and to choose the right one.
Table of Contents
Foreword
Preface
Chapter 1: Basic Principles
Chapter 2: Tuning The Guts
Chapter 3: Index Tuning
Chapter 4: Tuning Relational Systems
Chapter 5: Communicating With The Outside
Chapter 6: Case Studies From Wall Street
Chapter 7: Troubleshooting by Alberto Lerner
Chapter 8: Tuning E-Commerce Applications
Chapter 9: Celko On Data Warehouses: Techniques, Successes, and Mistakes by Joe Celko
Chapter 10: Data Warehouse Tuning
Appendix A: Real-Time Databases
Appendix B: Transaction Chopping
Appendix C: Time Series, Especially For Finance
Appendix D: Understanding Access Plans
Appendix E: Configuration Parameters
Glossary
Index
by "Nielsen BookData"