Informatics Engineering

ADVANCED DATABASE TOPICS

General Data

Type of credits: ECTS
Number of credits: 7.50
Status: Optional
Type: Course
Academic Year:
Term:
Languages: English, Portuguese
Available for Mobility Students: No
Restricted to alliance: No
Code: Sin codigo

Coordination

Description

Theory
2

Theory/Practice
1

Laboratory
2

Instructors

Rosa Reis


 

Contents

CP1. Recent problems and challenges with storing and handling large, heterogeneous data sets;
CP2. Performance Tuning and Query Optimization;
CP3. Distributed Databases;
CP4. Systems for data storage and manipulation, relational and NoSQL;
CP5 ? Search and Indexing in non-relational system ;

Learning Outcomes

By the end of this course, the student must be able to identify and solve problems and issues involved in DBMSs.
At the end of this course, students should be able to:
CO1. Explain problems related to data management (BL4)
CO2. Compare and describe the latest developments in the data management field (BL4)
CO3. Understand the data modeling techniques oriented by documents, by key/ value, key columns and by graphs, and selecting appropriate solutions considering the type of information and the functional requirements of the systems to be developed; (BL5)
CO4. Interpret and apply database storage structures and access techniques to improved performance (BL3)
CO5. Deploy and operate most suitable data management systems regarding domain and requirements.(BL6)