Strumenti Utente

Strumenti Sito


mds:dsd:2022

Differenze

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

Link a questa pagina di confronto

Prossima revisione
Revisione precedente
mds:dsd:2022 [09/09/2023 alle 17:39 (19 mesi fa)] – creata Salvatore Ruggierimds:dsd:2022 [08/08/2024 alle 12:36 (8 mesi fa)] (versione attuale) Salvatore Ruggieri
Linea 1: Linea 1:
-<html> 
-<!-- Google Analytics --> 
-<script type="text/javascript" charset="utf-8"> 
-(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ 
-(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), 
-m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) 
-})(window,document,'script','//www.google-analytics.com/analytics.js','ga'); 
- 
-ga('create', 'UA-34685760-1', 'auto', 'personalTracker', {'allowLinker': true}); 
-ga('personalTracker.require', 'linker'); 
-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.send', 'pageview', 'courses/dsd/'); 
-setTimeout("ga('send','event','adjusted bounce rate','30 seconds')",30000);  
-</script> 
-<!-- End Google Analytics --> 
-<!-- Global site tag (gtag.js) - Google Analytics --> 
-<script async src="https://www.googletagmanager.com/gtag/js?id=G-LPWY0VLB5W"></script> 
-<script> 
-  window.dataLayer = window.dataLayer || []; 
-  function gtag(){dataLayer.push(arguments);} 
-  gtag('js', new Date()); 
- 
-  gtag('config', 'G-LPWY0VLB5W'); 
-</script> 
-<!-- Capture clicks --> 
-<script> 
-jQuery(document).ready(function(){ 
-  jQuery('a[href$=".pdf"]').click(function() { 
-    var fname = this.href.split('/').pop(); 
-    ga('personalTracker.send', 'event',  'DSD', 'PDFs', fname); 
-  }); 
-  jQuery('a[href$=".r"]').click(function() { 
-    var fname = this.href.split('/').pop(); 
-    ga('personalTracker.send', 'event',  'DSD', 'Rs', fname); 
-  }); 
-  jQuery('a[href$=".zip"]').click(function() { 
-    var fname = this.href.split('/').pop(); 
-    ga('personalTracker.send', 'event',  'DSD', 'ZIPs', fname); 
-  }); 
-  jQuery('a[href$=".mp4"]').click(function() { 
-    var fname = this.href.split('/').pop(); 
-    ga('personalTracker.send', 'event',  'DSD', 'Videos', fname); 
-  }); 
-  jQuery('a[href$=".flv"]').click(function() { 
-    var fname = this.href.split('/').pop(); 
-    ga('personalTracker.send', 'event',  'DSD', 'Videos', fname); 
-  }); 
-}); 
-</script> 
-</html> 
 ====== Decision Support Systems - Module I (6 ECTS): Decision Support Databases A.Y. 2022/23 ====== ====== Decision Support Systems - Module I (6 ECTS): Decision Support Databases A.Y. 2022/23 ======
  
Linea 218: Linea 166:
 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.** //Wednesday 7 December 2022, 11-13// **[DW: 9.1-9.4]** [[http://patterns.di.unipi.it/dsd/video/dsd23_20211130.mp4|rec23 audio-video (.mp4) past years]]+**2022-23.** //Wednesday 7 December 2022, 11-13// **[DW: 9.1-9.4]** [[http://patterns.di.unipi.it/dsd/video/dsd23_20211130.mp4|rec23 audio-video (.mp4) past years]]
  
 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.
Linea 226: Linea 174:
  
   * [[mds:dsd:2021|Decision Support Databases  A.Y. 2021/22]]   * [[mds:dsd:2021|Decision Support Databases  A.Y. 2021/22]]
-  * [[mds:dsd:2020|Decision Support Databases  A.Y. 2020/21]]+  * [[mds:dsd:2020|Decision Support Databases  A.Y. 2020/21]] (special edition)
  
  
mds/dsd/2022.1694281172.txt.gz · Ultima modifica: 09/09/2023 alle 17:39 (19 mesi fa) da Salvatore Ruggieri

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki