ADVANCED DATABASES

CSE5ADB

2020

Credit points: 15

Subject outline


This subject responds to three contemporary issues: data volume is increasing and information requirements have become very complex; Object-Oriented Conceptual modelling is increasingly popular in software design, particularly for database modelling; and integration of web, databases and data warehouse technologies is needed. You will learn advanced database skills to address these issues,including Object-Relational Databases, Data Warehouse analysis and the integration of Data Warehouse with business intelligence tools.



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. Design and construct a complex Data Warehouse using multi-dimensional modelling technique.

Activities:
In lectures students will be introduced to Data Warehouse Model and Design Techniques. In labs, 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. Write advanced analytical queries for Data Warehouse using OLAP (On Line Analytical Processing)

Activities:
In lectures students will learn OLAP queries and Advanced concepts for business intelligence data analysis. In labs, students are required to implement OLAP queries for the Data Warehouse that they have built in the previous labs.

03. Design Object-Relational Databases and construct queries on Object-Relational Databases.

Activities:
In lectures, students will learn Object-Relational new data structures and the ways to query them. In labs, 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. Incorporate object-relational concepts for advanced Data Warehouse design.

Activities:
In lectures, students will combine their data warehouse modelling skill with their Object- Relational design techniques to build a new Object Relational Data Warehouse. In labs, students are required to transfer their original Data Warehouse from previous labs into an Object- Relational Data Warehouse.

05. Integrate Data Warehouse and business intelligence tools and use it for analytical purpose.

Activities:
In lectures, students learn business intelligence data visualization techniques. In labs, students deploy data warehouse to business intelligence applications , and apply various techniques to visualize results for decision making.

Subject options

Select to view your study options…

Start date between: and    Key dates

Melbourne, 2020, 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*
Data warehouse design, development and deployment to business intelligence a tool (equiv -3000 wrds)Given requirements and transactional database, you need to design data warehouse using star schema, develop the data warehouse and use them in a business intelligence tool.50 01, 02, 04, 05
One 2-hours examination (equivalent to 2000 words)Problem-solving examination.30 01, 02, 03, 04
One 1-hour Mid-Semester Test (equivalent to 1000 words)Written feedback is provided to students 2 weeks after the submission.20 01, 02