CS5226DatabaseAdministrationandPerformanceTuning.pptVIP

CS 5226: Database Administration and Performance Tuning Course Structure Continuous Assessment: 50% Assignments: 25% Lab Sessions: 25% Lecturers: Prof. Ooi Beng Chin (ooibc) DBAs: Sze Eng Koon and Phillip Lim Text/Reference Books: Dennis Shasha and Phillipe Bonnet: Database Tuning : Principles Experiments and Troubleshooting Techniques. Morgan Kaufmann Publishers. 2002 (released in June 2002). TEXT. Dennis Shasha: Database tuning : a principled approach. Prentice Hall, 1992. REFERENCE (a good reference if cannot get the text book) Database Management Systems, 3rd edition. Raghu Ramakrishnan Johannes Gehrke, McGraw-Hill, 2002. Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom: Database Systems -- The Complete Book. Prentice Hall, 2001. G. J. Vaidyanatha, K. Deshpande and J. Kostelac: Oracle Performance Tuning 101. Osborne/Mc-Graw-Hill. 2001. REFERENCE. Jim Gray (ed): The Benchmark handbook : for database and transaction processing systems. M. Kaufmann Publishers, 1991. REFERENCE. Copyright:Many slides belong to the tutorial:Database TuningPrinciples, Experiments and Troubleshooting TechniquesDennis Shasha (shasha@cs.nyu.edu)Philippe Bonnet (bonnet@diku.dk)And lecture notes provided byDatabase Management Systems, 3rd edition. Raghu Ramakrishnan Johannes Gehrke McGraw-Hill, 2002.and some from the web … Database Tuning Database Tuning is the activity of making a database application run more quickly. “More quickly” usually means higher throughput, though it may mean lower response time for time-critical applications. Goals of the Course Appreciation of DBMS architecture Study the effect of various components on the performance of the systems Tuning principles Troubleshooting techniques for chasing down performance problems Hands-on experience in Tuning Contents Basic Principles Tuning the guts Indexes Relational Systems Application Interface E-commerce Applications Data warehouse Applications Distributed Applications Troubleshooting