COT4430

Database design and administration

Lecturer to be advised

6 points
* 4 hours per week
* Second semester
* Caulfield
* Prerequisites: COT4230

Objectives By completing this subject, students develop an understanding of physical database design and maintenance.

Synopsis Embedded SQL, performance monitoring and modelling, system tuning and optimisation for single-site and networked systems, CASE tools for physical design, schema generators, concurrency and locking, restart and recovery methods, system security.

Assessment Examination (2 hours): 50%
* Practical work: 50%

Recommended texts

Chandy K M and Yeh R T (eds) Current trends in programming methodology vol. 3, Software modelling Prentice-Hall, 1978
Sauer C H and Chandy K M Computer systems performance modelling Prentice-Hall, 1981