Teaching

Databases Unit 2 (Basi di Dati)

(Corso di Laurea in Informatica)

Database design

- Introduction to software engineering

- The Entity-Relationship (ER) model

- ER modeling: advanced notions

- Conceptual database design

- The relational mode

- Logical database design

The SQL language

- SQL: Data Definition Language (DDL)

- SQL: Data Manipulation Language (DML)

- SQL: Views, Trigger, Procedure

- SQL: Control Language

- SQL: Transactions and Transaction Language

- Database Recovery

RDF databases

- The RDF data model

- RDFS, RDFS+ reasoning

- The SPARQL query language

Data Managment and Analysis Unit 2

(Applied Computer Science and Artificial Intelligence)

Database design

- Introduction to software engineering

- The Entity-Relationship (ER) model

- ER modeling: advanced notions

- Conceptual database design

- The relational model

- Logical database design

The SQL language

- SQL: Data Definition Language (DDL)

- SQL: Data Manipulation Language (DML)

- SQL: Views, Trigger, Procedure

- SQL: Control Language

- SQL: Transactions and Transaction Language

- Database Recovery

NoSQL databases

- Document databases

- MongoDB

- Graph Databases

- Neo4J

Big Data Computing

(wit prof. Tolomei)

(Computer Science - Informatica)

Unsupervised Learning: Clustering

- Similarity Measures

- Algorithms: K-means

Dimensionality Reduction

- Feature Extraction

- Principal Component Analysis (PCA)

Recommender Systems

- Content-based vs. Collaborative filtering

- Algorithms: k-NN, Matrix Factorization (MF)

Graph Analysis

- Link Analysis

- Algorithms: PageRank

- Example: Ranking (a sample of) the Google Web Graph

Real-time Analytics

- Streaming Data Processing

- Example: Twitter Hate Speech Detector