Databases Complements

Code:

INF32158

Sigla:

CBD

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

Ocorrência: 2021/2022 - 1S

Ativa?	Yes
Unidade Responsável:	Departamento de Sistemas e Informática
Curso/CE Responsável:	Informatics Engineering

Ciclos de Estudo/Cursos

Sigla	Nº de Estudantes	Plano de Estudos	Anos Curriculares	Créditos UCN	Créditos ECTS	Horas de Contacto	Horas Totais
INF	111	Plano de Estudos	2	-	6	60	162

Docência - Responsabilidades

Docente	Responsabilidade
João Paulo Portelinha Santos

Docência - Horas

Theorethical:	2,00
Practical and Laboratory:	2,00

Type	Docente	Turmas	Horas
Theorethical	Totais	3	6,00
	Cláudio Miguel Garcia Loureiro dos Santos Sapateiro		2,00
	João Paulo Portelinha Santos		4,00
Practical and Laboratory	Totais	7	14,00
	Cláudio Miguel Garcia Loureiro dos Santos Sapateiro		2,00
	Gabriel César Ferreira Pestana		8,00
	Luís Miguel Claudino Cassaca		4,00

Língua de trabalho

Portuguese

Objetivos

The curricular unit aims to provide students with the folling skills:
- Knowing the mechanisms used by DBMS in the organization and persistence of data
- Recognize the aspects that influence the performance of relational DBMS, and how they can be optimized
- Acting in an administration aspect on relational DBMS
- Relation DBMS administration role
- Distinguish criteria that motivate the adoption of NoSQL DBMSs

Resultados de aprendizagem e competências

- Know to administrative a DBMS
- Identify and apply the concepts related to tunning databases
- Implement database replication
- Implement security mechanisms in databases
- Distinguish criteria that motivate the adoption of NoSQL systems

Modo de trabalho

Presencial

Programa

1. File architecture and structure (the MS SQL Server example)
2. Metadata (MS SQL Catalog)
3. T-SQL (by example)
4. Indexing
5. Query Processing and Optimization
6. Monotoring and Tunning
7. Transactions and concurrence
8. Backup & Restore
9. Safety
10. Replication
11. Basics of NoSQL DBs

Bibliografia Obrigatória

Avi Silberschatz, Henry F. Korth and S. Sudarshan; Database System Concepts, 6th Edition, McGraw Hill. ISBN: 0-07-352332-1
Feliz Gouveia; Fundamentos de Bases de Dados, FCA. ISBN: 978-972- 722-799-0

Métodos de ensino e atividades de aprendizagem

The pedagogical methodology used in this curriculum unit is based on two components: lecture method and group work in laboratory environment.

Will be used an e-learning platform (Moodle) to support teaching, as repository of information, forum, delivery of work and testing of self assessment and summative evaluation.

Software

MS SQL Server 2019 (IPS - Microsoft] + SQL Server Management Studio
Mongo DB

Tipo de avaliação

Distributed evaluation with final exam

Componentes de Avaliação

Designation	Peso (%)
Exame	50,00
Trabalho laboratorial	50,00
Total:	100,00

Componentes de Ocupação

Designation	Tempo (Horas)
Elaboração de projeto	50,00
Estudo autónomo	30,00
Frequência das aulas	60,00
Trabalho laboratorial	20,00
Total:	160,00

Obtenção de frequência

Continuous evaluation
- Test and quizs
- Pratical works and project, by groups of 2 students

Evaluation with final exam
- Exam
- Project

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

Continuous evaluation
- TC: 20% of the average of the 3 highest grades (minimum grade 7.5) of the 5 quizs + 80% test
- PC: 20% pratical works + 80% project

Evaluation with final exam
- TC: Exam
- PC: Project

Final grade: 50% TC + 50% PC
(minimum grade of TC and PC >= 9.5)

Recomendar Página Voltar ao Topo