Year
2021
Units
4.5
Contact
1 x 120-minute lecture weekly
1 x 50-minute tutorial weekly
1 x 50-minute workshop weekly
1 x 180-minute project work weekly
Prerequisites
1 1 of COMP2761, COMP1711
2 1 of COMP2731, COMP1712
Must Satisfy: (1 and 2)
Enrolment not permitted
1 of COMP8771, COMP9771 has been successfully completed
Topic description

Advanced database techniques and concepts including: advanced normalisation, monitoring and tuning database systems, query optimisation, professional, distributed, object and other advanced DBMSs. Advanced data analysis techniques including data mining, predictive analytics, supervised and unsupervised methods, data visualisation.

Educational aims

This topic aims to introduce students to advanced techniques and concepts of database design and implementation, legal and ethical issues of databases and selected topics in database research.

Expected learning outcomes
On completion of this topic you will be expected to be able to:

  1. Design and develop a complex database for a given scenario, with a professional approach to the documentation of the system
  2. Construct SQL programs using advanced features to ensure efficient processing
  3. Detect and evaluate various key issues which affect database systems and their performance
  4. Compare and contrast approaches for improving a database's performance
  5. Critically review a selection of emerging database technologies