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
(In case of multiple editions, please check the period, as it may vary)
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).
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 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.
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)).
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.