1.- Fundamentals Module

M03 - Data management

This subject aims to provide the student with an introduction to the data models and information systems, including both design and practical implementation of databases or file systems, and the tools to exploit them. It is also expected that the student will understand the interest of designing the solutions taking into account the complete life cycle of the data, from the management planning till the publication and possible re-use.

1. Introduction to information management. Information systems lifecycle.

2. Types and structures of data. Data modeling. Conceptual design, logical design and physical design.

3. Data management technologies for scientific systems and corporate systems.

4. Relational database. SQL Language. OLAP technology.

5. Databases for Big Data problems.

6. Extraction, transformation and data loading.

7. Different approaches to the Data Lifecycle.

8. Planning Data Management: DMPs

9. Metadata Management Tools.

10. Data ingestion. Multidisciplinary examples.

11. Publication as Open Data.