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 Admission into MIT-Master of Information Technology
2 36 units of topics
3 Admission into MSCCS-Master of Science (Computer Science)
3a Admission into GDPCSC-Graduate Diploma in Computer Science
3b Admission into MCS-Master of Computer Science
3c Admission into MCSAI-Master of Computer Science (Artificial Intelligence)
3d Admission into MDSC-Master of Data Science
Must Satisfy: ((1 and 2) or ((3 or 3a or 3b or 3c or 3d)))
Enrolment not permitted
1 of COMP3771, COMP8771 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. Current topics in database and data analytics research.

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 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. Survey and evaluate a selection of emerging database technologies