Differenze

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

--- mds:dsd:start [05/11/2025 alle 11:59 (5 settimane fa)] – [Exams] Salvatore Ruggieri
+++ mds: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  ^
-|  7/11/2025  |  16:00 - 18:00  |  FIB-D1  |   |
+|  8/1/2026  |  14:00 - 16:00  |  Fib-C1  |   |
-|  8/1/2026  |  14:00 - 16:00  |  TBD  |   |
+|  29/1/2026  |  9:00 - 11:00  |  Fib-L1  |   |
-|  29/1/2026  |  9:00 - 11:00  |  TBD  |   |
 =====Class calendar =====
@@ Linea 93: / Linea 92: @@
 |20| 31/10 9-11 | Fib-C | The problem of materialized views selection. The lattice of views and the greedy algorithm HRU for the selection of materialized views. Examples. Other algorithms for the choice of the views to materialize with a workload and dimensional hierarchies.  {{:mds:dsd:dsd20.assignments.pdf|Exercises at home for the lesson 21}}. [[http://131.114.72.230/dsd/video/dsd20_20211119.mp4|rec20 (.mp4)]] | **[DW: 7.1-7.7]**  {{:mds:dsd:dsd20.pdf|slides20 (.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 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| 11/11 9-11  | Fib-H Lab | 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| 12/11 11-13  | Fib-L1 | Data Warehousing trends: column-oriented DW, main-memory DW, Big Data framework. [[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**  |  |