Description

Without data is impossible to have information. Thus, any information system should contain data that will be managed by a Database Management System, typically relational. In the course "Databases" that precedes this, the relational model has been studied together with some query languages like SQL and relational algebra. This course is primarily intended to deepen this knowledge to interpret and learn more by reverse engineering the logical design of Relational Database for information systems, by analyzing the problems posed, alternatives can be found. We will also analyze the difficulty of integrating different sources of information and how to measure and manage the quality of data. Finally, we will devote a large part of the course to topics specific to Databases administration, such as query performance, concurrency control, and recovery.