Database Tuning
Principles, Experiments, and Troubleshooting Techniques
Published on 7. June 2002
Book
Paperback/Softback
440 pages
978-1-55860-753-8 (ISBN)
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.
Reviews / Votes
"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
More details
Series
Language
English
Place of publication
San Francisco
United States
Publishing group
Elsevier Science & Technology
Target group
Professional and scholarly
Database administrators, database programmers and application developers and others who manage databases and data warehouses.
Product notice
Paperback (trade)
Dimensions
Height: 235 mm
Width: 190 mm
Thickness: 28 mm
Weight
742 gr
ISBN-13
978-1-55860-753-8 (9781558607538)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Dennis Shasha | Philippe BONNET
Database Tuning
Principles, Experiments, and Troubleshooting Techniques
E-Book
06/2002
Morgan Kaufmann
€66.95
Available for download
Persons
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.
Content
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
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