Data Warehousing
Code
8411
Academic unit
Faculdade de Ciências e Tecnologia
Department
Departamento de Informática
Credits
6.0
Teacher in charge
João Carlos Gomes Moura Pires, José Júlio Alves Alferes
Weekly hours
2
Total hours
36
Teaching language
Português
Objectives
This course presents the concepts, architectures and models of Data Warehouse. The two mainstream schools (W. H. Immon and R. Kimball) are presented and discussed. Multidimensional Modeling for OLAP. Deriving OLAP Multidimensional models from OLTP models. Conceptual modeling for multidimensional models. ETL. Metadata. OLAP querying: SQL, MDX, JAVA APIs. Geographic Information in OLAP.
Subject matter
Introduction to Data Warehousing
Introduction to OLAP
Multidimensional model
Typical OLAP operations
Interaction in the data analysis process
Information visualization
Data Warehouse according to the E/R school
Subject Data Model; Business Data Model, System Model; Technology Model
Advanced topics: historical data, hierarchical data, Transactions data
Data warehouse according to the multidimensional school
Architecture
Advanced topics on multidimensional modeling
Deriving analytical models from E/R models
Conceptual multidimensional data models
Introduction to ETL
Introduction to physical implementation
Integration of geographic information into OLAP
Case studies
Bibliography
Mastering Data Warehouse Design : Relational and Dimensional Techniques - Claudia Imhoff, et al. Wiley, 2003
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition) - Ralph Kimball, Margy Ross. Wiley, 2002
Building the Data Warehouse (4rd Edition), W. H. Inmon - Wiley. 2005
A selected set of papers
Evaluation method
Rules for student evaluation
The assessment has the following components:
IT: An Individual Test (2 hours). It will be graded on a 0 - 20 scale and contributes with 25% to the final grade.
PW-SR: A Practical team-Work Subject Registration. A written report presenting and describing the problem, the approach the architecture and the thecnologies. It will be graded on a scale 0 - 20 scale. Contributes with 20 % to the final grade.
PW: Final report on the Practical team-Work. A written report presenting and describing the problem, the developed solution. It will be graded on a scale 0 - 20 scale
Contributes with 25 % to the final grade.
OE: An Oral Examination for each team of 2 students (max of 90 minutes). Presentation; Demonstration. It will be graded on a 0 - 20 scale. Contributes with 30 % to the final grade. Each student gets an individual grade.
To get the right to access to the OE (obter frequência), the student must satisfy the following conditions:
- IT ≥ 5;
- PW ≥ 10;
The final grade is calculated according to:
0.25 x IT + 0.2 * PW-SR + 0.25 x PW + 0.30 x OE.