DidaWiki

Strumenti Utente

Strumenti Sito

Ti trovi qui: DidaWiki » mds » Decision Support Systems - Module I (6 ECTS): Decision Support Databases A.Y. 2025/26
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 (3 settimane fa)] – [Exams] Salvatore Ruggierimds:dsd:start [29/11/2025 alle 11:34 (8 giorni fa)] (versione attuale) – [Class calendar] Salvatore Ruggieri
Linea 58: Linea 58:
  
 ^  Date  ^  Hour  ^  Room  ^  Notes  ^ ^  Date  ^  Hour  ^  Room  ^  Notes  ^
-|  8/1/2026  |  14:00 - 16:00  |  TBD  |   | +|  8/1/2026  |  14:00 - 16:00  |  Fib-C1  |   | 
-|  29/1/2026  |  9:00 - 11:00  |  Fib-L1|   |+|  29/1/2026  |  9:00 - 11:00  |  Fib-L1  |   |
  
 =====Class calendar ===== =====Class calendar =====
Linea 93: Linea 93:
 |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: G. Cianci, [[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: V. Minei, [[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/start.1763064409.txt.gz · Ultima modifica: 13/11/2025 alle 20:06 (3 settimane fa) da Salvatore Ruggieri
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki