Data Warehousing – CG124 Dr. Akhtar Ali School of Computing, Engineering and Information Sciences Computing.unn.ac.uk/staff/CGMA2/CG124
Module Aims The module aims to help students: • Understand the fundamentals of a data warehousing environment. • Learn the mechanisms for designing, constructing, and populating data warehouses. • Analyse different approaches to data warehouse maintenance. • Explore the real world applications of data warehousing using OLAP technologies. • Gain practical skills in implementing a data warehouse using Oracle.
Learning Outcomes On completion, the student should be able to: • Design, construct, and populate a data warehouse; • Devise efficient and cost effective methods for maintaining data warehouses; and • Implement a data warehouse using Oracle.
Main Topics • Introduction to Data Warehousing • Data Warehouse Components • Data Warehouse Maintenance • Data Warehouse Design • Oracle Data Warehousing Support • On-Line Analytical Processing (OLAP)
Prerequisite Knowledge & Skills • Prior knowledge of Relational Databases • Relational databases’ theory, For Example: • Relations • Keys • Constraints • Relational algebra • SQL (structured query language) • OR previously attended module CM036 (Advanced databases)
Assessment • Individual Assignment • Worth 40% • Given out in week 7 • Due in week 12 • Open Book Exam • Worth 60% • 2 hours duration • In week 13 to 15 (May/June)
Books and Learning Resources • Text Book • Ralph Kimball (Editor), Laura Reeves, Margy Ross, Warren Thornwaite. The Data Warehouse Lifecycle Toolkit: Tools and Techniques for Designing, Developing and Deploying Data Marts and Data Warehouse. John Wiley, 1998. • Supplementary Material • Surajit Chaudhuri, Umeshwar Dayal. An Overview of Data Warehousing and OLAP Technology. ACM Sigmod Record, March 1997. • Jennifer Widom. Research Problems in Data Warehousing. International Conference on Information and Knowledge Management 1995. • M. Akhtar Ali, Alvaro A. A. Fernandes and Norman W. Paton. MOVIE: An Incremental Maintenance System for Materialized Object Views. Data and Knowledge Engineering (DKE) Vol. 47, Issue 2, November 2003, Pages 131-166. • Online Resources • Blackboard (all the lecture notes, seminar handouts) and my homepage • Oracle Documentation (Oracle 9i Data Warehousing Guide)