cse5dwd data warehouse concepts and design
DATA WAREHOUSE CONCEPTS AND DESIGN
CSE5DWD
2015
Credit points: 15
Subject outline
Data warehouse underpins most enterprise systems like enterprise resource planning, customer relationship management and supply chain management systems. A data warehouse is designed to provide information from a variety of sources within and outside an organisation to the enterprise systems. This subject introduces students to evolution of data warehouse technology, data warehouse terms and concepts, data warehouse design, data sourcing, organisational issues involved with designing and implementing a data warehouse. Especially, the multidimensional modelling with various data warehouse design schemas such as star schema and snowflake schema are the focuses of the subject. Furthermore, related important technologies of Extract-Transformation- Load (ETL) system including 34 ETL subsystems are discussed and studied. The different Online Analytical Processing (OLAP) architectures and approaches are analysed, compared and evaluated in the subject. The research issues on the performance of data warehouse and OLAP techniques are discussed and investigated. Several real world case studies are used to explain and illustrate various aspects of this subject.
SchoolSchool Engineering&Mathematical Sciences
Credit points15
Subject Co-ordinatorJinli Cao
Available to Study Abroad StudentsYes
Subject year levelYear Level 5 - Masters
Exchange StudentsYes
Subject particulars
Subject rules
Prerequisites BUS5BID or CSE2DBF or CSE4DBF
Co-requisitesN/A
Incompatible subjectsN/A
Equivalent subjectsN/A
Special conditionsN/A
Learning resources
Readings
| Resource Type | Title | Resource Requirement | Author and Year | Publisher |
|---|---|---|---|---|
| Readings | The Data Warehouse Toolkit | Prescribed | Kimball, R and Ross, M, 2013 | WILEY |
| Readings | The Data Warehouse Lifecycle Toolkit, 2nd ed | Recommended | Kimball, R, et al | WILEY, 2008 |
Graduate capabilities & intended learning outcomes
01. Explain the role of the data warehouse within an enterprise system
- Activities:
- Lecture, tutorial discussions
- Related graduate capabilities and elements:
- Literacies and Communication Skills(Writing)
- Inquiry and Analytical Skills(Creative Problem-solving,Inquiry/Research)
- Inquiry and Analytical Skills(Creative Problem-solving,Inquiry/Research)
- Personal and Professional Skills(Ethical behaviour,Adaptability Skills,Study and Learning Skills)
- Personal and Professional Skills(Ethical behaviour,Adaptability Skills,Study and Learning Skills)
- Discipline -Specific Knowledge and Skills(Discipline-Specific Knowledge and Skills)
02. Analyse a given problem and design a suitable data warehouse solution using various dimensional modelling techniques
- Activities:
- Tutorials, assignment, exam
- Related graduate capabilities and elements:
- Discipline -Specific Knowledge and Skills(Discipline-Specific Knowledge and Skills)
- Personal and Professional Skills(Ethical behaviour,Adaptability Skills,Study and Learning Skills)
- Personal and Professional Skills(Ethical behaviour,Adaptability Skills,Study and Learning Skills)
- Inquiry and Analytical Skills(Creative Problem-solving,Inquiry/Research)
- Inquiry and Analytical Skills(Creative Problem-solving,Inquiry/Research)
- Literacies and Communication Skills(Writing)
03. Appraise and compare different data warehouse modelling approaches for real world industry projects
- Activities:
- Tutorials, assignment, exam
- Related graduate capabilities and elements:
- Discipline -Specific Knowledge and Skills(Discipline-Specific Knowledge and Skills)
- Personal and Professional Skills(Ethical behaviour,Adaptability Skills,Study and Learning Skills)
- Personal and Professional Skills(Ethical behaviour,Adaptability Skills,Study and Learning Skills)
- Inquiry and Analytical Skills(Creative Problem-solving,Inquiry/Research)
- Inquiry and Analytical Skills(Creative Problem-solving,Inquiry/Research)
- Literacies and Communication Skills(Writing)
04. Explain and recommend solutions for the issues involved with sourcing data for the data warehouse tool
- Activities:
- Tutorials, Lectures, exam
- Related graduate capabilities and elements:
- Literacies and Communication Skills(Writing)
- Inquiry and Analytical Skills(Creative Problem-solving,Inquiry/Research)
- Inquiry and Analytical Skills(Creative Problem-solving,Inquiry/Research)
- Discipline -Specific Knowledge and Skills(Discipline-Specific Knowledge and Skills)
05. Analyse critically OLAP performance on different data warehouse architectures
- Activities:
- Tutorials, exam
- Related graduate capabilities and elements:
- Discipline -Specific Knowledge and Skills(Discipline-Specific Knowledge and Skills)
- Inquiry and Analytical Skills(Creative Problem-solving,Inquiry/Research)
- Inquiry and Analytical Skills(Creative Problem-solving,Inquiry/Research)
- Literacies and Communication Skills(Writing)
06. Research and apply established theories to improve data warehouse design
- Activities:
- Tutorials, assignment, exam
- Related graduate capabilities and elements:
- Literacies and Communication Skills(Writing)
- Inquiry and Analytical Skills(Creative Problem-solving,Inquiry/Research)
- Inquiry and Analytical Skills(Creative Problem-solving,Inquiry/Research)
- Personal and Professional Skills(Ethical behaviour,Adaptability Skills,Study and Learning Skills)
- Discipline -Specific Knowledge and Skills(Discipline-Specific Knowledge and Skills)
07. Explain the principle involved in managing a data warehouse project
- Activities:
- Tutorials, assignment, exam
- Related graduate capabilities and elements:
- Literacies and Communication Skills(Writing)
- Personal and Professional Skills(Ethical behaviour,Adaptability Skills,Study and Learning Skills)
- Personal and Professional Skills(Ethical behaviour,Adaptability Skills,Study and Learning Skills)
- Discipline -Specific Knowledge and Skills(Discipline-Specific Knowledge and Skills)
Subject options
Select to view your study options…
Melbourne, 2015, Semester 1, Day
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorJinli Cao
Class requirements
LectureWeek: 10 - 22
One 2.0 hours lecture per week on weekdays during the day from week 10 to week 22 and delivered via face-to-face.
Laboratory ClassWeek: 11 - 22
One 2.0 hours laboratory class per week during the day from week 11 to week 22 and delivered via face-to-face.
Assessments
| Assessment element | Comments | % | ILO* |
|---|---|---|---|
| One assignment - data warehouse design using dimensional modelling techniques and OLAP quires | In order to pass the subject, students must pass this assignment. The hurdle is applied to this assessment item. | 30 | 01, 02, 03, 04, 06, 07 |
| One 3-hour examination | In order to pass the subject, students must pass this exam. The hurdle is applied to this assessment item. | 70 | 01, 02, 03, 04, 05, 06, 07 |