Technologies for Information Systems

This page  contains materials for the academic year 2014-2015, whose contents are similar  (but not equal) to the current course syllabus. Please refer to the Beep site for up-to-date information



Prof. Letizia Tanca details:

  • Receiving time: watch PoliSelf, currently Wednesdays 14:3016:30
  • Email: letizia.tanca at
  • phone: 02 2399 3531, fax: 02 2399 3411
  • The personal web site also contains information on my group’s research interests, for students who are interested in projects and theses.

some exams with both theory and exercises

COURSE OBJECTIVES We are in the era of large, decentralized, distributed environments where the amount of devices and data and the heterogeneity thereof is getting out of control. Gartner reports that worldwide information volume is growing at a minimum rate of 59% annually. Organizations capture billions of bytes of data about their customers, suppliers and operations, but their ability to collect, manage and interpret this information could be an obstacle to its use. The web is widening the range of data providers and consumers. Nowadays, many events can be recorded within organizations generating a never-ending sea of data. Decision-making is based on information, not in just on data. More accurate information leads to better decisions and gives competitive advantages to companies. Hence, processing, manipulating, and organizing data in a way that adds new knowledge to the person or organization receiving it has become a necessary topic. This course gives an overview of some of the most advanced methodologies adopted to solve the conceptual and technological problems encountered in modern information system design and operation, spanning from the currently consolidated methodologies to the most advanced ones.

CLASS HOURS: 30 lecture hours; 20 exercise session hours

FURTHER INFORMATION The exam consists of written  exercises and questions on the theoretical topics discussed in the course lectures

PREREQUISITES: Data bases I and Data bases II

NOTE ON THE BIBLIOGRAPHY: The  bibliography includes useful references and is by no means exhaustive of the topics covered in the course. More readings will be mentioned during the lectures. The students are advised to attend the lectures, ask the professor for explanations and read the articles. For each of the books, only the part included in the lectures is mandatory.



  • M. Lenzerini, Data Integration: A Theoretical Perspective, Proceedings of ACM PODS, pp. 233-246, Editore: ACM,  2002, ISBN: 1-58113-507-6 This is a scientific paper published in a volume of Conference proceedingsRoberto
  • De Virgilio, Fausto Giunchiglia, Letizia Tanca (Eds.): Semantic Web Information Management – A Model-Based Perspective. Springer 2009, ISBN 978-3-642-04328-4
  • M. Golfarelli, S. Rizzi, Data Warehouse Design: Modern Principles and Methodologies, Editore: McGraw Hill, Anno edizione: 2009, ISBN: 0071610391
  • Clement T. Yu, Weiyi Meng, Principles of Database Query Processing for Advanced Applications , Editore: Morgan Kaufmann, Anno edizione: 1998, ISBN: 1558604340
  • Snodgrass R., Ahn I., Temporal Databases – IEEE Computer, Editore: IEEE, Anno edizione: 1986, Fascicolo: vol. 19, n. 9, pp. 35-42  
  • Jensen C.S. and Dyreson C.E. (eds.)., A consensus glossary of temporal database concepts – February 1998 version. , Editore: Springer, Anno edizione: 1998 In Temporal Databases: Research and Practice, O. Etzion, S. Jajodia, S. Sripada (eds.) LNCS 1399, Springer, pp. 367-405.
  • Schreiber F.A., Is Time a Real Time? An Overview of Time Ontology in Informatics , Editore: Springer, Anno edizione: 1994 in W.A. Halang, A.D. Stoyenko (Eds.) – Real Time Computing – , Springer Verlag NATO-ASI Vol. F127, pp. 283-307
  • Pang-Ning Tan, Michael Steinbach, Vipin Kumar, Introduction to Data Mining , Editore: Addison-Wesley, Anno edizione: 2006, ISBN: 0321321367 The web site above contains a lot of interesting material

Some additional materials from past years


Meta-models (by prof. Atzeni)

W3C tutorial on the Semantic Web

The semantic web languages by F. Giunchiglia, F. Farazi, L. Tanca, R. De Virgilio (extract from the book “Semantic Web Data management”)

Data Warehouse – (Oracle datawarehouse)

– Data Warehouse Logical Design

Data Mining and its Applications

Time Ontology

Temporal Databases

Context-aware databases – SEMINAR  (slides) EXERCISES:

Data integration – exercise (exam 28/02/2012 (problem specification)solution (draft))

Data integration – exercise 3 (slides)

Data integration – exercise 4 (problem specification and slides)

Data warehousing – exercise 5 – Conceptual design (slides) Updated on Monday, 26 November 2012

Data warehousing – exercise 6 – Conceptual design

Data warehousing – exercise 7 – SQL queries (slides)



– Course completely offered in English – Study materials/slides available in English – Bibliography available in English – It is possible to take the examination in English – Support available in English It is possible for the students to develop a project on the course  topics, under the guidance of the Technologies for Information Systems’ teachers, within the course Pervasive Data Management. Look at the research art of this site for available topics.