Department of Engineering
for Innovation
Department of Engineering
for Innovation
Systems, Data and Applications
Education
Data Management
Master’s Degree in Data Management
Credits: 9.0
Course year: 3
Teaching hours: 81.0
Language: English
Curriculum: Common path
Short Description:
The course will be organised into four section:
- Management Information Systems
- Technical / technological aspects;
- Business aspects;
- Business Intelligence (BI) concepts;
- Enterprise MIS;
- The importance of data management and data quality.
- Relational Databases, R-DBMS and OLTP
- Introduction; core concepts and definitions; reference architectures
- Data, Database, DBMS, RDBMS
- Conceptual modelling: ER / EER diagrams and design reference patterns
- Logical modelling: the mapping algorithm
- Physical modelling
- SQL queries
- Introduction to NoSQL DBMS
- Data Warehouse (DWH) and OLAP
- Introduction; core concepts and definitions
- Requirement analysis and elicitation
- Use case modelling with UML 2.0 U-C diagrams
- Conceptual modelling: DFM
- Logical modelling: ROLAP
- Physical modelling: DWH and data marts
- ETL pipelines
- Additional topics
- Citizen Science
- Data security
- Data storytelling
- Data visualisation
- (Big) Data Quality
- Big data, data lakes, data analytics, machine learning, AI;
More info: Data Management