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
  Aomori
  Iwate
  Miyagi
  Akita
  Yamagata
  Fukushima
  Ibaraki
  Tochigi
  Gunma
  Saitama
  Chiba
  Tokyo
  Kanagawa
  Niigata
  Toyama
  Ishikawa
  Fukui
  Yamanashi
  Nagano
  Gifu
  Shizuoka
  Aichi
  Mie
  Shiga
  Kyoto
  Osaka
  Hyogo
  Nara
  Wakayama
  Tottori
  Shimane
  Okayama
  Hiroshima
  Yamaguchi
  Tokushima
  Kagawa
  Ehime
  Kochi
  Fukuoka
  Saga
  Nagasaki
  Kumamoto
  Oita
  Miyazaki
  Kagoshima
  Okinawa
  Korea
  China
  Thailand
  United Kingdom
  Germany
  Switzerland
  France
  Belgium
  Netherlands
  Sweden
  Norway
  United States of America
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"