DATA WAREHOUSE CONCEPTS AND DESIGN
CSE4DWD
2014
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, the related important technologies of Extract-Transformation-Load (ETL) system and Online Analytical Processing (OLAP) approaches are discussed in the subject. Several real world case studies are used to explain and illustrate various aspects of this subject.
Faculty: Faculty of Science, Tech & Engineering
Credit points: 15
Subject Co-ordinator: Jinli Cao
Available to Study Abroad Students: Yes
Subject year level: Year Level 4 - UG/Hons/1st Yr PG
Exchange Students: Yes
Subject particulars
Subject rules
Prerequisites: N/A
Co-requisites: BUS5BID
Incompatible subjects: CSE4ADB
Equivalent subjects: N/A
Special conditions: N/A
Learning resources
Readings
| Resource Type | Title | Resource Requirement | Author and Year | Publisher |
|---|---|---|---|---|
| Readings | The Data Warehouse Toolkit | Prescribed | Kimball, R and Ross, M | WILEY 2002 |
| Readings | The Data Warehouse Lifecycle Toolkit, 2nd ed | Recommended | Kimball, R, et al | WILEY, 2008 |
Melbourne, 2014, Semester 1, Day
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: Jinli Cao
Class requirements
Computer LaboratoryWeek: 10 - 22
One 2.0 hours computer laboratory per week on weekdays during the day from week 10 to week 22 and delivered via face-to-face.
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.
Assessments
| Assessment element | Comments | % |
|---|---|---|
| one 3-hour examination | 70 | |
| one assignment - data warehouse design using dimensional modelling techniques | In order to pass the subject, students must attend at least 70% of the laboratory classes and must obtain an overall pass grade, pass the examination and pass the overall non-examination components. | 30 |