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 Admission into MIT-Master of Information Technology
2 36 units of topics
3 Admission into MSCCS-Master of Science (Computer Science)
Must Satisfy: ((1 and 2) or (3))
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 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 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