Database Performance Tuning: Principles and Techniques: Principles and Techniques

Author: Dennis Shasha
Publisher:
Publish Date: 2004-05-01
Features: Databases are crucial resources in the business sector, web sites, and web services. A simple optimization configuration can significantly reduce database response time and improve data throughput. By utilizing the tuning methods learned from this book, database developers and administrators can enhance the performance of database systems. This is an excellent reference book on database tuning, highly recommended for database administrators. It is equally valuable for experienced database administrators, as well as for database designers and researchers. The performance comparison measurements and performance profiling of products such as Oracle, IBM DB2, and Microsoft SQL Server included in the book are hard to find elsewhere. Database performance optimization is far from being achieved through just a few steps by following the guidelines provided by manufacturers. To achieve the greatest optimization results, one needs extensive and in-depth knowledge of fundamental tuning principles, the ability to systematically gather data, and techniques to make the system run faster. This is both an art and a science, and this book helps readers acquire the skills to achieve the goal of tuning various database systems based on different hardware and operating systems. Moreover, these techniques, supplemented by the experimental results in the book, can help readers accurately evaluate relevant database products and make the right choices. This book can also serve as a textbook for advanced undergraduate and graduate students, as well as a valuable reference for researchers and engineering technicians engaged in database research and development.