Data warehousing cg124
This presentation is the property of its rightful owner.
Sponsored Links
1 / 7

Data Warehousing – CG124 PowerPoint PPT Presentation


  • 81 Views
  • Uploaded on
  • Presentation posted in: General

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.

Download Presentation

Data Warehousing – CG124

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Data warehousing cg124

Data Warehousing – CG124

Dr. Akhtar Ali

School of Computing, Engineering and Information Sciences

Computing.unn.ac.uk/staff/CGMA2/CG124


Module aims

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

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

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

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

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

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)


  • Login