cse5adb advanced databases

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.

SchoolEngineering and Mathematical Sciences

Credit points15

Subject Co-ordinatorEric Pardede

Available to Study Abroad/Exchange StudentsYes

Subject year levelYear Level 5 - Masters

Available as ElectiveNo

Learning ActivitiesN/A

Capstone subjectNo

Subject particulars

Subject rules

PrerequisitesCSE4DBF OR CSE2DBF

Co-requisitesN/A

Incompatible subjectsCSE4ADB

Equivalent subjectsN/A

Quota Management StrategyN/A

Quota-conditions or rulesN/A

Special conditionsN/A

Minimum credit point requirementN/A

Assumed knowledgeN/A

Career Ready

Career-focusedNo

Work-based learningNo

Self sourced or Uni sourcedN/A

Entire subject or partial subjectN/A

Total hours/days requiredN/A

Location of WBL activity (region)N/A

WBL addtional requirementsN/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 options

Select to view your study options…

Start date between: and    Key dates

Subject not currently offered - Subject options not available.