IPT Logotipo do IPT

Engenharia Informática

Advanced Databases

<< back to Curriculum Plan

Publication in the Diário da República: Despacho n.º 8644/2020 - 08/09/2020

5 ECTS; 2º Ano, 2º Semestre, 28,0 PL + 28,0 TP , Cód. 911942.

Lecturer
- António Casimiro Teixeira Batista (2)
- José Casimiro Nunes Pereira (1)(2)

(1) Docente Responsável
(2) Docente que lecciona

Prerequisites
Deep knowledge of modeling Databases is mandatory.
Knowledge of any Object Oriented Programming language is mandatory.

Objectives
a) identify and describe the physical aspects of a database;
b) carry out transactions in databases;
c) identify and describe data recovery and backup structures
d) identify and choose user permissions
e) define and implement mechanisms for automating a database: procedures, functions, triggers and events
f) define and implement replication of a database
g) define storage and optimization parameters for relational databases

Program
1. Database administration
Installation of a DBMS
Start and stop of a DBMS
Database import and export

2. Physical aspects of a database
Types of structures
Tablespaces and files
Data blocks, extents and segments
Storage of records in blocks
Indexes
Groupings
Clustering indices

3. Transactions and concurrency control
Transaction Concept
Transaction recovery and savepoints
SQL commands for transaction management
Processing transactions in a DBMS
Rollback segments
Fault tolerance
Competition and consistency
Blocks
Impasses

4. Privileges and security
User management
Backups
Replication
Fault tolerance

5. SQL as part of a procedural language
Exception Handling
Parameterized commands
Common Table Expressions
Windows Functions
Procedures
Functions
Triggers
Events

6. Query Optimization
The EXPLAIN command
Execution plans

Evaluation Methodology
Exam (85%) and Practical Work (15%).

Bibliography
- Date, C. (2003). An Introduction to Database Systems. (Vol. 8th.). .: Addison Wesley
- Gouveia, F. (2014). Fundamentos de Bases de Dados. (Vol. 1st.). Lisboa: FCA - Editora de Informática, Lda
- Navathe, S. e Elmasri, R. (2010). Fundamentals of Database Systems. (Vol. 6th.). .: Addison Wesley
- Pereira, J. e Batista, A. (2012). Apontamentos de Material de Apoio. (Vol. 1). Tomar: edição de autor

Teaching Method
Lectures, tutorials and laboratory classes.

Software used in class
MySQL
MySQL Workbench

 

 

 


<< back to Curriculum Plan
NP4552
Financiamento
KreativEu
erasmus
catedra
b-on
portugal2020
centro2020
compete2020
crusoe
fct
feder
fse
poch
portugal2030
poseur
prr
santander
republica
UE next generation
Centro 2030
Lisboa 2020
co-financiado