Scientific Disciplinary Sector (SSD)
INF/01 - INFORMATICS
Secondo semestre dal Mar 6, 2023 al Jun 16, 2023.
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 data produced by sensors and mobile devices will be analyzed so that a correct integration of these new data sources 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.
Prerequisites and basic notions
Basic knowledge of linear algebra, logic and programming. Knowledge of the relational model, SQL-2 query language.
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: 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 integration: basic notions
Visualizza la bibliografia con Leganto, strumento che il Sistema Bibliotecario mette a disposizione per recuperare i testi in programma d'esame in modo semplice e innovativo.
Teaching methods: lectures, classroom exercises with the teacher, teaching material (slides) and further exercises available on the eLearning platform, reception at the times indicated on the teacher's web page.
Learning assessment procedures
Written exam on the entire program and project on a specific NoSQL technology. The written test and the presentation of the project can take place on different days and also in different sessions and without any preferential order.
To pass the exam, students will have to demonstrate that: - they have understood the concepts underlying the theory of relational databases and NoSQL of their design and implementation on real systems - be able to present their arguments in a precise and organic without digressions - knowing how to apply the knowledge acquired to solve application problems presented in the form of exercises, questions and projects.
Criteria for the composition of the final grade
The final grade is obtained from the arithmetic average between the project grade and the written grade.