Year
2020
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 introduces 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
At the completion of this topic, students are 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