Information Management
A.Y. 2019/2020
Learning objectives
The objective of this course is to introduce advanced concepts for information management in modern information systems. The course will also introduce basic data mining techniques.
Expected learning outcomes
The student will have knowledge of transaction management in centralized and distributed relational databases. The student will also be able to design a data warehouse, and to use main data mining techniques for knowledge extraction. The student will know the most relevant characteristics of NoSQL DBMSs and of modern distributed computation paradigms.
Lesson period: Second semester
Assessment methods: Esame
Assessment result: voto verbalizzato in trentesimi
Single course
This course cannot be attended as a single course. Please check our list of single courses to find the ones available for enrolment.
Course syllabus and organization
Single session
Responsible
Lesson period
Second semester
Course syllabus
1. Transaction management: ACID properties, failure management, concurrency control.
2. Distributed databases: fragmentation and allocation, transaction management in distributed scenarios, distributed queries.
3. Data warehousing: ETL, conceptual, logical, and physical modeling
4. Data mining techniques: itemset mining, classification, clustering.
5. NoSQL: data models, distribution models, consistency and ACID properties, distributed computation
2. Distributed databases: fragmentation and allocation, transaction management in distributed scenarios, distributed queries.
3. Data warehousing: ETL, conceptual, logical, and physical modeling
4. Data mining techniques: itemset mining, classification, clustering.
5. NoSQL: data models, distribution models, consistency and ACID properties, distributed computation
Prerequisites for admission
Knowledge of ER model and of the relational data model.
Basic knowledge of SQL.
Basic knowledge of SQL.
Teaching methods
Frontal lessons
Teaching Resources
Web site:
http://sforestiim.ariel.ctu.unimi.it/
Slides and reading lists made available on the course web site.
http://sforestiim.ariel.ctu.unimi.it/
Slides and reading lists made available on the course web site.
Assessment methods and Criteria
The exam is a written test of 2.00 hours, including open questions and exercises.
The exam aims at evaluating the comprehension and knowledge of the main concepts related to transaction management, data distribution, and data analysis for decision support. The exam also aims at evaluating the ability of using and applying the studied techniques.
The evaluation is expressed on a 1-30 scale.
The results of the exams are available on the Ariel web page of the course.
The exam aims at evaluating the comprehension and knowledge of the main concepts related to transaction management, data distribution, and data analysis for decision support. The exam also aims at evaluating the ability of using and applying the studied techniques.
The evaluation is expressed on a 1-30 scale.
The results of the exams are available on the Ariel web page of the course.
INF/01 - INFORMATICS - University credits: 6
Lessons: 48 hours
Professor:
Foresti Sara
Shifts:
-
Professor:
Foresti SaraProfessor(s)