Full Title:Data Warehouse Design
Language of Instruction:English
Module Code:DBMS C8004
Credits: 5
Valid From:Semester 1 - 2014/15 ( September 2014 )
Module Delivered in No Programmes
Module Description:Students completing this module will understand data warehouse design principles; have analysed, implemented, and tested solutions to problems; be able to design, implement and query a data warehouse and have a good understanding of data quality issues.
Learning Outcomes:
On successful completion of this module the learner should be able to
  1. Understand the concepts of an Analytical System
  2. Construct a Star Schema and a Snowflake Schema
  3. Create new objects and use new SQL extensions
  4. Understand the implications of History in Data Warehousing
  5. Understand Project Management concepts

Module Content & Assessment

Indicative Content
Data Warehouse Fundamentals
OLTPs vs OLAP - Data Warehouse Characteristics - Data Marts V’s Data Warehouse - Generic Data Warehouse Architecture - Data Warehouse Applications - Data Cube Concepts - MOLAP, ROLAP and HOLAP
Logical Data Warehouse Design
Facts, Dimensions and Hierarchies - Star Schema’s and variations RDBMS support for Multidimensional Data - Change Data Capture
Data Warehouse Architecture
Characteristics of a Data Warehouse Architecture Generic Architecture & variations Data Marts and ODS
Data Warehousing for CRM
CRM components Maintaining History - Retrospection - Kimballs Solution
Data Warehouse Management
Business Justification - Project Management
Assessment Breakdown%
Course Work40.00%
End of Module Formal Examination60.00%

Full Time

No Course Work
No Project
No Practical
End of Module Formal Examination
Assessment Type Assessment Description Outcome addressed % of total Marks Out Of Pass Marks Assessment Date Duration
Formal Exam n/a 1,2,4,3,5 60.00 0 0 End-of-Semester 0
Reassessment Requirement
A repeat examination
Reassessment of this module will consist of a repeat examination. It is possible that there will also be a requirement to be reassessed in a coursework element.

DKIT reserves the right to alter the nature and timings of assessment


Module Workload & Resources

Workload: Full Time
Workload Type Workload Description Hours Frequency Average Weekly Learner Workload
Lecture   2.00 Every Week 2.00
Practical   1.00 Every Week 1.00
Directed Reading   2.00 Every Week 2.00
Independent Study   3.00 Every Week 3.00
Total Weekly Learner Workload 8.00
Total Weekly Contact Hours 3.00
This course has no Part Time workload.
Recommended Book Resources
  • Vincent Rainardi 2011, Building a Data Warehouse, APRESS ACADEMIC [ISBN: 143024299X]
  • Mundy J., Thornthwaite W., Kimball R. 2011, Microsoft Data Warehouse Toolkit, 2nd Ed., John Wiley & Sons [ISBN: 0470640383]
  • Inmon, William H. 2005, Building the Data Warehouse, 4th ed Ed., John Wiley & Sons [ISBN: 0764599445]
  • Kimball R., Ross M., Thornthwaite W., Mundy J., Becker B. 2008, The Data Warehouse Lifecycle Toolkit, 2nd ed Ed., Wiley [ISBN: 978-0470149775]
Supplementary Book Resources
  • Turban E., Sharda R., Delen D. 2013, Decision Support and Business Intelligence Systems, 9th Ed., Pearson [ISBN: 1292024267]
This module does not have any article/paper resources
Other Resources