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
mds:dsd:start [19/11/2025 alle 17:12 (2 settimane fa)] – Salvatore Ruggierimds:dsd:start [29/11/2025 alle 11:34 (7 giorni fa)] (versione attuale) – [Class calendar] Salvatore Ruggieri
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: 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)}} | |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)}} |
mds/dsd/start.txt · Ultima modifica: 29/11/2025 alle 11:34 (7 giorni fa) da Salvatore Ruggieri
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki