Database Performance Tuning Principles and Techniques

Author: (USA) Sha Sha et al. (Auth.), Meng Xiaofeng et al. (Trans.)
Publisher:
Publish Date: 2004-05-01
Features: Databases are crucial resources in the business field, 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 a broad and in-depth knowledge of fundamental tuning principles, the ability to gather data systematically, and techniques to make the system run faster. This is both an art and a science, and this book will help readers acquire the necessary skills to optimize 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 informed choices. This book can also serve as a textbook for senior undergraduate and graduate students, as well as a valuable reference for researchers and engineering technicians engaged in database research and development.