Differenze

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

--- mds:dsd:start [26/09/2024 alle 10:15 (18 ore fa)] – Salvatore Ruggieri
+++ mds:dsd:start [26/09/2024 alle 12:37 (16 ore fa)] (versione attuale) – 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, physical design, query rewrite methods to use materialized views). A part of the course will be dedicated to a collection of case studies.
 =====Instructor=====
@@ Linea 76: / Linea 75: @@
 |08| 03/10 11-13 | Fib-A1 | Recalls: the relational model and relational algebra. Logical trees. {{:mds:dsd:dsd08.jrsexercises.pdf|Exercises with JRS}}.  {{:mds:dsd:dsd08.assignments.pdf|Exercises at home (Airline companies) for the lesson 09}}. [[http://131.114.72.230/dsd/video/dsd08_20211008.mp4|rec08 (.mp4)]] | **[DB: 3.2-3.4]**  {{:mds:dsd:dsd08.pdf|slides08 (.pdf)}} |
 |09| 04/10 11-13 | Fib-C1 | Discussion of students' solutions of conceptual and logical design case studies.   [[http://131.114.72.230/dsd/video/dsd09_20211012.mp4|rec09 (.mp4)]] | **[DW: A.2, B.2]**  {{:mds:dsd:dsd09.pdf|slides09 (.pdf)}} |
-|10| 8/10 11-13 | Fib-A1 | Data Warehouse design approaches. Data mart logical design.  [[http://131.114.72.230/dsd/video/dsd10_20211015.mp4|rec08 (.mp4)]] | **[DW: 3.1-3.5]**  {{:mds:dsd:dsd10.pdf|slides10 (.pdf)}} |
+|10| 8/10 11-13 | Fib-C | Data Warehouse design approaches. Data mart logical design.  [[http://131.114.72.230/dsd/video/dsd10_20211015.mp4|rec08 (.mp4)]] | **[DW: 3.1-3.5]**  {{:mds:dsd:dsd10.pdf|slides10 (.pdf)}} |
-|11| 15/10 11-13 | Fib-A1 | Slowly changing dimensions, fast changing dimensions, shared dimensions. Recursive hierarchies. Multivalued dimensions. {{:mds:dsd:dsd11.assignments.pdf|Exercises at home (Travel agency extended) for the lesson 12}}.   [[http://131.114.72.230/dsd/video/dsd11_20221020.mp4|rec09 (.mp4)]] | **[DW: 3.1-3.5]**  {{:mds:dsd:dsd11.pdf|slides11 (.pdf)}} |
+|11| 15/10 11-13 | Fib-C | Slowly changing dimensions, fast changing dimensions, shared dimensions. Recursive hierarchies. Multivalued dimensions. {{:mds:dsd:dsd11.assignments.pdf|Exercises at home (Travel agency extended) for the lesson 12}}.   [[http://131.114.72.230/dsd/video/dsd11_20221020.mp4|rec09 (.mp4)]] | **[DW: 3.1-3.5]**  {{:mds:dsd:dsd11.pdf|slides11 (.pdf)}} |
 |12| 16/10 16-18 | Fib-H | A DW to support Analytical CRM Analysis. Wrap up on DW design.  {{:mds:dsd:dsd12.assignments.pdf|Exercises at home for the lesson 14}}. [[http://131.114.72.230/dsd/video/dsd12_20211022.mp4|rec12 (.mp4)]] | **[DW: 4.1-4.8]**  {{:mds:dsd:dsd12.pdf|slides12 (.pdf)}} |
 |13| 17/10 11-13 | Fib-A1 | Multidimensional Cube model: OLAP Operations. The extended cube and the lattice of cuboids. Pivot tables in Excel. [[http://131.114.72.230/dsd/video/dsd13a_20231107.mp4|rec13a (.mp4)]] and [[http://131.114.72.230/dsd/video/dsd13b_20211026.mp4|rec13b (.mp4)]] **Additional learning material:** G. Harvey. Excel 2013 All-in-One For Dummies, 2013. [[http://131.114.72.230/dsd/PivotTable2013BookVIIchpt2.pdf|Chp. VII-2]] and [[http://131.114.72.230/dsd/HerbalTeas.xlsx|example data for pivot table]]. | **[DW: 2.3, 2.4]**  {{:mds:dsd:dsd13.pdf|slides13 (.pdf)}} |