Registry
Module Specifications
Archived Version 2020 - 2021
| |||||||||||||||||||||||||||||||||||||
Description A Data Warehouse is the model or structure that supports data mining and decision support through Online Analytical Processing (OLAP). This module teaches students how to construct Data Warehouses by understanding their structures and the concept of multi-dimensional modelling. | |||||||||||||||||||||||||||||||||||||
Learning Outcomes 1. Be able to build Data Warehouses for different application areas. 2. Be able to deploy the Data Warehouse Bus Matrix to create individual data marts. 3. Be able to design a multi-dimensional schema. 4. To understand the structures and functions that deliver OLAP for multi-dimensional schemas. | |||||||||||||||||||||||||||||||||||||
All module information is indicative and subject to change. For further information,students are advised to refer to the University's Marks and Standards and Programme Specific Regulations at: http://www.dcu.ie/registry/examinations/index.shtml |
|||||||||||||||||||||||||||||||||||||
Indicative Content and
Learning Activities OverviewIntroduction to Data WarehousesData Warehouse ArchitectureETL and System ComponentsMultidimensional Data ModelData Cubes, Different schema typesDimensional Design4-step process to designing the data warehouseData Warehouse DeploymentUsing the Data Warehouse Bus MatrixData Warehouse ImplementationIndexing OLAP and Data Cube ComputationEfficient Computation of Data CubesAlgorithms and methods for efficient cube computationWeb Data WarehousesIncoporating web generated data into the warehouseWarehouse Case StudiesAn examination of a number of Warehouse Implementations | |||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||
Indicative Reading List
| |||||||||||||||||||||||||||||||||||||
Other Resources None | |||||||||||||||||||||||||||||||||||||
Programme or List of Programmes | |||||||||||||||||||||||||||||||||||||
Archives: |
|