Cart
Free US shipping over $10
Proud to be B-Corp

Database Tuning Dennis Shasha

Database Tuning By Dennis Shasha

Database Tuning by Dennis Shasha


Summary

Helps you develop portable skills that allow you to tune a variety of database systems on a multitude of hardware and operating systems. This work covers the entire system environment: hardware, operating system, transactions, and others. It also describes performance-monitoring techniques that enables you to recognize and troubleshoot problems.

Database Tuning Summary

Database Tuning: Principles, Experiments, and Troubleshooting Techniques by Dennis Shasha

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.

Database Tuning Reviews

For the novice, this book gives sage advice on the performance issues of SQL-level logical database design that cuts across all systems. For me at least, the physical database design was particularly interesting, because the book presents the implications of design choices on IBM, Oracle, and Microsoft systems. These systems are quite different internally, and the book's example will surprise even the systems' implementers.-Jim Gray, Microsoft Shasha and Bonnet prove the value of applying timeless principles to everchanging technology. The unique wealth of practical ideas, facts, and examples equip database practitioners in the trenches like no other resource. Chapter 2 alone is worth the price of the book.-Bob Badour, Online Curmudgeon

About Dennis Shasha

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.

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

Additional information

GOR013528049
9781558607538
1558607536
Database Tuning: Principles, Experiments, and Troubleshooting Techniques by Dennis Shasha
Used - Like New
Paperback
Elsevier Science & Technology
2002-06-07
440
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
The book has been read, but looks new. The book cover has no visible wear, and the dust jacket is included if applicable. No missing or damaged pages, no tears, possible very minimal creasing, no underlining or highlighting of text, and no writing in the margins

Customer Reviews - Database Tuning