Entrambe le parti precedenti la revisioneRevisione precedente | |
mds:dsd:start [26/09/2024 alle 12:36 (12 ore fa)] – Salvatore Ruggieri | mds:dsd:start [26/09/2024 alle 12:37 (12 ore fa)] (versione attuale) – Salvatore Ruggieri |
---|
|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)}} | | |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)}} | | |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-C1 | 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-C1 | 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)}} | | |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)}} | | |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)}} | |