Database Management Systems

Table of content

General information

 

Announcements 


Weekly class schedule

13/11/2017 – 17/11/2017

Type Day of the week Time Classroom Topics
Lecture Monday 13:00-16:00 4T Distributed databases; Exercises on Triggers
Practice Wednesday 14:30-16:00 LABINF (map) TEAM A – Lab for Homework 2
Lecture Thursday 11:30-13:00 2D Data warehousing: introduction; data warehouse design
Practice Thursday 13:00-14:30 LABINF (map) TEAM B – Lab for Homework 2
Lecture Friday 14:30-16:00 4D Data warehouse design
Lecture Friday 16:00-17:30 LABINF (map) NO LAB

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.

 


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
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

Exercises from written exams


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

 


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 text

Homework Material Deadline Homework deliveries
Homework #1: Query Optimization HW text (pdf) to be delivered by Monday, November 6th, 2017 at 11.59 PM (UTC/GMT+1)
Homework #2: Triggers  HW text (pdf) – Useful scripts.  to be delivered by Monday, November 27th, 2017 at 11.59 PM (UTC/GMT+1)
Homework #3: Data warehouse
Homework #4: Data Mining

 

 



 Parent page 

 Menu 

 © 2017 - DataBase and Data Mining Group