- 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 Information Technology (cod. 8013)
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.
Links to further information
http://bias.csr.unibo.it/golfarelli/
Office hours
See the website of Matteo Golfarelli
See the website of Alessandra Lumini