Management and Information Technology


CMPT 41063

Data Mining & Warehousing

Status : Elective Pre-requisite : CMPT 12043 Co-requisite : None

On completion of this course, the student should be able to:

  • Have knowledge of the theories and principles of data warehousing.
  • Understand the potential benefits of data warehousing.
  • Understand the techniques and tools used to design a data warehouse.
  • Understand the theories and principles of data warehousing with regard to the practice of decision support.
  • Be able to design multi-dimensional data structures.
  • Appreciate how to interact effectively with managers, consultants and vendors in the development of a data warehouse.

Data Warehousing as a process, Data Warehouse Design, Physical Design, Data Warehousing Architectures, Data quality and metadata management, Data warehouse technology decisions, Data Warehouse Governance, Business Data Mining.

Lectures, Practicles and case discussions.
End-of- Semester examination, practical tests and group assignments.

  1. Kimball, R, Reeves, L, Ross, M and Thornthwaite, W (2008), The Data Warehouse Lifecycle Toolkit,2nd Edition, John Wiley & Sons.
  2. Matteo, G and Stefano R, Data Warehouse Design: Modern Principles and Methodologies,1st Edition, McGraw-Hill Osborne Media.
  3. Jiawei, H, Micheline, K and Jian, P (2011), Data Mining: Concepts and Techniques,3rd Edition,Morgan Kaufmann.
  4. Mallach, E G (2000), Decision Support and Data Warehouse Systems, McGraw Hill.