CS5226 January-April 2005
CS5226 -- Database Administration and Performance Tuning
Quick Guides to Oracle 9i
Reference Books and Materials
Prof H.V. Jagadish (Email: jaga, Tel: 7365, Office: S14, 06-07)
Prof Ooi Beng Chin (Email: ooibc, Tel: 6465, Office: S16, 09-10)
Two DBAs: Sze Engkoon and Philip Lim
- Lecture time: Tuesday, 2-4pm
- Location: LT34
- Exam: TBA
- Test: TBA
- Consultation hours: Anytime when we are in and free, or by appointment
- Lab Assignments -------------- 25%
- Project ----------------------- 25%
- Final exam (OPEN BOOK) -------- 50%
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
and principles of database tuning.
The second half will look at cases where tuning is required,
the pitfalls and idiosyncrasy of some systems.
- Undergraduate modules (2000/3000/4000) on database management systems
- Database application development
The course has two sections:
database performance tuning
lab sessions on DBMS tuning.
- Since this is a graduate course, it is quite different from your
undergraduate modules. You are assumed with
strong foundation in databases.
- Attending the presentation itself is necessary but not sufficient for
You have to get your hands dirty and learn to install,
maintain and tune a commercial DBMS!
- Week 1: Course Structure, Basic Principles and DBMS components ,
Database design and impact on system performance
- Week 2:
Principles of Transaction Management and tuning
- Week 3:
Indexing and its Principles
- Week 4:
Tuning of Index
- Week 5:
Principles of Query Processing and Query Tuning, and Sorting
- Week 6: Tuning of OS and recovery
- Week 7: Buffer Management and Tuning
- Week 8: Hardware Tuning and Data warehouse and tuning
- Week 9-: lab sessions
- Week ?: Oracle 10g
Lab Session Assignments and Project
Lab sessions: all lab assignments must be done and submitted during
lab sessions using Oracle 9i.
Dennis Shasha and Phillipe Bonnet:
Database Tuning : Principles Experiments and Troubleshooting Techniques.
Morgan Kaufmann Publishers. 2002 (released in June 2002).
NOTE: the Coop has the books now.
Raghu Ramakrishnan and Johannes Gehrke:
Database Management Systems
3rd Edition, McGraw-Hill, 2002.
Database tuning : a principled approach.
Prentice Hall, 1992.
Hector Garcia-Molina, Jeffrey D. Ullman, and
Database Systems -- The Complete Book.
Prentice Hall, 2001.
A. Silberschatz, H. Korth, S. Sudarshan:
Database System Concepts, 4th Edition 2002.
REFERENCE. (NOTE: This book comes with a personal Oracle 8i).
- G. J. Vaidyanatha, K. Deshpande and J. Kostelac:
Oracle Performance Tuning 101.
- Jim Gray (ed): The Benchmark handbook : for database and transaction processing systems.
M. Kaufmann Publishers, 1991.
Under constant modification and construction.