cse5adb advanced databases
ADVANCED DATABASES
CSE5ADB
2018
Credit points: 15
Subject outline
Introduction of this subject is motivated by the following three facts: The first fact is that data volume is increasingly larger and the information requirements have become very complex that it is difficult to derive all necessary information from the data structures typically found in a relational database system. Thus, a new data storage facility called Data Warehouse is introduced. The ways to query and analyse a Data Warehouse, known as OLAP queries, will also be introduced. The second fact is that Object-Oriented Conceptual modelling is becoming popular in software design, particularly for database modelling. This has stimulated the emergence of the new era of Object-Relational Databases and Data Warehouses, which will be the second topic area in this subject. The third fact is the need for the integration of web, databases, and data warehouse technologies which motivates the third topic area in Web and XML databases.
SchoolSchool Engineering&Mathematical Sciences
Credit points15
Subject Co-ordinatorEric Pardede
Available to Study Abroad StudentsYes
Subject year levelYear Level 5 - Masters
Exchange StudentsYes
Subject particulars
Subject rules
Prerequisites CSE2DBF or CSE4DBF
Co-requisitesN/A
Incompatible subjects CSE4ADB
Equivalent subjectsN/A
Special conditionsN/A
Graduate capabilities & intended learning outcomes
01. Apply multi-dimensional modelling technique to build a data warehouse.
- Activities:
- Lecture 1 and Lecture 2 cover Data Warehouse Model and Design Techniques. In Lab 1 and 2, a large data set is provided to students, and based on the design techniques that have been covered in the lectures, they need to build a Data Warehouse.
02. Implement data warehouse analysis query (OLAP - On Line Analytical Processing).
- Activities:
- Lecture 3 and Lecture 4 cover OLAP queries and Advanced concepts for business intelligence data analysis. In Lab 3 and 4, students are required to implement OLAP queries for the Data Warehouse that they have built in the previous labs.
03. Apply Object-Relational database design and queries.
- Activities:
- Lecture 5 and Lecture 6 cover Object-Relational new data structures and the ways to query them. In Lab 5 and 6, students are required to implement a given Object-Oriented model using Object-Relational database design techniques. They also need to be able to query the database system.
04. Implement an integrated Object-Relational Data Warehouse
- Activities:
- Lecture 7 requires students to combine their data warehouse modelling skill (Lecture 1 and 2) with their Object-Relational design techniques to build a new Object Relational Data Warehouse. In Lab 7, students are required to transfer their original Data Warehouse from Labs 1 and 2 into an Object-Relational Data Warehouse.
05. Implement and evaluate web database application and XML queries.
- Activities:
- Lecture 8 and 9 cover they ways to deploy database applications to a web -based XML database system, and the techniques to query them using XPath and XQuery. In Lab 8 and 9, students will learn the ways to create and populate XML databases, as well as the XML query language XPath and XQuery
Subject options
Select to view your study options…
Melbourne, 2018, Semester 2, Day
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorEric Pardede
Class requirements
Laboratory ClassWeek: 32 - 43
One 2.0 hours laboratory class per week on weekdays during the day from week 32 to week 43 and delivered via face-to-face.
LectureWeek: 31 - 43
One 2.0 hours lecture per week on weekdays during the day from week 31 to week 43 and delivered via face-to-face.
Assessments
Assessment element | Comments | % | ILO* |
---|---|---|---|
Assignment (approx 1500 words) | 30 | 01, 02, 04 | |
Examination (3 hours) | Hurdle requirement: To pass the subject, a pass in the examination is mandatory. | 60 | 01, 02, 03, 04, 05 |
One 1-hour Mid-Semester Test | 10 | 01, 02, 03 |