Information systems

A.Y. 2019/2020
Overall hours
Learning objectives
Goal of the course is to introduce basic concepts on Enterprise information systems with reference to models and architectures of business processes covering front-end systems, back-end systems, enterprise governance. The course specifically focuses on methodological aspects related to datawarehouse analysis and design, with focus on data extraction and integration activities, by also presenting basic notions of big data analysis systems and their possible roles in enterprise activities.
Expected learning outcomes
Students will be able to effectively analyze information systems architectures, by critically discussing and motivating different architectural solutions. Students will be able to apply concepts and methods introduced in the course to solve simple datawarehousing analysis and design problems.
Course syllabus and organization

Unique edition

Lesson period
First semester
Course syllabus
Introduction to Enterprise Information Systems. Organizational model (operation systems, management systems, analysis systems). IT model (application model, technology model). Functional model (use case model, process model, data model).
Business processes. Definition of Business Process (BP) - the CRASO paradigm. A classification of BP. Business processes modeling.
Business Intelligence and decision support systems. Requirements and features of business information. Reference architetture and system layers.
Datawarehouses. Basic concepts and definitions. Architecture for data warehousing. Data source layer. Transformation layer: analysis and reconcicliation of data sources. Storage layer: conceptual and logical design of the DW. Processing layer: reporting, OLAP, data mining. Relational DW: ROLAP schemas and queries.
ERP systems. ERP paradigm and reference architecture. CRM systems. CRM paradigm and reference architecture. CRM evolution.
Information systems and Big Data. New requirements and challenges. Opinion mining and sentiment analysis for decision support. The SMAC (Social, Mobile, Analytics and Cloud) paradigm.
Prerequisites for admission
Fundamental notions of relational databases and RDBMS are required (database design, data modeling, schema definition and query languages).
Teaching methods
The teaching consists of lectures, supported by the use of slides. Slides, which follow the contents of the lectures, are made available on the ARIEL web site Furthermore, seminars are given on advanced projects to involve students in concrete applications of information system concepts and architectures presented during the course.
Teaching Resources
Web site:

- G. Bracchi, C. Francalanci, G. Motta. Sistemi Informativi d'impresa. McGraw-Hill - 2010 (Chapters 1,2,3,4,5,9)
- M. Golfarelli, S. Rizzi. Data Warehouse - Teoria e pratica della progettazione (2 ed.). Mc-Graw Hill, 2006 (Chapters 1,2,3,4,5 (until 5.2.10 included), 6 (until 6.1.8 included), 8, 9 (until 9.1.10 included)).

Lecture slides downloadable from the course web site
Assessment methods and Criteria
The exam is written, it covers all the topics of the program and it consists of questions and exercises. The final evalutation, expressed in thirtieths, takes into account the level of knowlege and competence of the program topics, the capapbility to solve exercises, and the clarity and correct use of the language in performing the exam.
INF/01 - INFORMATICS - University credits: 6
Lessons: 48 hours
Professor: Castano Silvana
Educational website(s)
Upon request by email
Office P109 - via Comelico 39