Data management and visualization


This page has hierarchy - Parent page: Teaching

Table of content

General information

  • ECTS: 8
  • Professors: Silvia Chiusano, Daniele Apiletti, Marco Torchiano
  • Assistant lecturers: Eliana Pastor, Moreno La Quatra, Diego Monti, Martino Trevisan
  • Exam rules

Material

Data Warehousing

  • Data warehouse: introduction (slides)
  • Data warehouse: conceptual and logical design (slides)
  • Data warehouse: materialized view, ETL process (slides)
  • Data warehouse: analysis (slides)
  • Data warehouse: Extended SQL in Oracle (slides)
  • Data warehouse: physical design (slides)

 

Exercise  Text Draft solution
Extended SQL (Customers) text
Extended SQL (Rentals) – updated 10-10-2019 text
Data warehouse design (storehouses) text
Data warehouse design (SearchingYourHouse) text
Data warehouse design (Hotel chain) text
Data warehouse design (Parcels service) text
Data warehouse design (PC store) text

Non-relational Databases

  • NoSQL introduction and document-based DBMS (slides)
  • MongoDB intro and query (slides)
  • MongoDB operations (slides)
  • Map Reduce (slides)
  • Distributed transactions (slides)
  • A NoSQL transaction design recipe (slides)
  • Distributed Data Management – replication, CAP, and conflicts (slides)

Data Visualization

 


Laboratory practice

Practice in Lab starts on Wednesday, October 23rd, 2019. There will be NO practice before.

Since Oct 23rd, all Wednesdays from 13:00 to 14:30 at Labinf there will be a new practice with assistant lecturers.

Students must own an active account to access the Labinf (see registration instructions on Labinf website).

Lab 1: Extended SQL

    • Data warehouse tables in csv format (zip)
    •        FOR STUDENTS WHO WANT TO PRACTICE AT HOME WITH EXTENDED SQL:
      • to import tables using Oracle SQL Developer: Import data (right click on “Tables” of “Connection” Tab)
      • (alternatively) to import tables from the Oracle XE Web interface: select Home>Utilities>Data Load/Unload>Load>Load Text Data->)
  • Installing Oracle 11g Express Edition at home
  • LABINF – Oracle SQL Developer English language: RUN (cmd), “%APPDATA%\sqldeveloper“, folder of the Oracle version (19.1.0), Add “addVMOption -Duser.language=en” in the product.conf file
  • Draft solution of queries 1-5 and materialized view (pdf) and DW design

Lab 2: Extended SQL

    • Text – Additional queries   (pdf)

Lab 3: Data-warehouse analytics and reporting with Google Data Studio

Lab 4: NoSQL in MongoDB Compass

Lab 5: NoSQL in MongoDB

    • Text (pdf)
    • Collection (txt)
    • Docker (file) note: yml/yaml extension
    • Solution (pdf)

Lab 6: Visualization analysis

Lab 7: Redesign with Tableau

Lab 7: Visualization of a dataset