Information Management
A.Y. 2023/2024
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
Insegnamento non erogato nel 2023/24
Lesson period
Second semester
Course syllabus
1. Distributed databases: fragmentation and allocation, transaction management in distributed scenarios, distributed queries.
2. Data warehousing: ETL, conceptual, logical, and physical modeling
3. Data mining techniques: itemset mining, classification, clustering.
4. NoSQL: data models, distribution models, consistency and ACID properties, distributed computation
2. Data warehousing: ETL, conceptual, logical, and physical modeling
3. Data mining techniques: itemset mining, classification, clustering.
4. 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 hours, including open questions and exercises.
The exam aims at evaluating the comprehension and knowledge of the main concept related to data distribution, data analysis for decision support, and NoSQL. The exam also aims at evaluating the ability of using and applying the studied techniques.
The exam is closed book.
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 concept related to data distribution, data analysis for decision support, and NoSQL. The exam also aims at evaluating the ability of using and applying the studied techniques.
The exam is closed book.
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
Educational website(s)