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
COURSE PROGRAM AND INFORMATION
Prof. Letizia Tanca details:
- Receiving time: watch PoliSelf, currently Wednesdays 14:30–16:30
- Email: letizia.tanca at polimi.it
- 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.
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.
Some additional materials from past years
Meta-models (by prof. Atzeni)
The semantic web languages by F. Giunchiglia, F. Farazi, L. Tanca, R. De Virgilio (extract from the book “Semantic Web Data management”)
– Data Warehouse Logical Design
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
- (exam 25/01/2011 – problem specification and solution (draft)) Updated on Friday, 14 December 2012
- (exam 13/02/2012 – problem specification and solution (draft))
- (exam 2007 – problem specification and solution)
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.