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.
scheda docente
materiale didattico
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
Programma
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
Testi Adottati
Title: Basi di datiEdition: 6
Authors: Paolo Atzeni, Stefano Ceri, Piero Fraternali, Stefano Paraboschi, Riccardo Torlone
Publication date: February 1, 2023
Publisher: McGraw Hill
Modalità Frequenza
Class attendance is not mandatoryModalità Valutazione
A computer-based test with questions on theoretical concepts, SQL language queries and use of the software tools presented during lessons. In the event that the test taken by the candidate presents elements that do not allow the teacher to make an objective assessment (such as unclear answers, ambiguities or other), the teacher may request an oral interview.