DidaWiki

Strumenti Utente

Strumenti Sito

Ti trovi qui: DidaWiki » mds » Decision Support Systems - Module I (6 ECTS): Decision Support Databases A.Y. 2026/27
mds:dsd:start

Differenze

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

Link a questa pagina di confronto

Entrambe le parti precedenti la revisioneRevisione precedente
mds:dsd:start [11/09/2026 alle 09:40 (33 ore fa)] – [Class calendar] Salvatore Ruggierimds:dsd:start [11/09/2026 alle 09:41 (33 ore fa)] (versione attuale) – Salvatore Ruggieri
Linea 70: Linea 70:
 ^ # ^ Date ^ Room ^ Topic ^ Mandatory teaching material ^  ^ # ^ Date ^ Room ^ Topic ^ Mandatory teaching material ^ 
 |01| 15/09 11-13 | Fib-L1 | Course overview. Need for Strategic Information. Information Systems in Organizations: Operational and Decision support. Data driven Decision support systems and Business Intelligence applications.  [[http://131.114.72.230:443/dsd/video/dsd01_20220915.mp4|rec01 (.mp4)]] | **[DW: 1.1-1.2]**  {{:mds:dsd:dsd01.pdf|slides01 (.pdf)}} | |01| 15/09 11-13 | Fib-L1 | Course overview. Need for Strategic Information. Information Systems in Organizations: Operational and Decision support. Data driven Decision support systems and Business Intelligence applications.  [[http://131.114.72.230:443/dsd/video/dsd01_20220915.mp4|rec01 (.mp4)]] | **[DW: 1.1-1.2]**  {{:mds:dsd:dsd01.pdf|slides01 (.pdf)}} |
 +|02| 16/09 11-13 | Fib-C1 | The data warehouse (DW) and DW architectures. What to model in a DW: Facts, measures, dimensions and dimensional hierarchies. Examples of data analysis. Exercises on data analysis in SQL.  [[http://131.114.72.230:443/dsd/video/dsd02_20180919.flv|rec02 (.flv)]] | **[DW: 1.3-1.7]**  {{:mds:dsd:dsd02.pdf|slides02 (.pdf)}} |
 +|03| 17/09 14-16 | Fib-C | Recalls: the Object Data Model. {{:mds:dsd:dsd03.assignments.pdf|Exercises at home (Assignments I and II) for the lesson 05}}. [[http://131.114.72.230:443/dsd/video/dsd03_20210921.mp4|rec03 (.mp4)]] | **[DB: 1.1, 2.1-2.5]**  {{:mds:dsd:dsd03.pdf|slides03 (.pdf)}} |
  
  
Linea 78: Linea 80:
  
 ^ # ^ Date ^ Room ^ Topic ^ Mandatory teaching material ^  ^ # ^ Date ^ Room ^ Topic ^ Mandatory teaching material ^ 
-|02| 17/09 11-13 | Fib-C1 | The data warehouse (DW) and DW architectures. What to model in a DW: Facts, measures, dimensions and dimensional hierarchies. Examples of data analysis. Exercises on data analysis in SQL.  [[http://131.114.72.230:443/dsd/video/dsd02_20180919.flv|rec02 (.flv)]] | **[DW: 1.3-1.7]**  {{:mds:dsd:dsd02.pdf|slides02 (.pdf)}} | 
-|03| 18/09 11-13 | Fib-C | Recalls: the Object Data Model. {{:mds:dsd:dsd03.assignments.pdf|Exercises at home (Assignments I and II) for the lesson 05}}. [[http://131.114.72.230:443/dsd/video/dsd03_20210921.mp4|rec03 (.mp4)]] | **[DB: 1.1, 2.1-2.5]**  {{:mds:dsd:dsd03.pdf|slides03 (.pdf)}} | 
 |04| 19/09 9-11 | Fib-C | DW modeling. Representation of facts, measures, dimensions, attributes and dimensional hierarchies. Key steps in conceptual design from business questions. How to identify facts, measures, dimensions, dimensional attributes and hierarchies. Examples. {{:mds:dsd:dsd04.assignments.pdf|Exercises at home (University exams) for the lesson 05}}.  [[http://131.114.72.230:443/dsd/video/dsd04_20170929.flv|rec04 (.flv)]] | **[DW: 2.1]**  {{:mds:dsd:dsd04.pdf|slides04 (.pdf)}} | |04| 19/09 9-11 | Fib-C | DW modeling. Representation of facts, measures, dimensions, attributes and dimensional hierarchies. Key steps in conceptual design from business questions. How to identify facts, measures, dimensions, dimensional attributes and hierarchies. Examples. {{:mds:dsd:dsd04.assignments.pdf|Exercises at home (University exams) for the lesson 05}}.  [[http://131.114.72.230:443/dsd/video/dsd04_20170929.flv|rec04 (.flv)]] | **[DW: 2.1]**  {{:mds:dsd:dsd04.pdf|slides04 (.pdf)}} |
 |05| 23/09 9-11 | Fib-L1 | The example of a data model for Master program exams. Presentation and discussion of the Hospital case study.  {{:mds:dsd:dsd05.assignments.pdf|Exercises at home (Assignment III) for the lesson 07}}.  [[http://131.114.72.230:443/dsd/video/dsd05_20210928.mp4|rec05 (.mp4)]] | **[DW: 2.1, A.1]**  {{:mds:dsd:dsd05.pdf|slides05 (.pdf)}} | |05| 23/09 9-11 | Fib-L1 | The example of a data model for Master program exams. Presentation and discussion of the Hospital case study.  {{:mds:dsd:dsd05.assignments.pdf|Exercises at home (Assignment III) for the lesson 07}}.  [[http://131.114.72.230:443/dsd/video/dsd05_20210928.mp4|rec05 (.mp4)]] | **[DW: 2.1, A.1]**  {{:mds:dsd:dsd05.pdf|slides05 (.pdf)}} |
mds/dsd/start.txt · Ultima modifica: da Salvatore Ruggieri
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki