DidaWiki

Strumenti Utente

Strumenti Sito

Ti trovi qui: DidaWiki » mds » Decision Support Systems - Module I (6 ECTS): Decision Support Databases A.Y. 2023/24
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 revisione Revisione precedente
Prossima revisione 		Revisione precedente
Prossima revisione Entrambe le parti successive la revisione
mds:dsd:start [23/11/2021 alle 14:35 (2 anni fa)]
Salvatore Ruggieri [Class calendar] 		mds:dsd:start [04/12/2021 alle 17:55 (2 anni fa)]
Salvatore Ruggieri
Linea 9: Linea 9:
 ga('create', 'UA-34685760-1', 'auto', 'personalTracker', {'allowLinker': true}); ga('create', 'UA-34685760-1', 'auto', 'personalTracker', {'allowLinker': true});
 ga('personalTracker.require', 'linker'); ga('personalTracker.require', 'linker');
-ga('personalTracker.linker:autoLink', ['pages.di.unipi.it', 'enforce.di.unipi.it', 'didawiki.di.unipi.it'] ); +ga('personalTracker.linker:autoLink', ['pages.di.unipi.it', 'enforce.di.unipi.it', 'didawiki.di.unipi.it', 'luciacpassaro.github.io'] ); 
-  +
 ga('personalTracker.require', 'displayfeatures'); ga('personalTracker.require', 'displayfeatures');
 ga('personalTracker.send', 'pageview', 'ruggieri/teaching/dsd/'); ga('personalTracker.send', 'pageview', 'ruggieri/teaching/dsd/');
Linea 78: Linea 78:
 =====Mandatory teaching material ===== =====Mandatory teaching material =====
  
-  * **[DW]** A. Albano, S. Ruggieri. [[http://patterns.di.unipi.it/bsd/DWessential-2021.pdf|Decision Support Databases Essentials]], University of Pisa, 17 February 2021.  +  * **[DW]** A. Albano, S. Ruggieri. [[http://fondamentidibasididati.it/wp-content/uploads/2020/11/DWessential-2021-C3-12-21.pdf|Decision Support Databases Essentials]], University of Pisa, 2 December 2021.  
-  * **[DB]** A. Albano. [[http://fondamentidibasididati.it/DBEssential-2021.pdf|DB Essentials]], University of Pisa, 1 December 2020. This is a self-contained excerpt (in English) from: [[http://fondamentidibasididati.it|Fondamenti di basi di dati]] (in Italian, free download).+  * **[DB]** A. Albano. [[http://fondamentidibasididati.it/wp-content/uploads/2020/11/DBEssential-2021-C30-11-21.pdf|DB Essentials]] and [[http://fondamentidibasididati.it/wp-content/uploads/2020/11/DBEssential-2020-Soluzioni-C30-11-21.pdf|solutions to exercises]], University of Pisa, 1 December 2020. This is a self-contained excerpt (in English) from the book [[http://fondamentidibasididati.it|Fondamenti di basi di dati]] (in Italian, free download).
   * Examples of [[http://patterns.di.unipi.it/bsd/DSDsamples.pdf|written exams with solutions]] and [[http://patterns.di.unipi.it/bsd/dsd2020sample.pdf|written exam]].   * Examples of [[http://patterns.di.unipi.it/bsd/DSDsamples.pdf|written exams with solutions]] and [[http://patterns.di.unipi.it/bsd/dsd2020sample.pdf|written exam]].
 =====Software===== =====Software=====
Linea 100: Linea 100:
  
 ^  Date  ^  Hour  ^  Room  ^  Notes  ^ ^  Date  ^  Hour  ^  Room  ^  Notes  ^
-|  19/11/2021  |  9:00 - 11:00  |  I-Lab | [[https://didattica.di.unipi.it/en/appelli-straordinari/|Extra-ordinary exam]] |+|  18/1/2022  |  14:00 - 16:00  |  TBD |   | 
 +|  8/2/2022  |  14:00 - 16:00  |  TBD |   |
  
 <html> <html>
Linea 211: Linea 212:
 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. 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.
  
-**2021-22.** //Friday 26 November 2021, 16-18// **[DW: 8.3-8.6]** +**2021-22.** //Friday 26 November 2021, 16-18// **[DW: 8.3-8.6]** [[http://patterns.di.unipi.it/bsd/video/dsd22_20211126.mp4|rec22 audio-video (.mp4)]]
  
 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. 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.
  
-**2021-23.** //Tuesday 30 November 2021, 9-11// **[DW: 9.1-9.4]** +**2021-23.** //Tuesday 30 November 2021, 9-11// **[DW: 9.1-9.4]** [[http://patterns.di.unipi.it/bsd/video/dsd23_20211130.mp4|rec23 audio-video (.mp4)]]
  
 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. 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.
  
-**2021-24.** //Friday 3 December 2021, 16-18// **[DW: 6.5-6.8]** +**2021-24.** //Friday 3 December 2021, 16-18// **[DW: 6.5-6.8]**  [[http://patterns.di.unipi.it/bsd/video/dsd24_20211203.mp4|rec24 audio-video (.mp4)]]
  
 Data Warehousing trends: column-oriented DW, main-memory DW, Big Data framework. Data Warehousing trends: column-oriented DW, main-memory DW, Big Data framework.
Linea 227: Linea 228:
  
   * [[mds:dsd:2020|Decision Support Databases  A.Y. 2020/21]]   * [[mds:dsd:2020|Decision Support Databases  A.Y. 2020/21]]
-  * [[mds:dsd:2019|Decision Support Databases  A.Y. 2019/20]] 
-  * [[mds:dsd:2018|Decision Support Databases  A.Y. 2018/19]] 
  
  
mds/dsd/start.txt · Ultima modifica: 18/04/2024 alle 15:57 (34 ore fa) da Salvatore Ruggieri

Strumenti Pagina

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki