Holiday book sale: Save up to 30% on print and eBooks. No promo code needed.
Save up to 30% on print and eBooks.
Principles, Experiments, and Troubleshooting Techniques
1st Edition - May 29, 2002
Authors: Dennis Shasha, Philippe Bonnet
9 7 8 - 0 - 0 8 - 0 5 0 3 7 8 - 3
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… Read more
Save 50% on book bundles
Immediately download your ebook while waiting for your print delivery. No promo code is needed.
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.
Forward by Jim Gray, with invited chapters by Joe Celko and Alberto Lerner
Includes industrial contributions by Bill McKenna (RedBrick/Informix), Hany Saleeb (Oracle), Tim Shetler (TimesTen), Judy Smith (Deutsche Bank), and Ron Yorita (IBM)
Covers the entire system environment: hardware, operating system, transactions, indexes, queries, table design, and application analysis
Contains experiments (scripts available on the author's site) to help you verify a system's effectiveness in your own environment
Presents special topics, including data warehousing, Web support, main memory databases, specialized databases, and financial time series
Describes performance-monitoring techniques that will help you recognize and troubleshoot problems
ForewordPreface 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 StreetChapter 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
No. of pages: 440
Published: May 29, 2002
Imprint: Morgan Kaufmann
eBook ISBN: 9780080503783
Dennis Shasha is the author or coauthor of seven books, including this book's predecessor Database Tuning: A principal Approach (Prentice Hall) and Out of Their Minds: The Lives and Discoveries of 15 Great Computer Scientists (Copernius/Springer-Verlag), numerous journal and conference papers, and four patents. He also writes monthly puzzle columns for Scientific American and Dr. Dobb's Journal.
Philippe Bonnet is an experiment database researcher. He directs code development of the open source object-relational database system Predator developed at Cornell.