Differenze

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

--- mds:dsd:2022 [09/09/2023 alle 17:39 (2 anni fa)] – creata Salvatore Ruggieri
+++ mds:dsd:2022 [08/08/2024 alle 12:36 (17 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 ======
@@ 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.
-**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.
@@ Linea 226: / Linea 174: @@
   * [[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)