Course teached as: B014443 - DATA WAREHOUSING Second Cycle Degree in COMPUTER SCIENCE Curriculum DATA SCIENCE
Teaching Language
Italian
Course Content
This course intends to present tools and methodology for decision supporting information systems designing and management. 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 3/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
Teaching Methods
Frontal lessons
Type of Assessment
Discussion of a short report whose contents touch on the themes of conceptual modeling of sources, the construction of an information system for aggregated data and an ontology on a domain chosen by the candidate
Oral examination will touch on the points not possibly elaborated in the written report
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.
a short introduction to semantic web
a presentation to owl and sparql