DidaWiki

Strumenti Utente

Strumenti Sito

Ti trovi qui: DidaWiki » mds » Decision Support Systems - Module I (6 ECTS): Decision Support Databases A.Y. 2024/25
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 [09/12/2024 alle 20:00 (4 mesi fa)] – Salvatore Ruggierimds:dsd:start [17/03/2025 alle 19:56 (14 giorni fa)] (versione attuale) – [Exams] Salvatore Ruggieri
Linea 11: Linea 11:
     * [[http://pages.di.unipi.it/ruggieri/]]     * [[http://pages.di.unipi.it/ruggieri/]]
     * [[[email protected]]]       * [[[email protected]]]  
-    * **Office hours:** Tuesdays h 14:00 - 16:00 or by appointment, at the Department of Computer Science, room 321/DO, or via Teams.+    * **Office hours:** Tuesdays h 16:00 - 18:00 or by appointment, at the Department of Computer Science, room 321/DO, or via Teams.
  
  
Linea 54: Linea 54:
  
 ^  Date  ^  Hour  ^  Room  ^  Notes  ^ ^  Date  ^  Hour  ^  Room  ^  Notes  ^
-|  6/11/2024  |  9:00 - 11:00  |  Riunioni Ovest, Dept. Computer Science  | [[https://didattica.di.unipi.it/en/appelli-straordinari/|Extra-ordinary exam]] |+|  18/3/2025  |  9:00 - 11:00  |  FIB-E  | [[https://didattica.di.unipi.it/en/appelli-straordinari/|Extra-ordinary exam]] |
  
 =====Class calendar ===== =====Class calendar =====
Linea 90: Linea 90:
 | | 29/11 11-13 |   | **Lesson canceled due to a strike.**  |   | | | 29/11 11-13 |   | **Lesson canceled due to a strike.**  |   |
 |22| 6/12 11-13 | Fib-C1 | 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| 6/12 11-13 | Fib-C1 | 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)}} |
-|23| 10/12 9-11  | Fib-C  | 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_20211130.mp4|rec23 (.mp4)]] | **[DW: 9.1-9.4]**  {{:mds:dsd:dsd23.pdf|slides23 (.pdf)}} |+|23| 10/12 9-11  | Fib-C  | 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)}} |
 | | 13/11 11-13 |   | **No lesson on this date.**  |   | | | 13/11 11-13 |   | **No lesson on this date.**  |   |
 |24| 17/12 9-11  | Fib-C1 | 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| 17/12 9-11  | Fib-C1 | 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)}} |
mds/dsd/start.1733774402.txt.gz · Ultima modifica: 09/12/2024 alle 20:00 (4 mesi fa) da Salvatore Ruggieri
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki