Information Systems
A.Y. 2023/2024
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.
Lesson period: First semester
Assessment methods: Esame
Assessment result: voto verbalizzato in trentesimi
Single course
This course can be attended as a single course.
Course syllabus and organization
Single session
Responsible
Lesson period
First semester
More specific information on the delivery modes of training activities for the academic year 2021/22 will be provided over the coming months, based on the evolution of the public health situation.
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 architecture and system layers.
Datawarehouses. Basic concepts and definitions. Architecture for data warehousing. Data source layer. Transformation layer: analysis and reconciliation 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. Data Lakes. Opinion mining and sentiment analysis for decision support.
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 architecture and system layers.
Datawarehouses. Basic concepts and definitions. Architecture for data warehousing. Data source layer. Transformation layer: analysis and reconciliation 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. Data Lakes. Opinion mining and sentiment analysis for decision support.
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. For more technical/design topics, exercises are also performed, which are commented on in the classroom. Slides, which follow the lectures' and exercises contents, are available on the Ariel website https://scastanosi.ariel.ctu.unimi.it/. 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
Ariel website: https://scastanosi.ariel.ctu.unimi.it/
Textbooks:
- 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 Ariel website https://scastanosi.ariel.ctu.unimi.it/.
Textbooks:
- 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 Ariel website https://scastanosi.ariel.ctu.unimi.it/.
Assessment methods and Criteria
The exam is written with a duration of 75 minutes, it covers all the topics of the program and it consists of questions and exercises. The final evaluation, expressed in thirtieths, takes into account the level of knowledge and competence of the program topics, the capability to solve exercises, and the clarity and correct use of the language in performing the exam.
Educational website(s)
Professor(s)