Strumenti Utente

Strumenti Sito


mds:dsd:start

Differenze

Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.

Link a questa pagina di confronto

Entrambe le parti precedenti la revisioneRevisione precedente
Prossima revisione
Revisione precedente
mds:dsd:start [13/11/2025 alle 20:06 (10 mesi fa)] – [Exams] Salvatore Ruggierimds:dsd:start [26/08/2026 alle 13:20 (3 giorni fa)] (versione attuale) – [Class calendar] Salvatore Ruggieri
Linea 1: Linea 1:
 ====== Decision Support Systems - Module I (6 ECTS): Decision Support Databases A.Y. 2025/26 ====== ====== Decision Support Systems - Module I (6 ECTS): Decision Support Databases A.Y. 2025/26 ======
  
-This is the first module of [[mds:dss:start|Decision Support Systems]] (801AA, 12 ECTS), previously called [[mds:dsd:2021|Decision Support Databases]] (662AA, 6 ECTS). +This is the first module of [[mds:dss:start|Decision Support Systems]] (801AA, 12 ECTS), previously called Decision Support Databases (662AA, 6 ECTS). 
  
  
Linea 58: Linea 58:
  
 ^  Date  ^  Hour  ^  Room  ^  Notes  ^ ^  Date  ^  Hour  ^  Room  ^  Notes  ^
-|  8/1/2026  |  14:00 - 16:00  |  TBD    | +|  15/7/2026  |  14:00 - 16:00  |  Fib-L1    | 
-|  29/1/2026  |  9:00 - 11:00  |  Fib-L1|   |+|  2/9/2026  |  11:00 - 13:00  |  TBD  |   |
  
 =====Class calendar ===== =====Class calendar =====
