Databases and WEB (2020/2021)

Course code
Barbara Oliboni
Academic sector
Language of instruction
Teaching is organised as follows:
Activity Credits Period Academic staff Timetable
Teoria 3 II semestre Barbara Oliboni

Go to lesson schedule

Laboratorio 3 II semestre Sara Migliorini

Go to lesson schedule

Learning outcomes

The purpose of the course is to introduce the methodologies and technologies for the design and im-plementation of data-centric web sites, and the approaches specific to storage and query bioinfor-matics data. The course includes a lab module where students learn to working with a database management system and developing web applications exploiting databases. The students will learn how to use Python programming language, which is at the bases of the main technologies studied in the lab module.


Theory Module
- The internal architecture of a database management system:
-- Sequential data structures and indexes (B-trees and hashing)
-- Transactions.
- Semistructured data models: XML for bioinformatics.

Laboratory Module
- Introduction to the relational database management system (RDBMS) PostgreSQL.
- Introduction to the use of SQL in PostgreSQL.
- Query Optimization.
- Introduction to the transaction.
- Database access from applications written in Java/Python.

Assessment methods and criteria

The exam is composed of two parts: theory and laboratory.

To pass the exam, the student must show that:
- they are able to apply the acquired knowledge to design and implement an application that interacts with a database;
- they are able to describe the concepts in a clear and exhaustive way;
- they are able to apply the acquired knowledge to solve application scenarios described by means of questions and exercises.

Theory Module
Written exam composed of questions and exercises on the theory topics.

Laboratory Module
Written exam composed of exercises on the theory topics.

Final grade will be the mean value of theory exam and lab exam grades.

Reference books
Activity Author Title Publisher Year ISBN Note
Teoria Paolo Atzeni, Stefano Ceri, Piero Fraternali, Stefano Paraboschi, Riccardo Torlone Basi di dati (Edizione 5) McGraw Hill 2018 9788838694455
Laboratorio Sara Migliorini Materiale fornito in laboratorio