Full Title:Applied Data Warehousing
Language of Instruction:English
Module Code:DBMS C8006
 
Credits: 5
Valid From:Semester 1 - 2014/15 ( September 2014 )
Module Delivered in No Programmes
Module Description:Students completing this module will understand the techniques of data warehouse physical design, implementation and performance tuning.
Learning Outcomes:
On successful completion of this module the learner should be able to
  1. Implement materialised views and dimensions.
  2. Run queries on the data warehouse.
  3. Use various utilities for loading the warehouse.
  4. Perform database tuning.
 

Module Content & Assessment

Indicative Content
Physical Data Warehouse Design
Storage Engines and Architectures - Performance considerations
ETL Architecture
Determining the Scope of ETL - ETL tools - Extraction Methods - Populating the warehouse
Data Quality
Data Cleansing, matching and consolidation
Data Summarization
Materialized Views and Query Rewriting - OLAP extensions to SQL - Aggregate Navigators
Performance Issues
Denormalisation - Aggregation - Partitioning - Parallel Processing - Bitmap Indexing
Assessment Breakdown%
Course Work40.00%
End of Module Formal Examination60.00%

Full Time

Course Work
Assessment Type Assessment Description Outcome addressed % of total Marks Out Of Pass Marks Assessment Date Duration
Continuous Assessment The continuous assessment component will normally consist of combination of two assessments in the form of practical tests or project assignments. 1,2,3,4 40.00 0 0 n/a 0
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 End-of-Semester Final Examination 4 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   1.00 Every Week 1.00
Practical   2.00 Every Week 2.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.
Resources
Recommended Book Resources
  • Vincent Rainardi 2011, Building a Data Warehouse, APRESS ACADEMIC [ISBN: 143024299X]
  • Ralph Kimball, Margy Ross 2013, The Data Warehouse Toolkit, 3rd Ed., John Wiley & Sons [ISBN: 1118530802]
  • 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]
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