Data Warehousing CG124

1
Data Warehousing CG124

• Dr. Akhtar Ali
• School of Computing, Engineering and Information
  Sciences
• Computing.unn.ac.uk/staff/CGMA2/CG124

2
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.

3
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.

4
Main Topics

• Introduction to Data Warehousing
• Data Warehouse Components
• Data Warehouse Maintenance
• Data Warehouse Design
• Oracle Data Warehousing Support
• On-Line Analytical Processing (OLAP)

5
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)

6
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)

7
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)