Database Technologies

Code:

M.EIC028

Acronym:

TBD

Keywords
Classification	Keyword
OFICIAL	Information Systems

Instance: 2022/2023 - 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	17	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, namely through object relational modeling and the optimization of the physical schema and the SQL queries. They should also be able to select and use non relational databases, to deal with problems that exceed the relational systems capacity.

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) Select no-SQL system types; (5) Use databases with JSON document and graph models; (6) Data recovering and replication.

Working method

Presencial

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

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

Program

Physical schema and database tuning. Storing and indexing data. Query execution and optimization.
Modelling in object relational databases.
Introduction to no-SQL databases and big data. Systems with JSON document based model (MongoDB). Systems with graph model (Neo4J).
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.

Software

Neo4J
Oracle SQL Developer
MongoDB
Oracle Server 18c

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

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.