Sistemas de Gestão de Bases de Dados

Imagem d@ João Muranho [Ficheiro Local]
João Muranho
Código:
17947
Ano:
1
Semestre:
S1
Créditos ECTS:
6
Carga Horária:
PL(30H)/T(30H)
Área Científica:
Informática
Learning outcomes:
This course has two main goals: 1) deepen and expand the knowledge acquired in the introductory course of “Databases”, from the first cycle course, particularly, advanced aspects of the SQL programming, Relational Database Management Systems technologies, temporal databases and data warehousing; and 2) introduce the topic of distributed data, preparing students to understand, design and develop computer solutions based on distributed databases or unstructured databases.

Upon completion their studies, the students should know and understand:
- The differences between a structured and unstructured databases;
- The concepts of replication, distribution, sharding, and resilience;
- How to choose a suitable database for a given application and predict its performance when subjected to different loads.
In short, at the end, students will have a critical understanding of the strategies and problems associated with the databases and will be able to propose new solutions.
Syllabus:
Part I – Advanced aspects of structured databases

1. Management and performance
1.1 Advanced SQL
1.2 Denormalization and partitioning of tables
1.3 Structure of a RDBMS
1.4 Data storage
1.5 Indexing
1.6 Query processing and optimization
1.7 Transaction management

2. Data warehousing
3. Temporal databases

Part II – Distributed data

4. Data distribution and consistency
4.1 Fundamental principles
4.1.1 Flexible data models
4.1.2 Horizontal scalability
4.1.3 Consistency relaxation

4.2 Data distribution
4.2.1 Partition
4.2.2 Replication
4.2.3 Aggregation

4.3 Consistency
4.3.1 Consistency in reading and writing
4.3.2 ACID, BASE and CRUD
4.3.3 The CAP Theorem
4.3.4 Consistency relaxation

5. Distributed databases

6. Big Data and NoSQL
6.1 Big Data
6.2 Hadoop
6.3 MapReduce

7. Unstructured databases
7.1 Key-Value
7.2 Document Oriented
7.3 Column Oriented
7.4 Graph Oriented
Main Bibliography:
Main: Feliz Gouveia, “Bases de Dados – Fundamentos e Aplicações”, 2ª Edição, FCA, 2021, ISBN:
978-972-722-901-7.

1) Thomas Connolly, Carolyn Begg. “Database Systems, A Practical Approach to Design, Implementation and Management”, 6th Edition, 2015. Pearson, ISBN: 978-1-292-06118-4.

2) Sadalage, P. J., & Fowler, M. (2013). “NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence”. Addison-Wesley Professional, ISBN: 978-0321826626.

3) Tiwari, S. (2011). “Professional NoSQL”. John Wiley & Sons, Inc., Indianapolis, ISBN: 978-0-470-94334-6.

4) Redmond, E. & Wilson, J.R. (2012). “Seven Databases in Seven Weeks. A Guide to Modern Databases and the NoSQL Movement”. Pragmatic Bookshelf, ISBN: 978-1-93435-692-0.
Language:
Portuguese. Tutorial support is available in English.