School of Computer Science and Software Engineering

CITS3401 Data Warehousing and Data Mining — Home

Unit Coordinator

Dr. Wei Liu
Rm: CSSE 2.18
Ext: 3095



Dr. Wei Liu


Lab Demonstrator

Dr. Syed Mohammed Shamsul Islam (Shams)


Help Forum


Consultation Time

Where: Room 2.18
Time: Tuesdays 2:00-3:00pm
No appointment needed.



Relational databases are the backbones of modern businesses in processing transactions and storing customer data. Most organizations usually deploy several relational databases for operational convenience. It is quite often necessary to integrate the information existing in different relational databases for planning and decision making. Data warehouses are built to facilitate planning and decision making in businesses integrating data from different relational databases. Online Analytical Processing (OLAP) is a technology that uses a data warehouse for answering aggregation queries often used in planning.

While relational databases hold important transactional information of a business, the success of a business quite often depends on advanced planning and development of strategies based on customer behaviour. Data mining technologies are used for discovering such patterns and trends in data stored in relational databases.

CITS3401 introduces the key mechanisms in data warehousing, OLAP and data mining. We will discuss logical and physical design of data warehouses including, star schema, snowflake schema, data marts, partitioning and materialised views. We will study the use of data warehouses through a study of the OLAP technology, including the MOLAP and ROLAP architectures, OLAP operations and SQL support for OLAP. Finally, we will discuss modern data mining methods including clustering, association rule mining and machine learning techniques.

Weekly Activities:

Lecture times: 10:00 - 11:45am Tuesdays (CSSE 1.24)  
Laboratory sessions (starts week 2): 2:00-4:00pm Tuesdays (CSSE Lab 2.01)

Assessment and important dates:

Assessment Dates
Release Date Due Date
 First Project 20% March 21 April 15, 11:59 pm
 Midterm 10% April 15 April 26 during lecture
 Second Project
May 6 June 3, 11:59 pm
 Final exam
 2 hours, June

This Page

Last Edited on:
Saturday 27th of February 2016 08:45:55 AM

Website Feedback: