Handbook home
Advanced Database Systems (COMP90050)
Graduate courseworkPoints: 12.5On Campus (Parkville)
For information about the University’s phased return to campus and in-person activity in Winter and Semester 2, please refer to the on-campus subjects page.
About this subject
- Overview
- Eligibility and requirements
- Assessment
- Dates and times
- Further information
- Timetable(opens in new window)
Contact information
Semester 1
Hairuo Xie
Winter Term
Farhana Choudhury
Please refer to the LMS for up-to-date subject information, including assessment and participation requirements, for subjects being offered in 2020.
Overview
Availability | Semester 1 Winter Term |
---|---|
Fees | Look up fees |
AIMS
Many applications require access to very large amounts of data. These applications often require reliability (data must not be lost even in the presence of hardware failures), and the ability to retrieve and process the data very efficiently.
The subject will cover the technologies used in advanced database systems. Topics covered will include: transactions, including concurrency, reliability (the ACID properties) and performance; and indexing of both structured and unstructured data. The subject will also cover additional topics such as: uncertain data; Xquery; the Semantic Web and the Resource Description Framework; dataspaces and data provenance; datacentres; and data archiving.
INDICATIVE CONTENT
Topics include:
- Introduction to High Performance Database Systems
- Issues of Performance and Reliability
- Transaction Processing
- Recovery from Failures
- Map Reduce Models.
Intended learning outcomes
On completion of this subject the student is expected to:
- Understand issues related performance and reliability in building applications involving large-scale database systems
- Understand Database Technologies used in large-scale applications such as Google search Engines
- Understand the concepts and technologies underpinning new forms of Web data
- Deep knowledge of transaction processing and recovery from failures and concepts employed in modern database systems
Generic skills
On completion of the subject the student should have the following skills:
- Ability to undertake problem identification, formulation, and solution
- Ability to utilise a systems approach to complex problems and to design and operational performance
- Ability to manage information and documentation
- Capacity for creativity and innovation
- Ability to communicate effectively, with the engineering team and with the community at large.
Last updated: 3 November 2022
Eligibility and requirements
Prerequisites
One of the following:
Code | Name | Teaching period | Credit Points |
---|---|---|---|
INFO20003 | Database Systems |
Semester 2 (On Campus - Parkville)
Semester 1 (On Campus - Parkville)
|
12.5 |
INFO90002 | Database Systems & Information Modelling |
Semester 1 (On Campus - Parkville)
Semester 2 (On Campus - Parkville)
Summer Term (On Campus - Parkville)
|
12.5 |
OR completion of 50 points of third year computing study or equivalent
OR admission into one of the following courses:
- MC-IT Master of Information Technology, 100 or 150 point program in Distributed Computing or Artificial Intelligence
- MC-IT Master of Information Technology, 100 point program in Computing
- MC-CS Master of Computer Science
- MC-SCICMP - Master of Science (Computer Science)
Corequisites
None
Non-allowed subjects
None
Inherent requirements (core participation requirements)
The University of Melbourne is committed to providing students with reasonable adjustments to assessment and participation under the Disability Standards for Education (2005), and the Assessment and Results Policy (MPF1326). Students are expected to meet the core participation requirements for their course. These can be viewed under Entry and Participation Requirements for the course outlines in the Handbook.
Further details on how to seek academic adjustments can be found on the Student Equity and Disability Support website: http://services.unimelb.edu.au/student-equity/home
Last updated: 3 November 2022
Assessment
Due to the impact of COVID-19, assessment may differ from that published in the Handbook. Students are reminded to check the subject assessment requirements published in the subject outline on the LMS
Description | Timing | Percentage |
---|---|---|
One written assignment, due in approximately week 12, of approximately 3500 words long, requiring approximately 50 - 55 hours of work per student. The assignment is an extensive survey of a research topic related to database technologies and requires an oral presentation to the class. The assignment is designed to address Intended Learning Outcomes (ILOs) 1-4 and all General skills
| Week 12 | 40% |
A written examination. This test assesses all topics covered in the subject.
| End of semester | 60% |
Last updated: 3 November 2022
Dates & times
- Semester 1
Principal coordinator Hairuo Xie Mode of delivery On Campus (Parkville) Contact hours 36 hours, made up of 24 one-hour lectures (two per week) and 12 one-hour workshops (one per week) Total time commitment 200 hours Teaching period 2 March 2020 to 7 June 2020 Last self-enrol date 13 March 2020 Census date 30 April 2020 Last date to withdraw without fail 5 June 2020 Assessment period ends 3 July 2020 Semester 1 contact information
Hairuo Xie
- Winter Term
Coordinator Farhana Choudhury Mode of delivery On Campus (Parkville) Contact hours Total time commitment 200 hours Teaching period 6 July 2020 to 2 August 2020 Last self-enrol date 10 July 2020 Census date 17 July 2020 Last date to withdraw without fail 31 July 2020 Assessment period ends 14 August 2020 Winter Term contact information
Farhana Choudhury
Time commitment details
200 hours.
Last updated: 3 November 2022
Further information
- Texts
Prescribed texts
There are no specifically prescribed or recommended texts for this subject.
- Subject notes
LEARNING AND TEACHING METHODS
This course is taught over 12 weeks, each week with two one hour formal lectures and a one hour workshop. During the workshops the students are given problems to solve to reinforce the previous week’s lecturing material. The problem solving nature of the workshops is geared for the students to learn and understand the concepts of the subject material.
INDICATIVE KEY LEARNING RESOURCES
Transaction Processing: Concepts and Techniques (The Morgan Kaufmann Series in Data Management Systems) by Jim Gray and Andreas Reuter
Lecture slides
Addition published articles in Journals and Conferences
CAREERS / INDUSTRY LINKS
The concepts developed in the subject are relevant to many fields including IT, Engineering, Commerce, Government Organizations, Research Institutes and Institutions in Medicine where large scale database are used. Many industries are moving their applications to Cloud Platforms and understanding performance issues will be key to success to such transformations.
- Related Handbook entries
This subject contributes to the following:
Type Name Course Master of Science (Computer Science) Course Master of Data Science Course Doctor of Philosophy - Engineering Course Ph.D.- Engineering Course Master of Philosophy - Engineering Specialisation (formal) Spatial Specialisation (formal) Computing Specialisation (formal) Distributed Computing Specialisation (formal) Software - Available through the Community Access Program
About the Community Access Program (CAP)
This subject is available through the Community Access Program (also called Single Subject Studies) which allows you to enrol in single subjects offered by the University of Melbourne, without the commitment required to complete a whole degree.
Entry requirements including prerequisites may apply. Please refer to the CAP applications page for further information.
Additional information for this subject
Subject coordinator approval required
- Available to Study Abroad and/or Study Exchange Students
This subject is available to students studying at the University from eligible overseas institutions on exchange and study abroad. Students are required to satisfy any listed requirements, such as pre- and co-requisites, for enrolment in the subject.
Last updated: 3 November 2022