CS5226 January-April 2005

CS5226 -- Database Administration and Performance Tuning

Course Objectives
Important Notes
Course Structure
Quick Guides to Oracle 9i
Reference Books and Materials



Course and Objectives

The course requires students to have advanced relational database knowledge such as database design, normalization, query processing, concurrency control etc.. It is a hands-on course which requires students to tune a commercial database system during classes (no discussion is allowed during tuning). The number of students will be capped at 60. The 1st half of the course will cover the basic principles in database system development, core techniques used in some commercial database systems, and principles of database tuning. The second half will look at cases where tuning is required, the pitfalls and idiosyncrasy of some systems.


  1. Undergraduate modules (2000/3000/4000) on database management systems
  2. Database application development

Important Notes

Course Structure

The course has two sections: lectures on principles of database performance tuning and lab sessions on DBMS tuning.
  • Lecture: Tentative

    Quick Guides to Oracle
    1. Jump Start to SQL

    Lab Session Assignments and Project

      Lab sessions: all lab assignments must be done and submitted during lab sessions using Oracle 9i.

    Text, Reference Books, Materials, and Sites

    1. Dennis Shasha and Phillipe Bonnet: Database Tuning : Principles Experiments and Troubleshooting Techniques. Morgan Kaufmann Publishers. 2002 (released in June 2002). TEXT. NOTE: the Coop has the books now.
    2. Raghu Ramakrishnan and Johannes Gehrke: Database Management Systems 3rd Edition, McGraw-Hill, 2002.
    3. Dennis Shasha: Database tuning : a principled approach. Prentice Hall, 1992. REFERENCE.
    4. Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom: Database Systems -- The Complete Book. Prentice Hall, 2001.
    5. A. Silberschatz, H. Korth, S. Sudarshan: Database System Concepts, 4th Edition 2002. REFERENCE. (NOTE: This book comes with a personal Oracle 8i).
    6. G. J. Vaidyanatha, K. Deshpande and J. Kostelac: Oracle Performance Tuning 101. Osborne/Mc-Graw-Hill. 2001. REFERENCE.
    7. Jim Gray (ed): The Benchmark handbook : for database and transaction processing systems. M. Kaufmann Publishers, 1991. REFERENCE.

      Under constant modification and construction.

      If you have any questions, just drop me a note.