- Docente: Matteo Golfarelli
- Credits: 6
- SSD: ING-INF/05
- Language: Italian
- Moduli: Matteo Golfarelli (Modulo 1) Alessandra Lumini (Modulo 2)
- Teaching Mode: Traditional lectures (Modulo 1) Traditional lectures (Modulo 2)
- Campus: Cesena
- Corso: First cycle degree programme (L) in Computer Science and Engineering (cod. 8615)
Learning outcomes
The course allows the student to deepen its knowledge of databases
and improves her practical capabilities concerning DBMS.
Course contents
Database admininstration
Logical and phisical DBMSarchitecture
Resourses optimization
The data dictionary
Security issues
Advanced programming with database systems
Advanced SQL
Active DB and Trigger
Stored procedure
Performance optimization
The optimization process for a SQL query
Relation DBMS: the physical level
Optimiazion techniques
Understanding the execution plan
Computing the execution cost for an SQL
query
Readings/Bibliography
Teacher slides
R. van der Lans Introduzione a SQL . Addison-Wesley, 2001.
R. A. Elmasri, S.B. Navathe. Sistemi di basi di dati - Complementi.
Pearson, 2005.
Teaching methods
Oral lessons and practical exercises
Assessment methods
Two written tests. The first one is carried out on the PC and
evaluates the student practical capabilities (the user can use
books and slides). The second one is a set of open questions on all
the course program.
An option project to be agreed on with the teacher will give
addition points.
Teaching tools
Exercises will be carried out using Oracle DBMS 11g
Links to further information
http://bias.csr.unibo.it/golfarelli/LabDB
Office hours
See the website of Matteo Golfarelli
See the website of Alessandra Lumini