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.
Related graduate capabilities and elements:
Critical Thinking
Quantitative Literacy/ Numeracy
Inquiry/ Research
Discipline-specific GCs
Creative Problem-solving

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.
Related graduate capabilities and elements:
Quantitative Literacy/ Numeracy
Discipline-specific GCs
Creative Problem-solving

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.
Related graduate capabilities and elements:
Critical Thinking
Creative Problem-solving
Discipline-specific GCs

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.
Related graduate capabilities and elements:
Creative Problem-solving
Inquiry/ Research
Critical Thinking
Discipline-specific GCs

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
Related graduate capabilities and elements:
Inquiry/ Research
Discipline-specific GCs
Critical Thinking

Subject options

Select to view your study options…

Start date between: and    Key dates

Melbourne, 2018, Semester 2, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorEric Pardede

Class requirements

Laboratory Class Week: 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.

Lecture Week: 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 elementComments% 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 Test10 01, 02, 03