cse5adb advanced databases

ADVANCED DATABASES

CSE5ADB

Not currently offered

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-ordinatorWenny Rahayu

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(Critical Thinking)
Quantitative Literacy/ Numeracy(Quantitative Literacy/ Numeracy)
Inquiry/ Research(Inquiry/ Research)
Discipline-specific GCs(Discipline-specific GCs)
Creative Problem-solving(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(Quantitative Literacy/ Numeracy)
Discipline-specific GCs(Discipline-specific GCs)
Creative Problem-solving(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(Critical Thinking)
Creative Problem-solving(Creative Problem-solving)
Discipline-specific GCs(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(Creative Problem-solving)
Inquiry/ Research(Inquiry/ Research)
Critical Thinking(Critical Thinking)
Discipline-specific GCs(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(Inquiry/ Research)
Discipline-specific GCs(Discipline-specific GCs)
Critical Thinking(Critical Thinking)

Subject options

Select to view your study options…

Start date between: and    Key dates

Subject not currently offered - Subject options not available.