Autenticação

Utilizador:

Senha:

Iniciar sessão

Esqueceu-se da senha?

Data Warehousing

Code:

BINF015

Sigla:

DW

Áreas Científicas
Classificação	Área Científica
OFICIAL	Informática

Ocorrência: 2022/2023 - 1S

Ativa?	Yes
Unidade Responsável:	Departamento de Matemática e Informática
Curso/CE Responsável:	Undergraduate in Bioinformatics

Ciclos de Estudo/Cursos

Sigla	Nº de Estudantes	Plano de Estudos	Anos Curriculares	Créditos UCN	Créditos ECTS	Horas de Contacto	Horas Totais
BINF	22	Study Plan	2	-	5	67,5	135

Língua de trabalho

Portuguese

Objetivos

In this curricular unit, the student should be able to characterize the architecture and distinguish the different models of a Data Warehouse, approaching the dimensional model of Ralph Kimball and the business model of W. H. Inmon.

It is intended that the student master the Data Warehouse components, and be able to plan and execute the development cycle of a Data Warehouse. The student should be able to master the analysis and design of the ETL process and have knowledge of OLAP interrogation tools.

The student should develop practical skills in the development of data warehouses based on the star schema and the ability to build MDX expressions, using Microsoft SQL Server Data Tools or the Oracle Exadata Intelligent Warehouse solution.

Resultados de aprendizagem e competências

The student should be able to plan, design and build Data Warehouses using star schema and dimensional modeling.

Must have solid knowledge of a tool for the development of the Data Warehouse, with special focus on the ETL process.

Modo de trabalho

À distância

Programa

Introduction to Data Warehouse



OLAP vs OLTP



The DW Modeling Architectures: Kimball's Dimensional Architecture and W. H. Inmon's Enterprise Architecture.



The DW components: the data sources, the staging area, the data presentation and the data access tools.



the dimensional model



Star schema and the construction of data marts



Fact tables: types of facts and data aggregation.



Dimension tables: The role of hierarchies in dimension tables, managing changes to attribute values;



History management in DW



DW development process: the dimensional business lifecycle



Modeling the business process. The bus architecture, the BUS matrix



Focus on building the ETL process. Use of a tool for practical development of a Data Warehouse.

Introduction to MDX queries for querying OLAP databases. Exploration of a tool for data access.

Bibliografia Obrigatória

Caldeira, Carlos; Data Warehousing, Conceitos e Modelos, Edições Sílabo, 2008
Kimball, Ralph - Ross, Margy; The Data Warehouse Toolkit, Third Edition, Wiley, 2013

Bibliografia Complementar

Rainardi, Vincent; Building a Data Warehouse - With examples in SQL Server, Apress, 2008

Métodos de ensino e atividades de aprendizagem

Theoretical-practical classes will be given, using the expository technique, using a video projector, slideshow (powerpoint) or animations (prezi) and sessions through the Microsoft Teams tool with remote environment sharing.



It seeks to stimulate students' interest, reasoning and critical thinking.



The laboratory computer will be used to carry out the practical exercises, with access to an application and database server.

Software

Microsoft SQL Server developer edition
SQL Server Management Studio
Microsoft Visual Studio Community Edition
Pacote Data tools para VS com SSIS e SSAS

Tipo de avaliação

Distributed evaluation with final exam

Componentes de Avaliação

Designation	Peso (%)
Teste	40,00
Trabalho escrito	30,00
Trabalho laboratorial	30,00
Total:	100,00

Componentes de Ocupação

Designation	Tempo (Horas)
Estudo autónomo	45,00
Frequência das aulas	60,00
Elaboração de projeto	15,00
Elaboração de relatório/dissertação/tese	15,00
Total:	135,00

Obtenção de frequência

Not applicable

Fórmula de cálculo da classificação final

Continuous assessment
20% project1 + 20% project 2+ 20% project 3+ 40% test

Final exam
20% project1 + 20% project 2+ 20% project 3+ 40% written exam

100% approval by exam is not foreseen due to the markedly practical/laboratory nature of this curricular unit