Credit points: 15
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
Subject Co-ordinatorEric Pardede
Available to Study Abroad StudentsYes
Subject year levelYear Level 5 - Masters
Prerequisites CSE2DBF or CSE4DBF
Incompatible subjects CSE4ADB
Graduate capabilities & intended learning outcomes
01. Apply multi-dimensional modelling technique to build a data warehouse.
- 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.
02. Implement data warehouse analysis query (OLAP - On Line Analytical Processing).
- 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.
03. Apply Object-Relational database design and queries.
- 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.
04. Implement an integrated Object-Relational Data Warehouse
- 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.
05. Implement and evaluate web database application and XML queries.
- 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
Select to view your study options…
Melbourne, 2018, Semester 2, Day
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorEric Pardede
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.
One 2.0 hours lecture per week on weekdays during the day from week 31 to week 43 and delivered via face-to-face.
|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 Test||10||01, 02, 03|