Subject Descriptions - Subject Information

Calendar: 2017 Postgraduate
Faculty: Faculty of Engineering and Information Sciences
Department: School of Computing and Information Technology

Subject Information
Subject Code MCS9317
Subject Name Database Performance Tuning
Credit Points 6
Pre-Requisites MCS9235
Co-Requisites None.
Restrictions None.
Equivalence None.
Assessment Assignments 20% Tests 20% Final examination 60%
General Subject No.
EFTSL (Non Weighted) 0.125
Non Weighted Student Contribution Amounts
Commonwealth Supported (HECS) Students Only
Pre-1997 Pre-2005 Post-2005 Post-2008 Post-2009 Post-2010
$ 1131  $ 1131  $ 1131  $ 1131  $ 1131  $ 1131 
Weighted Student Contribution Amounts  
Work Experience No
Tutorial Enrolment Information Students should use the SMP OnLine Tutorial System (via SOLS) to enrol in Tutorial/laboratory groups for this subject. Once enrolments are open a link to the subject will appear in Tutorial Enrolments.
Availability Not Available in 2017

Subject Description
The subject addresses the performance problems of relational database systems. In particular, it presents optimisation of query processing in relational database systems, performance tuning of database applications, transaction processing in database systems, optimisation of transaction processing, performance tuning of relational database servers, performance tuning of three tier database applications. Laboratory classes demonstrate the techniques used for elimination of performance problems in database systems. Oracle 9i database management system is used for demonstration purposes and all practical work in the subject.

Subject Learning Outcomes
On successful completion of this subject, students will be able to:
1. Explain the principles of query processing and optimisation of query processing in relational database systems
2. Evaluate and improve performance of database applications
3. Explain the principles of transaction processing in database systems
4. Improve performance of transaction processing
5. Explain the principles of benchmarking in relational database management systems
6. Evaluate and tune performance of relational database servers

Extra Information
Generic Extra Information:
Assumed knowledge:Relational database model, SQL,Embedded SQL, JDBC,the basics of PL/SQL

Textbook Information
The chapters 4, 12,13, 14, 18, 19, 20 from R. Ramakrishnan, J. Gehrke "Database Management Systems" as a customized textbook, + 2 chapters from D. Sasha, E. Bonnet Database Performance Tuning in electronic readings collection
Text book information is available via the UniShop website:

Search Criteria [Click here for help]
Subject Code / Name
Delivery Method
General Subjects