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
