data warehousing cg124
Download
Skip this Video
Download Presentation
Data Warehousing – CG124

Loading in 2 Seconds...

play fullscreen
1 / 7

Data Warehousing – CG124 - PowerPoint PPT Presentation


  • 70 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Data Warehousing – CG124' - martha-ayala


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