Sitansu S. Mittra Livres

Focusing on database performance tuning and optimization, this book utilizes Oracle 8i as a case study while providing theoretical insights and practical SQL scripts. It caters to both DBAs and developers, allowing those using different RDBMS systems to apply the principles with their own scripts. The text explores the three operational database levels—conceptual, internal, and external—highlighting how data modeling and logical design translate into practical implementation. Each script is tested for accuracy, complete with sample outputs for user reference.

Presents an ideal mix of theory and practice, which allows the reader to understand the principle behind the application.; Coverage of performance tuning of datawarehouses offers readers the principles and tools they need to handle large reporting databases.; Material can also be used in a non-Oracle environment; Highly experienced author.