Data Science and Database Technology

Table of content

General information

Announcements


Exams


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
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
Exercise 2 (Students, Projects) 2 slides per page 6 slides per page
Exercise 3 (Discs) exercise
Exercise 4 (Athletes, Members) 2 slides per page 6 slides per page

 

 

Exercises from written exams

 

AA 2015-2016

Exam Draft solution
Exam (23-02-2016)
Exam (2016-01-27)

AA 2011-2012

Exam Draft solution
Exam (2012-02-06)
Exam (2012-02-28)
Exam (2012-06-21)
Exam (2012-09-07)

AA 2010-2011

Exam Draft solution
Exam (2011-02-07)
Exam (2011-02-22)
Exam (2011-07-08)
Exam (2011-09-21)

 

 

 

 


Tutoring sessions

 


 

Practices

Topic Team A Team B Lab Assistance
Practice #1: Extended SQL in Oracle  21/10/2019  25/10/2019 assistant lecturer
Practice #2: Data warehousing  28/10/2019  8/11/2019 assistant lecturer
Practice #3: Data mining with Rapidminer 11/11/2019 15/11/2019 assistant lecturer
Lab for Homework #2 on data mining with Rapidminer 18/11/2019 22/11/2019 scholarship holder
Practice #4: Oracle triggers 25/11/2019 29/11/2019 assistant lecturer
Lab for Homework #3 on triggers in Oracle 2/12/2019 6/12/2019 scholarship holder
Practice #5: Oracle optimizer  16/12/2019 [NEW]  13/12/2019 assistant lecturer
Practice #6: MongoDB  13/01/2020 [NEW]  10/01/2020 assistant lecturer

LAB SCHEDULE. To fit LabInf capacity students must attend all the course labs according to the following schedule (students are sorted in alphabetic order by surname):

The compliance to the schedule above is necessary to guarantee the feasibility of the lab.

LAB ACCOUNT. Please make sure to have an account on the LABINF PCs before the beginning of the lab practice (the accounts used to log in to the PCs of the other LAIBs are *not* valid). To register an account at LABINF, please visit the Labinf  website for further information.

 

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


 

 


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 Material Deadline Homework deliveries
Homework #1: Data warehouse HW text (pdf) to be delivered by Sunday, November 10th, 2019 at 11.59 PM (UTC/GMT+1)
Homework #2: Data Mining HW text (pdf) – Dataset (breast.xls) to be delivered by Sunday, November 24th, 2019 at 11.59 PM (UTC/GMT+1)
Homework #3: Triggers HW text (pdf) –  scripts. to be delivered by Sunday, December 8th, 2019 at 11.59 PM (UTC/GMT+1)

 

 


 Parent page 

 Menu 

 © 2019 - DataBase and Data Mining Group