Data Warehousing and Data Mining


This page has hierarchy - Parent page: Teaching

General information

Schedule

Type Day of the week Time Classroom
Lecture Monday 14:30-17:30 10
Lecture Thursday 13:00-16:00 10
Practice Friday 8:30-10:00 LABINF

Announcements

Results for written exam of September 7st, 2012

  • Results for written part
  • The exam discussion and the mandatory oral exam will be Wednesday, September 12th 2012, at 13:00
  • Students who want to reject the exam grade must send an email to Silvia Chiusano and Alessandro Fiori by Friday, September 14th, 2012.

Materials

Data warehousing

  1. Introduction (2 slides per page, 6 slides per page)
  2. Conceptual design (2 slides per page, 6 slides per page)
  3. Logical design (2 slides per page, 6 slides per page)
  4. OLAP analysis (2 slides per page, 6 slides per page)
  5. Physical design (2 slides per page, 6 slides per page)
  6. ETL process (2 slides per page, 6 slides per page)

Oracle

  1. Extended SQL (2 slides per page, 6 slides per page)

Data mining

  1. Introduction to data mining (2 slides per page, 6 slides per page)
  2. Data (2 slides per page, 6 slides per page) NEW Additional slides on data preparation (2 slides per page, 6 slides per page)
  3. Clustering (2 slides per page, 6 slides per page)
  4. Association Rules Fundamentals (2 slides per page, 6 slides per page)
  6. Classification II ( 2 slides per page, 6 slides per page)
  7. Classification III (2 slides per page, 6 slides per page)

Additional material (prerequisites)

  1. Introduction
  2. The Relation Model
  3. Relational algebra and calculus
  4. SQL language fundamentals (2 slides per page, 6 slides per page)
  5. Basic SQL language exercises

Exercises

Exercises from written exams