Data Warehousing CG124 - PowerPoint PPT Presentation

1 / 7
About This Presentation
Title:

Data Warehousing CG124

Description:

1. Data Warehousing CG124. Dr. Akhtar Ali. School of Computing, Engineering and ... Ralph Kimball (Editor), Laura Reeves, Margy Ross, Warren Thornwaite. ... – PowerPoint PPT presentation

Number of Views:22
Avg rating:3.0/5.0
Slides: 8
Provided by: University5
Category:
Tags: cg124 | data | dr | laura | warehousing

less

Transcript and Presenter's Notes

Title: 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)
Write a Comment
User Comments (0)
About PowerShow.com