Go to:
Esta página em português Ajuda Autenticar-se
Paulo Jesus: Exposição Retrospectiva
Você está em: Start > EIC0076

Site map
Edifício A (Administração) Edifício B (Aulas) - Bloco I Edifício B (Aulas) - Bloco II Edifício B (Aulas) - Bloco III Edifício B (Aulas) - Bloco IV Edifício C (Biblioteca) Edifício D (CICA) Edifício E (Química) Edifício F (Minas e Metalurgia) Edifício F (Minas e Metalurgia) Edifício G (Civil) Edifício H (Civil) Edifício I (Electrotecnia) Edifício J (Electrotecnia) Edifício K (Pavilhão FCNAUP) Edifício L (Mecânica) Edifício M (Mecânica) Edifício N (Garagem) Edifício O (Cafetaria) Edifício P (Cantina) Edifício Q (Central de Gases) Edifício R (Laboratório de Engenharia do Ambiente) Edifício S (INESC) Edifício T (Torre do INEGI) Edifício U (Nave do INEGI) Edifício X (Associação de Estudantes)

Database Technologies

Code: EIC0076     Acronym: TBDA

Classification Keyword
OFICIAL Information Systems

Instance: 2018/2019 - 2S Ícone do Moodle

Active? Yes
Responsible unit: Department of Informatics Engineering
Curso/CE Responsável: Master in Informatics and Computing Engineering

Study cycles/ courses

Acronym No. of students Study Plan Curricular Years Credits UCN Credits ECTS Contact hours Total Time
MIEIC 0 Syllabus since 2009/2010 4 - 6 42 162

Teaching - Hours

Recitations: 3,00
Type Teacher Classes Hour
Recitations Totals 1 3,00
Gabriel de Sousa Torcato David 3,00

Teaching language

Portuguese - Suitable for English-speaking students


The students should be able to design and manage large databases, namely to tune the physical schema, to optimize SQL queries, to profit from extensions to object manipulation and XML technology, and to recover and replicate data.

Learning outcomes and competences

The student will have the following competences: (1) Physical DB schema tuning; (2) SQL queries optimization; (3) Object-relational modeling; (4) Building Web and XML interfaces for database systems; (5) Select no-SQL system type; (6) Data recovering and replication.

Working method


Pre-requirements (prior knowledge) and co-requirements (common knowledge)

Students should be acquainted with object programming, relational databases, normalization theory and SQL.


Physical schema and database tuning. Storing and indexing data. Query execution and optimization. Modelling in object relational databases. Building database supported Web applications. Interoperability. XML and databases. Introduction to no-SQL databases and big data. DB administration. Recover and replication.

Mandatory literature

Ullman, Jeffrey D.; A First Course in Database Systems. ISBN: 0-13-861337-0
Garcia-Molina, Hector; Database system implementation. ISBN: 0-13-040264-8

Complementary Bibliography

Date, C. J.; An introduction to database systems. ISBN: 0-201-68419-5
Date, C. J.; A Guide to the SQL Standard. ISBN: 0-201-55822-X
Ramakrishnan, Raghu; Database Management Systems. ISBN: 0-07-115508-2
Akmal B. Chaudhri, Awais Rashid, Roberto Zicari; XML Data Management: Native XML and XML-Enabled Database Systems. ISBN: ISBN: 0201844524

Teaching methods and learning activities

Classes are used to formal presentation of the subjects, along with examples and the corresponding laboratory analysis. To guide the experimental side of the learning process, a set of laboratory exercises are proposed, and its resolution is followed until the final report is produced.


Oracle Server 11g
Oracle SQL Developer


Physical sciences > Computer science > Database management

Type of assessment

Distributed evaluation with final exam

Assessment Components

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

Amount of time allocated to each course unit

Designation Time (Hours)
Estudo autónomo 60,00
Frequência das aulas 42,00
Trabalho laboratorial 60,00
Total: 162,00

Eligibility for exams

Students must reach a minimum grade of 6 out of 20 in the continuous assessment (CA) component.

Calculation formula of final grade

Mark= round(0,5 CA + 0,5 FE). Students must reach a minimum grade of 7,5 out of 20 in the final exam (FE).


Students have to do three assignments during the semester. They will be about: query optimization, object relational databases and XML interoperability, no-SQL databases. The assignments should be delivered on the 5th, 9th and 13th week of the semester.

Classification improvement

Students can improve the classification of the final exam by attending to the second chance exam. The classification of the lab assignments can be improved in the following year.

Recommend this page Top
Copyright 1996-2018 © Faculdade de Engenharia da Universidade do Porto  I Terms and Conditions  I Accessibility  I Index A-Z  I Guest Book
Page generated on: 2018-12-18 at 17:57:46