28796 - Elements of Databases

Course Unit Page


This teaching activity contributes to the achievement of the Sustainable Development Goals of the UN 2030 Agenda.

Quality education Gender equality Decent work and economic growth Industry, innovation and infrastructure

Academic Year 2021/2022

Learning outcomes

At the end of the course the student: - knows the semi structured and unstructured data models in relationship with the central constructors of SQL/XML and XQuery; - knows the basic techniques of information retrieval and text analysis; - is capable of designing and developing a datawarehouse; - is capable of conducting a project using the basic data mining techniques

Course contents

  • Structured, unstructured and semi structured data models.
  • The limits of SQL
  • An introduction to SQL/XML and XQuery
  • The information retrieval models (boolean and vectors space) and web information retrieval (PageRank)
  • The datawarehousing (OLAP) and data mining (Machine Learning)


  • A. Moller et al - Introduzione a XML - Addison Wesley, 2007 ISBN: 9788871923734
  • R. Baeza-Yates et al – Introduction to Information Retrieval - Cambridge University Press, 2008 ISBN: 0521865719
  • C. D. Manning et al - Introduction to data mining Addison Wesley, 2006 ISBN: 0321420527
  • M. Golfarelli et al - Datawarehouse - Teoria e pratica della progettazione - McGrawHill, 2006 ISBN: 9788838662911

Teaching methods

During the course lessons, we will discuss several issues related to the semi structured data and unstructured data management.

Assessment methods

In order to take part in an exam session, you must register on Almaesami before 7 days of the exam date. Those who do not enrol in time will not be able to take the exam, and will have to wait for the next date.

The assessment takes place with the discussion of a project or the discussion of an article. The student can choose whether to make a project or study an article.

  • Project: the student, after the instructor's approval, carries out a project on a topic of the course. The results of the project will have to be discussed during the exam through presentation slides prepared by the student.
  • Article: the student explore an advanced topic starting from a research paper among those proposed. The content of the paper and the related topic must be discussed during the exam through presentation slides prepared by the student.

Useful links for the assessment:

  • Instructor's folder with papers to choose from: Google Drive link
  • Registration form of the project/article and further instructions for the submission: Link to the form

Teaching tools

Instructor's folder with slides and useful material: Google Drive link

Links to further information


Office hours

See the website of Danilo Montesi