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

Key dates and timetable

(1), (2)

Each class is numbered in brackets.
Where more than one class is offered, students normally attend only one.

Classes are held weekly unless otherwise indicated.

FULL

If you are enrolled for this topic, but all classes for one of the activities (eg tutorials) are full,
contact your College Office for assistance. Full classes frequently occur near the start of semester.

Students may still enrol in topics with full classes as more places will be made available as needed.

If this padlock appears next to an activity name (eg Lecture), then class registration is closed for this activity.

Class registration normally closes at the end of week 2 of each semester.

Classes in a stream are grouped so that the same students attend all classes in that stream.
Registration in the stream will result in registration in all classes.
  Unless otherwise advised, classes are not held during semester breaks or on public holidays.