This course intends to present tools and methodology for decision supporting information systems designing and management. The main topics include: Conceptual and semantic models, Business Intelligence and Decision Support System, Metadata information systems, Information systems for processes representation, The relational approach for space and data representation, OLTP and OLAP applications, DW Architecture, Data Mart Design, ETL Tools, Multidimensional model, enhanced reporting tools , olap
Matteo Golfarelli, Stefano Rizzi Data Warehouse - Teoria e pratica della progettazione 2/ed
Mc-Graw-Hill
Text prepared by the teachers
Learning Objectives
To acquire capacities and competencies in complex problems analysis and representation.
Competencies in decision supporting information systems management , temporal data bases and datawarehouse designing techniques.
Prerequisites
Elements of Data bases
Type of Assessment
Discussion of a short paper , oral test
Course program
• from language to information models
• temporal reasoning
• the spacial dimension of decision supporting information systems
• the role of ontologies in decision supporting information systems
• information models for processes representation
• beyond the relational approach: conceptual models for aggregated data
• how to model information systems in support of politics evaluation
• Business Intelligence and Decision Support System
• OLTP and OLAP applications
• DW Architecture, Data Mart Design
• ETL Tools
• Multidimensional model
• Enhanced reporting tools and olap navigation
• An overview of data mining techniques.