DATA MANAGEMENT

Learning Goals

Knowledge and Understanding: Knowledge of the latest technologies for storing, manipulating, retrieving, and transforming large data collections in both the traditional relational context and the broad landscape of NoSQL offerings. Understand the complex problems of storing and retrieving large data collections with emphasis on data consistency, efficient retrieval, scalability, and non-homogeneity.
Applied knowledge and understanding: ability to choose appropriate data model, optimize level of consistency and availability, choose appropriate optimization strategy based on resource and timeliness constraints.
Autonomy of judgment: ability to evaluate the capabilities of different alternative database management systems in the broad landscape of contemporary NoSQL offerings.
Communication skills: ability to present the results of big data analysis for decision support, ability to work in a team.
Learning skills: ability to cope with the rapid technological evolution of Nosql systems by learning technological innovations independently.

Program in pills

The course will introduce traditional relational database management systems and compare their functionality with recently proposed NoSQL paradigms. The course will recap the basic functionality of a transactional relational system (OLTP) and its standard technologies (especially concurrency management and query optimization). Then, OLAP systems and the optimization problem for analytic queries (use of indexes, fragmentation, and view materialization) will be considered. Finally, an overview will be given of the technology choices made in the latest NoSQL proposals (in particular, MongoDB, Cassandra, Neo4J).

Area

Curriculum Foundations
TAF Type

C

Curriculum Industry
TAF Type

C

Curriculum Health
TAF Type

C

Curriculum Economy
TAF Type

C

SSD

INF/01

ECTS

6

Semester

2

Lecturers

Adriano Peron