mds:dsd:2022
Differenze
Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.
Prossima revisione | Revisione precedente | ||
mds:dsd:2022 [09/09/2023 alle 17:39 (19 mesi fa)] – creata Salvatore Ruggieri | mds:dsd:2022 [08/08/2024 alle 12:36 (8 mesi fa)] (versione attuale) – Salvatore Ruggieri | ||
---|---|---|---|
Linea 1: | Linea 1: | ||
- | < | ||
- | <!-- Google Analytics --> | ||
- | <script type=" | ||
- | (function(i, | ||
- | (i[r].q=i[r].q||[]).push(arguments)}, | ||
- | m=s.getElementsByTagName(o)[0]; | ||
- | })(window, | ||
- | |||
- | ga(' | ||
- | ga(' | ||
- | ga(' | ||
- | |||
- | ga(' | ||
- | ga(' | ||
- | setTimeout(" | ||
- | </ | ||
- | <!-- End Google Analytics --> | ||
- | <!-- Global site tag (gtag.js) - Google Analytics --> | ||
- | <script async src=" | ||
- | < | ||
- | window.dataLayer = window.dataLayer || []; | ||
- | function gtag(){dataLayer.push(arguments); | ||
- | gtag(' | ||
- | |||
- | gtag(' | ||
- | </ | ||
- | <!-- Capture clicks --> | ||
- | < | ||
- | jQuery(document).ready(function(){ | ||
- | jQuery(' | ||
- | var fname = this.href.split('/' | ||
- | ga(' | ||
- | }); | ||
- | jQuery(' | ||
- | var fname = this.href.split('/' | ||
- | ga(' | ||
- | }); | ||
- | jQuery(' | ||
- | var fname = this.href.split('/' | ||
- | ga(' | ||
- | }); | ||
- | jQuery(' | ||
- | var fname = this.href.split('/' | ||
- | ga(' | ||
- | }); | ||
- | jQuery(' | ||
- | var fname = this.href.split('/' | ||
- | ga(' | ||
- | }); | ||
- | }); | ||
- | </ | ||
- | </ | ||
====== 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:// | + | **2022-23.** //Wednesday 7 December 2022, 11-13// **[DW: 9.1-9.4]** [[http:// |
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: | * [[mds: | ||
- | * [[mds: | + | * [[mds: |
mds/dsd/2022.1694281172.txt.gz · Ultima modifica: 09/09/2023 alle 17:39 (19 mesi fa) da Salvatore Ruggieri