DATA BASE AND BIG DATA ANALYTICS

12 CFU - 1° e 2° semestre

Docenti titolari dell'insegnamento

SIMONE PALAZZO - Modulo DATA BASE - ING-INF/05 - 6 CFU
ORAZIO TOMARCHIO - Modulo BIG DATA ANALYTICS - ING-INF/05 - 6 CFU


Obiettivi formativi


Modalità di svolgimento dell'insegnamento


Prerequisiti richiesti



Frequenza lezioni



Contenuti del corso



Testi di riferimento


Altro materiale didattico



Programmazione del corso

DATA BASE
 ArgomentiRiferimenti testi
1Introduction to databases: Concepts and ArchitectureBook 1 - Chapter 1 and 2  
2Relational Data Model Book 1 - Chapter 5  
3Basic SQL: data definition, SQL query, update instruction set. Book 1 - Chapter 6 + Notes  
4Advanced SQL: Complex Queries, Triggers, ViewsBook 1 - Chapter 7 + Notes  
5Query processing and optimizationBook 1 - Chapter 18 and 19  
6NOSQL Databases and Big Data Storage SystemsBook 1 - Chapter 24 + Notes  
7Active, Temporal, Spatial, Multimedia, and Deductive DatabasesBook 1 - Chapter 26  
8Getting started with Spark SQL for Data ProcessingBook 2 - Chapter 1 and 2 + Notes  
9Spark SQL for Data ExplorationBook 2 - Chapter 3 + Notes  
10Spark SQL for Learning ApplicationsBook 2 - Chapter 6 and 10 + Notes  
11Multimedia benchmarks for bias identification and analysisResearch paper list on course web site  
BIG DATA ANALYTICS
 ArgomentiRiferimenti testi
1Introduction to Big Data Analytics.[Notes] 
2Business intelligence: introduction, fundamental concepts and architectures[Notes]
[GoRi] Chap. 1 
3The structure and evolution of BI and Big Data analytics systems[Notes] 
4Data models for data warehouse: conceptual modeling and design[GoRi] Chap. 2-6 
5Multi-dimensional data model[GoRi] Chap. 5 
6Data models for data warehouse: logical modeling and design[GoRi] Chap. 8-9 
7ETL (extract, transform and load) process[GoRi] Chap. 10
[Notes] 
8OLAP analysis and query[GoRi] Chap. 7
[Notes] 
9Introduction to Data Visualization. Visual Perception and Preattentive Attributes[Dash] Chap. 1
[Few2] Chap. 4 
10Charts and standard views: relevance, appropriateness and best practices[Few1] 
11Use of colors in data visualization[Dash] Chap. 1 
12Advanced and innovative tools for data visualization: the Tableau platform[Notes] 
13Dashboard design principles. Exploratory vs. Explanatory dashboards.[Few2] 
14Data visualization: infographics and storytelling[Few2] 


Verifica dell'apprendimento


MODALITÀ DI VERIFICA DELL'APPRENDIMENTO

ESEMPI DI DOMANDE E/O ESERCIZI FREQUENTI



Apri in formato Pdf English version