1 / 7

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. The module aims to help students: Understand the fundamentals of a data warehousing environment.

uri
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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)

More Related