Database Management Systems


This page has hierarchy - Parent page: Teaching

Table of content

General information

 

Announcements 

  • [17-10-2017] No Laboratory this week. The first laboratory will be held on Wednesday, October 25th, 2017 (TEAM A) and on Thursday, October 26th, 2017 (TEAM B).

Weekly class schedule

16/10/2017 – 20/10/2017

Type Day of the week Time Classroom Topics
Lecture Monday 13:00-16:00 4T Exercises on query optimization: Exercise 1 (Fine) (2 slides per page 6 slides per page); Exercise 2 (Students, Projects) (2 slides per page 6 slides per page) – Introduction to Oracle Optimizer
Practice Wednesday 14:30-16:00 LABINF (map) NO LAB
Lecture Thursday 11:30-13:00 2D Concurrency Control
Practice Thursday 13:00-14:30 LABINF (map) NO LAB
Lecture Friday 14:30-16:00 4D Concurrency Control
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):

  • TEAM A (FROM ABSTREITER TO KRAYEM) on Wednesday from 2.30 pm to 4.00 pm
  • TEAM B (FROM LA ROCCA TO ZOU ) on Thursday from 1.00 pm to 2.30pm

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


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

  • Relational model
  • Relational Algebra
  • SQL language

Material on prerequisites available at the following links

  • “Databases” course (english): link
  • “Basi di dati” course (italian): link

Exercises

Optimizer


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 lab for students who have not completed Practice #1 27/10/2017 27/10/2017  scholarship holder
Practice #2: Oracle triggers 8/11/2017 9/11/2017 assistance lecturer + scholarship holder
Lab for Homework #2 on Oracle triggers 15/11/2017 16/11/2017 scholarship holder
Additional lab for students who have not completed Practice #2 22/11/2017 23/11/2017 unassisted lab
Practice #3: Extended SQL in Oracle 29/11/2017 30/11/2017 assistance lecturer + scholarship holder
Additional 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 assistance lecturer + scholarship holder
Additional 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 assistance 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

  • Text (pdf)
  • Useful scripts
  • Description of the execution plan operations
  • Installing Oracle 11g Express Edition at home
    • To download and install Oracle Express Edition
    • To import the database in Oracle  on your personal Computer
      • Download the following archive empdb2013.zip
      • Extract the database file empdb.dump
      • Download the batch file Oracle-DB-import.bat (for Windows) or the shell script Oracle-DB-import.sh (for Linux) and save it in the same directory in which the empdb.dump file is stored
      • Modify the batch file or the shell script by replacing the keyword password by the password string defined during the Oracle XE installation and (only for the shell script) check the Oracle directory path
      • Please check that tables  EMP e DEPT are not already present. Otherwise, please remove then with the DROP command  (during user creation / workspace Application Express, Oracle automatically creates EMP and DEPT example tables)
      • Execute the batch file or the shell script updated with the correct password

 


Homework to be delivered