The course has the goal of presenting of models, methods and tools for the management of large sets of data (“data bases”) and for their design and implementation. Specific attention will be devoted to the issues related to the use of data bases for analytics and evaluation. The student will make experiences with traditional systems, based on the relational model and SQL as well as to specific tools for data warehousing and data mining.
teacher profile teaching materials
Data modeling overview
The relational model
The SQL language
Database management systems
Data warehouse
Introduction to data mining
Data mining problems
Big Data: characteristics, aspects and applications
Frameworks and technologies for Big Data
Edition: 6
Authors: Paolo Atzeni, Stefano Ceri, Piero Fraternali, Stefano Paraboschi, Riccardo Torlone
Publication date: February 1, 2023
Publisher: McGraw Hill
Programme
Introduction to databasesData modeling overview
The relational model
The SQL language
Database management systems
Data warehouse
Introduction to data mining
Data mining problems
Big Data: characteristics, aspects and applications
Frameworks and technologies for Big Data
Core Documentation
Title: Basi di datiEdition: 6
Authors: Paolo Atzeni, Stefano Ceri, Piero Fraternali, Stefano Paraboschi, Riccardo Torlone
Publication date: February 1, 2023
Publisher: McGraw Hill
Type of evaluation
A written test and a project produce by a group of students