Data Science and Database Technology (2020/2021)

Table of content

General information

Announcements


Exams

Exam on January 26, 2021


Material

Part I

Oracle

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

 

Part II

Oracle

  1. Oracle Optimizer
    1. Baseline version (2 slides per page6 slides per page)
    2. Extended version with examples (2 slides per page,6 slides per page)
  2. Hints (2 slides per page6 slides per page)
  3. Documentation


 Exercises

Data warehouse

Exercise  Text Draft solution
Extended SQL (Customer ) text Draft solution
Extended SQL (Rental ) text Draft solution
Data warehouse design (Italian household) exercise Draft solution
Data warehouse design (SearchingYourHouse) exercise Draft solution
Data warehouse design (Hotel chain) exercise Draft solution
Data warehouse design (Parcels service) exercise

 

Triggers

Exercise Text Draft solution
Exercise 1 (Athlete) exercise Draft solution
Exercise 2 (Greenhouse) exercise Draft solution
Exercise 3 (Student grant) exercise Draft solution
Exercise 4 (Boat rental) exercise DraftSolBoatRental (timecondition)

Optimizer

Exercise  Text Draft solution
Exercise 1 (Fine) 2 slides per page 6 slides per page Draft Solution
Exercise 2 (Students, Projects) 2 slides per page 6 slides per page Draft Solution
Exercise 3 (Discs) exercise Draft Solution
Exercise 4 (Athletes, Members) 2 slides per page 6 slides per page  Draft Solution

Exercises from written exams

AA 2015-2016

Exam Draft solution
Exam (23-02-2016) optimizer, dw, trigger
Exam (2016-01-27) optimizer, dw, trigger

AA 2011-2012

Exam Draft solution
Exam (2012-02-06) optimizer and dwtrigger
Exam (2012-02-28) optimizer and dw
Exam (2012-06-21) optimizer and dwtrigger
Exam (2012-09-07) optimizer and dw

AA 2010-2011

Exam Draft solution
Exam (2011-02-07) optimizer-trigger-dw
Exam (2011-02-22)
Exam (2011-07-08) optimizer, trigger
Exam (2011-09-21) optimizer, trigger

 


Tutoring sessions

 


Practices

LAB SCHEDULE. 
TEAM A (FROM A TO G) on Monday from 2.30pm to 4pm
TEAM B (FROM H TO Z) on Monday from 4pm to 5.30pm

Lab calendar

Topic Team A (2:30-4pm)

Team B (4-5:30pm)

Lab Assistance
Practice #1: Extended SQL in Oracle  19/10/2020 assistant lecturer
Practice #2: Data warehousing  26/10/2020 assistant lecturer
Lab for Homework #1 –  Data warehousing + Tutoring session  2/11/2020 scholarship holder
Practice #3: Data mining with Rapidminer  9/11/2020 assistant lecturer
Lab for Homework #2 on data mining with Rapidminer + Tutoring session  16/11/2020 scholarship holder
Practice #4: Oracle triggers  23/11/2020 assistant lecturer
Lab for Homework #3 on triggers in Oracle + Tutoring session  30/11/2020 scholarship holder
Practice #5: Oracle optimizer  14/12/2020 assistant lecturer
Practice #6: MongoDB  11/01/2021 assistant lecturer

 

Lab 1: Extended SQL

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

Lab 3: Data mining – Rapid Miner  

Lab 4: Triggers

Lab 5: The Oracle Optimizer

Lab 6: NoSQL in MongoDB


Homework to be delivered

 

To obtain the points associated with the homeworks, students have to observe the following terms:

Homework discussion: Students attending the written exam must bring the following items:

Homework deliveries:

Homework submissions : list of delivered submissions. In case of any incongruencies or missing delivery, send an email to eliana.pastor@polito.it.

 

Homework Material Deadline Homework deliveries
Homework #1: Data warehouse HW text (pdf)

[NEW] Updated (b) ii

to be delivered by Sunday, November 08th, 2020 at 11.59 PM (UTC/GMT+1)
Homework #2: Data Mining HW text (pdf) – Dataset (breast.xls) to be delivered by Monday, November 23th, 2020 at 11.59 PM (UTC/GMT+1)
Homework #3: Triggers HW text (pdf) –  scripts. to be delivered by Monday, December 7th, 2020 at 11.59 PM (UTC/GMT+1)
Homework #4: Query Optimization HW text (pdf) [Updated having COUNT(*)>1] to be delivered by Thursday, January 7th, 2021 at 11.59 PM (UTC/GMT+1)

 


 Parent page 

 Menu 

 © 2021 - DataBase and Data Mining Group