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.

FacultyFaculty of Science, Tech & Engineering

Credit points15

Subject Co-ordinatorJinli Cao

Available to Study Abroad StudentsYes

Subject year levelYear Level 4 - UG/Hons/1st Yr PG

Exchange StudentsYes

Subject particulars

Subject rules

PrerequisitesN/A

Co-requisites BUS5BID

Incompatible subjects CSE4ADB

Equivalent subjectsN/A

Special conditionsN/A

Readings

Resource TypeTitleResource RequirementAuthor and YearPublisher
ReadingsThe Data Warehouse ToolkitPrescribedKimball, R and Ross, MWILEY 2002
ReadingsThe Data Warehouse Lifecycle Toolkit, 2nd edRecommendedKimball, R, et alWILEY, 2008

Subject options

Select to view your study options…

Start date between: and    Key dates

Melbourne, 2014, Semester 1, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorJinli Cao

Class requirements

Computer Laboratory Week: 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.

Lecture Week: 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 elementComments%
one 3-hour examination70
one assignment - data warehouse design using dimensional modelling techniquesIn 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