Database Tuning: Principles, Experiments, and Troubleshooting Techniques

Dennis Shasha, Philippe Bonnet

  • 出版商: Morgan Kaufmann
  • 出版日期: 2002-06-12
  • 售價: $3,164
  • 貴賓價: 9.5$3,006
  • 語言: 英文
  • 頁數: 440
  • 裝訂: Paperback
  • ISBN: 1558607536
  • ISBN-13: 9781558607538




  • While most books teach how to tune applications for one specific system, the goal of this book is to help database tuners gain that broad knowledge. With this information the reader will:
  • Learn how to tune an application on his database management system, operating system, and hardware
  • Be given performance criteria for choosing a DBMS, including a set of experimental data and scripts that may help in testing particular aspects of systems under consideration
  • Learn the principles underlying any tuning puzzle as design patterns.


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