Credit points: 15
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
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. Design and construct a complex Data Warehouse using multi-dimensional modelling technique.
- 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)
- 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.
- 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.
- 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.
- 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.
Select to view your study options…
Melbourne, 2020, 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.
|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|