ADVANCED DATABASES

CSE5ADB

Not currently offered

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.

School: Engineering and Mathematical Sciences (Pre 2022)

Credit points: 15

Subject Co-ordinator: Eric Pardede

Available to Study Abroad/Exchange Students: Yes

Subject year level: Year Level 5 - Masters

Available as Elective: No

Learning Activities: N/A

Capstone subject: No

Subject particulars

Subject rules

Prerequisites: CSE4DBF OR CSE2DBF

Co-requisites: N/A

Incompatible subjects: CSE4ADB

Equivalent subjects: N/A

Quota Management Strategy: N/A

Quota-conditions or rules: N/A

Special conditions: N/A

Minimum credit point requirement: N/A

Assumed knowledge: N/A

Career Ready

Career-focused: No

Work-based learning: No

Self sourced or Uni sourced: N/A

Entire subject or partial subject: N/A

Total hours/days required: N/A

Location of WBL activity (region): N/A

WBL addtional requirements: N/A

Graduate capabilities & intended learning outcomes

Graduate Capabilities

Intended Learning Outcomes

01. Design and construct a complex Data Warehouse using multi-dimensional modelling technique.
02. Write advanced analytical queries for Data Warehouse using OLAP (On Line Analytical Processing)
03. Design Object-Relational Databases and construct queries on Object-Relational Databases.
04. Incorporate object-relational concepts for advanced Data Warehouse design.
05. Integrate Data Warehouse and business intelligence tools and use it for analytical purpose.
Subject not currently offered - Subject options not available.