This course examines the design of databases and data warehouses and their use for data mining; and investigates associated issues. Topics may include: relational theory and conceptual modelling; privacy and security; statistical databases; distributed databases; data warehousing; data cleaning and integration; and data mining concepts and techniques.

On completion of this course, the students should have gained a good understanding of basic concepts, principles and techniques in data warehousing and data mining. Specifically,the students are able to perform the following tasks.

• perform data modeling
• apply OLAP techniques for mulit-dimensional data analysis
• apply datacubing techniques
• develop general skill of data warehousing project management
• obtain the general knowledge on the design and implementation of data warehouses
• be able to apply data mining techniques for knowledge discovery
•  develop in-depth understanding of fundamental data mining algorithms
• perform data mining in data warehouses.

Two assignments (40 marks); Final Exam (60 marks)

Thirty one-hour lectures and six two-hour tutorials

COMP1100 or COMP2720; COMP2400; 6 units of 2000-level IT courses; and 6 units of 1000-level MATH/STAT courses.

The following text book will be used for this course:

• Han, Jiawei & Kamber, Micheline Data Mining: Concepts and Techniques Morgan Kaufmann Publishers, 2nd Edition, March 2006.

The following reference book is recommended for this course:

• Elmasri and Navathe Fundamentals of Database SystemsAddison-Wesley, 5th Edition, 2007.