mds:dsd:start
Differenze
Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.
| Entrambe le parti precedenti la revisioneRevisione precedenteProssima revisione | Revisione precedente | ||
| mds:dsd:start [29/11/2024 alle 09:36 (4 mesi fa)] – [Class calendar] Salvatore Ruggieri | mds:dsd:start [17/03/2025 alle 19:56 (2 settimane fa)] (versione attuale) – [Exams] Salvatore Ruggieri | ||
|---|---|---|---|
| Linea 4: | Linea 4: | ||
| The module presents the main approaches to the design and implementation of decision support databases, and the characteristics of business intelligence tools and computer based information systems used to produce summary information to facilitate appropriate decision-making processes and make them more quick and objectives. Specific attention will be paid to themes such as conceptual and logical Data Warehouses design, data analysis using analytic SQL, algorithms for selecting materialized views, data warehouse systems technology (indexes, star query optimization, | The module presents the main approaches to the design and implementation of decision support databases, and the characteristics of business intelligence tools and computer based information systems used to produce summary information to facilitate appropriate decision-making processes and make them more quick and objectives. Specific attention will be paid to themes such as conceptual and logical Data Warehouses design, data analysis using analytic SQL, algorithms for selecting materialized views, data warehouse systems technology (indexes, star query optimization, | ||
| - | |||
| =====Instructor===== | =====Instructor===== | ||
| Linea 12: | Linea 11: | ||
| * [[http:// | * [[http:// | ||
| * [[salvatore.ruggieri@unipi.it]] | * [[salvatore.ruggieri@unipi.it]] | ||
| - | * **Office hours:** Tuesdays h 14:00 - 16:00 or by appointment, | + | * **Office hours:** Tuesdays h 16:00 - 18:00 or by appointment, |
| Linea 55: | Linea 54: | ||
| ^ Date ^ Hour ^ Room ^ Notes ^ | ^ Date ^ Hour ^ Room ^ Notes ^ | ||
| - | | | + | | |
| =====Class calendar ===== | =====Class calendar ===== | ||
| Linea 91: | 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. | |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. | ||
| - | |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:// | + | |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:// |
| - | | | 13/11 11-13 | | **No lesson | + | | | 13/11 11-13 | | **No lesson |
| |24| 17/12 9-11 | Fib-C1 | Data Warehousing trends: column-oriented DW, main-memory DW, Big Data framework. [[http:// | |24| 17/12 9-11 | Fib-C1 | Data Warehousing trends: column-oriented DW, main-memory DW, Big Data framework. [[http:// | ||
mds/dsd/start.1732873009.txt.gz · Ultima modifica: 29/11/2024 alle 09:36 (4 mesi fa) da Salvatore Ruggieri