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

Non-relational Databases

  • (material will be available here)

Data Visualization

  • (material will be available here)

 


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