Database Technologies

Code:

M.EIC028

Acronym:

TBD

Keywords
Classification	Keyword
OFICIAL	Information Systems

Instance: 2023/2024 - 2S

Active?	Yes
Responsible unit:	Department of Informatics Engineering
Course/CS Responsible:	Master in Informatics and Computing Engineering

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
M.EIC	25	Syllabus	1	-	6	39	162

Teaching language

Suitable for English-speaking students

Objectives

The students should be able to design and manage large relational databases through object relational modelling and the optimization of the physical schema and the SQL queries. Students will also be able to deal with concurrency in database transactions

Learning outcomes and competences

The student will have the skills to (1) Refine the DB's physical schema, (2) Optimise SQL queries, (3) Model object-relational DBs, (4) Know how to manage concurrency situations, (5) Recover and replicate data.

Working method

Presencial

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

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

Program

1. Physical schema and database tuning. Storing and indexing data. Query execution and optimisation.


2. Modelling in object-relational databases.


3. Recover and replication.


4. Concurrency.

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

Teaching methods and learning activities

Classes are used to formally expound the subject, accompanied by presenting examples and the respective laboratory analyses. To orientate the experimental side of learning, a set of laboratory application exercises is proposed, the resolution of which is followed through to the production of reports.

Software

Oracle SQL Developer
Oracle Server 21c

keywords

Physical sciences > Computer science > Database management

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Designation	Weight (%)
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).

Examinations or Special Assignments

Assessment comprises two small assignments over the course of the semester. The topics of the assignments are query optimisation and object-relational databases. The assignments are due on weeks 7 and 13.

Classification improvement

The final exam can be improved through a grade improvement exam. The classification of the projects' work can be improved the following year.