Database Management Systems

Table of content

General information

 

Announcements

 



Exams

Exam rules

 

 


Materials

Part I

Database System Technology

  1. Introduction to DBMS (2 slides per page6 slides per page)
  2. Buffer Manager (2 slides per page,  6 slides per page)
  3. Physical access to data (2 slides per page6 slides per page)
  4. Query optimization  (2 slides per page6 slides per page)
  5. Physical design  (2 slides per page6 slides per page)
  6. Concurrency Control (2 slides per page6 slides per page)
  7. Reliability Management (2 slides per page6 slides per page)
  8. Triggers  (2 slides per page6 slides per page)
  9. Distributed databases  (2 slides per page6 slides per page)
  10. Beyond relational databases (2 slides per page6 slides per page)
  11. Introduction to Big Data (2 slides per page , 6 slides per page)

 

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

 

Part II

Data warehousing

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

Data mining

Prerequisites

Material on prerequisites available at the following links


Exercises

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) Text  
Exercise 4 (Athletes, Members) 2 slides per page 6 slides per page  

Triggers

Exercise  Text Draft solution
Exercise 1 (Athlete ranking, Boat rental) 2 slides per page 6 slides per page DraftSolAthleteRanking DraftSolBoatRental (timecondition)
Exercise 2 (Greenhouse) 2 slides per page 6 slides per page DraftSolutionGreenhouse
Exercise 3 (Student grant) 2 slides per page 6 slides per page DraftSolutionStudentGrant

Data warehouse

Exercise  Text Draft solution
Extended SQL (Customer )  text DraftSolutionCustomer 
Extended SQL (Rental ) text  
Data warehouse design (Italian household) exercise  Remark: Write all queries from (a) to (f) DraftSolutionItalianHousehold
Data warehouse design (SearchingYourHouse) exercise DraftSolutioSearchingYourHouse

 


Exercises from written exams

AA 2015-2016

Exam Draft solution
Exam (23-02-2016)
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


Practices

Practices schedule

Topic Team A Team B Lab Assistance
Practice #1: Oracle optimizer  25/10/2017  26/10/2017 assistant lecturer + scholarship holder
Additional optional lab for students who have not completed Practice #1 27/10/2017 3/11/2017 scholarship holder
Practice #2: Oracle triggers 8/11/2017 9/11/2017 assistant lecturer + scholarship holder
Lab for Homework #2 on Oracle triggers 15/11/2017 16/11/2017 scholarship holder
Additional optional lab for students who have not completed Homework #2 22/11/2017 23/11/2017 unassisted lab
Practice #3: Extended SQL in Oracle 29/11/2017 30/11/2017 assistant lecturer + scholarship holder
Additional optional lab for students who have not completed Practice #3 6/12/2017 7/12/2017 unassisted lab
Practice #4: Data warehousing 13/12/2017 14/12/2017 assistant lecturer + scholarship holder
Additional optional lab for students who have not completed Practice #4 20/12/2017 21/12/2017 scholarship holder
Practice #5: Data mining with Rapidminer 10/1/2018 11/1/2018 assistant lecturer + scholarship holder
Lab for Homework #4 on data mining with Rapidminer 17/1/2018 18/1/2018 scholarship holder

 

Lab 1: The Oracle Optimizer

 

Lab 2: Triggers

 

Lab 3:Extended SQL

 

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

Lab 5: Data mining – Rapid Miner  

 


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:

 

 

 


 Parent page 

 Menu 

 © 2018 - DataBase and Data Mining Group