ID:
509495
Durata (ore):
56
CFU:
6
SSD:
INFORMATICA
Anno:
2024
Dati Generali
Periodo di attività
Primo Semestre (30/09/2024 - 20/01/2025)
Syllabus
Obiettivi Formativi
Data now pervades our world. Almost all human activities today either produce data or require access to data. In this sense, solutions are necessary to enable the storage, maintenance, retrieval, and extraction of large amounts of data effectively and efficiently. Data management systems are precisely concerned with this. The aim of this course is to introduce students to the fundamental concepts of data management, teach good database design principles, enable students to acquire skills in constructing complex queries, and design long-term analytics-based storage systems to perform tasks related to business intelligence.
The course will focus on relational databases and data warehouses based on ROLAP, given that the relational model currently forms the foundation of most data management systems used in the industry. The relational model is the most studied data model and boasts the largest number of commercial tools currently active on the market.
The course will focus on relational databases and data warehouses based on ROLAP, given that the relational model currently forms the foundation of most data management systems used in the industry. The relational model is the most studied data model and boasts the largest number of commercial tools currently active on the market.
Prerequisiti
Formally, the course does not have any prerequisites. However, a solid understanding of fundamental concepts in data structures and algorithms is strongly recommended, so that the student can more easily grasp the concepts presented during the course.
Metodi didattici
The course will offer a series of lectures. Theoretical concepts will be presented using slides or a whiteboard. During and after the lecture, the instructor will answer students' questions, and the presented material will be discussed.
Some lectures will be dedicated to exercises, which aim to highlight how the acquired theoretical concepts should be applied in a practical context.
Students are expected to study the presented material at their own pace, using the slides and the textbook. They should also attempt to solve some of the exercises proposed in the book. Solutions to these exercises can be found at the end of the textbook.
The course also includes the assignment of some tasks to be completed by students outside of class time, with deadlines for submission. The objective of these assignments is to allow students to apply the acquired concepts in practice. It should be noted that the course is practical in nature, meaning that completing the assignments is mandatory for passing the exam. It makes little sense to study data and knowledge bases without ever implementing some of the acquired theoretical concepts. This is similar to studying a programming language without ever writing and executing a program in that language.
Some lectures will be dedicated to exercises, which aim to highlight how the acquired theoretical concepts should be applied in a practical context.
Students are expected to study the presented material at their own pace, using the slides and the textbook. They should also attempt to solve some of the exercises proposed in the book. Solutions to these exercises can be found at the end of the textbook.
The course also includes the assignment of some tasks to be completed by students outside of class time, with deadlines for submission. The objective of these assignments is to allow students to apply the acquired concepts in practice. It should be noted that the course is practical in nature, meaning that completing the assignments is mandatory for passing the exam. It makes little sense to study data and knowledge bases without ever implementing some of the acquired theoretical concepts. This is similar to studying a programming language without ever writing and executing a program in that language.
Verifica Apprendimento
The final mark for the course is obtained by summing the total marks obtained at the 3 assignments (which, as mentioned, are mandatory) and the final written exam. Each assignment accounts for 4/30 points, for a total of 12. The remaining 18/30 points will be assigned through the final written exam. To successfully pass the course, the sum of all assignment marks and the final written exam mark must be equal to or greater than 18.
The students have a *single* chance to take the assignments, and that is during the semester in which the course is given. The marks the students get at the assignment will be valid throughout the whole academic year (and also for future iterations of the course, unless important changes to the course are applied for future editions). On the other hand, the written exam (accounting for the remaining 18/30 points), will be scheduled throughout the year as a standard exam. Whenever a student takes the written exam, the mark from the previous written exam will no longer be valid, unless the student decides to withdraw during the exam.
If a student has not completed the assignments during the semester, they will have the opportunity to obrain the missing 12/30 points during the written exam by taking an additional test, after completing the written exam.
It should be noted that this additional test will be particularly challenging, as students will be required to demonstrate their acquired skills on the material from the entire semester within just 2-3 hours. It is therefore strongly advised not to rely on this option.
As already said above, students who have completed the 3 assignments during the semester, can keep the marks from the assignments even for the upcoming years. However, this does not happen automatically. Students must send an email to the lecturer, at the beginning of the course semester to have their assignment marks transferred from the previous year. It should also be noted that the transfer of marks can only be done for all three assignments, not for part of them. This means, for example, that a student cannot keep the mark from just one assignment and then retake the other two.
[Late Submission of Assignments] For each assignment submitted after the deadline, the student will receive 0 points for that assignment.
The students have a *single* chance to take the assignments, and that is during the semester in which the course is given. The marks the students get at the assignment will be valid throughout the whole academic year (and also for future iterations of the course, unless important changes to the course are applied for future editions). On the other hand, the written exam (accounting for the remaining 18/30 points), will be scheduled throughout the year as a standard exam. Whenever a student takes the written exam, the mark from the previous written exam will no longer be valid, unless the student decides to withdraw during the exam.
If a student has not completed the assignments during the semester, they will have the opportunity to obrain the missing 12/30 points during the written exam by taking an additional test, after completing the written exam.
It should be noted that this additional test will be particularly challenging, as students will be required to demonstrate their acquired skills on the material from the entire semester within just 2-3 hours. It is therefore strongly advised not to rely on this option.
As already said above, students who have completed the 3 assignments during the semester, can keep the marks from the assignments even for the upcoming years. However, this does not happen automatically. Students must send an email to the lecturer, at the beginning of the course semester to have their assignment marks transferred from the previous year. It should also be noted that the transfer of marks can only be done for all three assignments, not for part of them. This means, for example, that a student cannot keep the mark from just one assignment and then retake the other two.
[Late Submission of Assignments] For each assignment submitted after the deadline, the student will receive 0 points for that assignment.
Testi
For the database part, the course will be mostly following the book Raghu Ramakrishnan, Johannes Gehrke, "Database Management Systems", while for the Data warehouse part will be mostly following the book Matteo Golfarelli, Stefano Rizzi, "Data Warehouse Design - Modern Principles and Methodologies".
Besides the above two books, the lecturer will also provide additional material such as slides and exercises.
Besides the above two books, the lecturer will also provide additional material such as slides and exercises.
Contenuti
The course will cover the following topics:
Database design and querying:
- Overview of Database Management Systems
- Conceptual design of databases: Entity-Relationship Diagrams
- The Relational Model, and logical design of databases
- Database Querying: Relational Algebra and SQL
- PostgreSQL
Data Warehouse and association mining:
- Overview of data warehouse architectures
- Conceptual design: the Dimensional Fact Model
- Fact schemas: star and snowflake schemas
- (Materialized) views and querying
- Frequent itemset and association rule mining
Database design and querying:
- Overview of Database Management Systems
- Conceptual design of databases: Entity-Relationship Diagrams
- The Relational Model, and logical design of databases
- Database Querying: Relational Algebra and SQL
- PostgreSQL
Data Warehouse and association mining:
- Overview of data warehouse architectures
- Conceptual design: the Dimensional Fact Model
- Fact schemas: star and snowflake schemas
- (Materialized) views and querying
- Frequent itemset and association rule mining
Lingua Insegnamento
INGLESE
Altre informazioni
The name of the course has been recently changed to "Data and Knowledge Bases", however, due to regulations, the formal title of the course will remain "Data Mining & Knowledge Extraction" until 2026.
Corsi
Corsi
ARTIFICIAL INTELLIGENCE
Laurea
3 anni
No Results Found
Persone
Persone
Docente
No Results Found