Advanced Data Base Systems (2020/2021)

Course code
4S001162
Name of lecturer
Alberto Belussi
Coordinator
Alberto Belussi
Number of ECTS credits allocated
6
Academic sector
INF/01 - INFORMATICS
Language of instruction
Italian
Period
II semestre dal Mar 1, 2021 al Jun 11, 2021.

Lesson timetable

Go to lesson schedule

Learning outcomes

The aim of the course is to allow students to acquire in-depth knowledge of the methodologies and tools necessary to manage large amounts of data in new database systems not based on the relational model (we will therefore consider systems based on semi-structured, object-oriented models, NoSQL and models with extensions for including time and space dimension). In particular, the systems that allow to store and manage data produced by steaming data sources (like in the IoT context) will be analyzed so that a correct integration of these new data with the business information system is possible.

At the end of the course, the student will be able to design and query non-traditional databases with tools of the NoSQL approach.

Syllabus

The course aims to provide the theoretical basis for the management of heterogeneous and distributed data:
• Fundamentals: data modeling, query languages, access structures (index)
• Distributed systems: distributed and parallel architectures for data management, transactions in distributed systems.
• New technologies for data management. NoSQL systems: graph-based, semi-structured and document-based model, data design with complex structure, UML for the design of complex data, time and space dimension in complex data.
• Data warehousing and data integration: basic notions

Reference books
Author Title Publisher Year ISBN Note
R. Elmasri, S. B. Navathe Fundamentals of Database Systems (Edizione 1) Addison-Wesley 1994 0805317481

Assessment methods and criteria

Written test on the whole program and oral examination for the final grade.