Autenticação

Utilizador:

Senha:

Iniciar sessão

Esqueceu-se da senha?

Databases Complements

Code:

INF32158

Sigla:

CBD

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

Ocorrência: 2023/2024 - 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	130	Plano de Estudos	2	-	6	60	162

Língua de trabalho

Portuguese

Objetivos

The curricular unit aims to provide students with the following learning objectives:

Obj 1: Know the aspects related to the organization of data persistence in a DBMS.
Obj 2: Know how to define the physical structure of a database in a DBMS.
Obj 3: Know and apply query optimization techniques.
Obj 4: Know DBMS monitoring and optimization tools.
Obj 5: Know the concepts of transaction and concurrency control in data access.
Obj 6: Know how to define and apply concurrent data access in a database.
Obj 7: Know and apply backup management techniques.
Obj 8: Know the objectives and concepts of information replication.
Obj 9: Know how to define security policies when accessing information.
Obj 10: Know the concepts of NoSQL databases.
Obj 11: Know how to create and manipulate information in a NoSQL system.

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: 30% of the average of the grades (minimum grade 8) of the 3 quizs + 70% test (minimum grade 9)
- PC: Project 2 phases (50% + 50%), minimun grade per phase 7

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

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

Observações

Support hours:

Cláudio Sapateiro: 3ªF (office F355)

Gabriel Pestana: 3ªF das 14:h30 (office D316)

João Portelinha: Monday from 3:30 p.m. to 5:30 p.m. (office D308)