Linea 69: Linea 69:
 Slides and other material might be updated **after the classes** to align with actual content of lessons and to correct typos. Be sure to download the updated versions. Slides and other material might be updated **after the classes** to align with actual content of lessons and to correct typos. Be sure to download the updated versions.
  
 +If the direct links to recordings do not work, see [[https://unipiit-my.sharepoint.com/:f:/g/personal/a009340_unipi_it/IgBZtXSOyAVSRq4YreeqY-HiAdJYwJJ-MuG21B2SuYFfgfk?e=t0m09Z|this folder (requires @unipi authentication)]].
  
 ^ # ^ Date ^ Room ^ Topic ^ Mandatory teaching material ^  ^ # ^ Date ^ Room ^ Topic ^ Mandatory teaching material ^ 
Linea 93: Linea 94:
 |21| 06/11 11-13  | Fib-C | Recalls of functional dependency properties and how they are used to reason about the properties of the result of a query. Properties of the group-by operator.   [[http://131.114.72.230/dsd/video/dsd21_20221130.mp4|rec21 (.mp4)]] | **[DW: 8.1-8.2, DB: 3.5.1-3.5.4]**  {{:mds:dsd:dsd21.pdf|slides21 (.pdf)}} | |21| 06/11 11-13  | Fib-C | Recalls of functional dependency properties and how they are used to reason about the properties of the result of a query. Properties of the group-by operator.   [[http://131.114.72.230/dsd/video/dsd21_20221130.mp4|rec21 (.mp4)]] | **[DW: 8.1-8.2, DB: 3.5.1-3.5.4]**  {{:mds:dsd:dsd21.pdf|slides21 (.pdf)}} |
 |22| 07/11 9-11  | Fib-C | The problem of evaluating the group-by before the join operator. First case: Invariant grouping. Examples. Other cases: double grouping, grouping and counting. Examples with star join queries.  [[http://131.114.72.230/dsd/video/dsd22_20221201.mp4|rec22 (.mp4)]] | **[DW: 8.3-8.6]**  {{:mds:dsd:dsd22.pdf|slides22 (.pdf)}} | |22| 07/11 9-11  | Fib-C | The problem of evaluating the group-by before the join operator. First case: Invariant grouping. Examples. Other cases: double grouping, grouping and counting. Examples with star join queries.  [[http://131.114.72.230/dsd/video/dsd22_20221201.mp4|rec22 (.mp4)]] | **[DW: 8.3-8.6]**  {{:mds:dsd:dsd22.pdf|slides22 (.pdf)}} |
-|MT1| 07/11 16-18| Fib-D1  | First mid-term (topics up to lesson 17 included). **No need to register on esami.unipi.it** |  +|MT1| 07/11 16-18| Fib-D1  | First mid-term (topics up to lesson 17 included). **No need to register on esami.unipi.it** | {{ :mds:dsd:dsdmid202501.pdf | Text and solution}} 
 |23| 12/11 11-13  | Fib-L1 | The problem of query rewrite to use a materialized view. Hypothesis and two approaches: With a compensation on the logical view plan, and with a transformation of logical query plan. Examples. [[http://131.114.72.230/dsd/video/dsd23_20241210.mp4|rec23 (.mp4)]] | **[DW: 9.1-9.4]**  {{:mds:dsd:dsd23.pdf|slides23 (.pdf)}} | |23| 12/11 11-13  | Fib-L1 | The problem of query rewrite to use a materialized view. Hypothesis and two approaches: With a compensation on the logical view plan, and with a transformation of logical query plan. Examples. [[http://131.114.72.230/dsd/video/dsd23_20241210.mp4|rec23 (.mp4)]] | **[DW: 9.1-9.4]**  {{:mds:dsd:dsd23.pdf|slides23 (.pdf)}} |
-|24| 4/12 11-13| Fib-C | **For Italian-speaking students:** Seminar (in Italian): SadasDB: Sistema per l’analisi di dati statici di supporto alle decisioni. Speaker: GCianci, [[https://www.sadasdb.com/en/|Sadas s.r.l.]]. **For non-Italian-speaking students:** Data Warehousing trends: column-oriented DW, main-memory DW, Big Data framework: watch recorded lesson at [[http://131.114.72.230/dsd/video/dsd24_20211203.mp4|rec24 (.mp4)]] | **[DW: 6.5-6.8]**  {{:mds:dsd:dsd24.pdf|slides24 (.pdf)}} | +|24| 4/12 11-13| Fib-C | **For Italian-speaking students:** Seminar (in Italian): SadasDB: Sistema per l’analisi di dati statici di supporto alle decisioni. Speaker: VMinei, [[https://www.sadasdb.com/en/|Sadas s.r.l.]]. **For non-Italian-speaking students:** Data Warehousing trends: column-oriented DW, main-memory DW, Big Data framework: watch recorded lesson at [[http://131.114.72.230/dsd/video/dsd24_20211203.mp4|rec24 (.mp4)]] | **[DW: 6.5-6.8]**  {{:mds:dsd:dsd24.pdf|slides24 (.pdf)}} | 
-|MT2| 16/12 9-11  | Fib-E | Second mid-term (all topics). **No need to register on esami.unipi.it**  +|MT2| 16/12 9-11  | Fib-E | Second mid-term (all topics). **No need to register on esami.unipi.it** {{ :mds:dsd:dsdmid202502.pdf | Text and solution}} 
  
 =====Previous years===== =====Previous years=====
  
   * [[mds:dsd:2024|Decision Support Databases  A.Y. 2024/25]]   * [[mds:dsd:2024|Decision Support Databases  A.Y. 2024/25]]
-  * [[mds:dsd:2023|Decision Support Databases  A.Y. 2023/24]] 
-  * [[mds:dsd:2022|Decision Support Databases  A.Y. 2022/23]] 
-  * [[mds:dsd:2021|Decision Support Databases  A.Y. 2021/22]] 
-  * [[mds:dsd:2020|Decision Support Databases  A.Y. 2020/21]] (special edition) 
- 
- 
- 
mds/dsd/start.1763064409.txt.gz · Ultima modifica: da Salvatore Ruggieri

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki