28796 - Elements of Databases

Academic Year 2017/2018

  • Teaching Mode: Traditional lectures
  • Campus: Bologna
  • Corso: Second cycle degree programme (LM) in Computer Science (cod. 8028)

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). Text analysis. The dataware housing (OLAP) and data mining (Machine Learning e Deep Learning).

Readings/Bibliography

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

Project. Project submission form can be found here: https://goo.gl/forms/xQ5eiHVjbE15gYGX2 .

Teaching tools

Instructor slides.

Office hours

See the website of Danilo Montesi