Information Systems
A.Y. 2020/2021
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 cannot be attended as a single course. Please check our list of single courses to find the ones available for enrolment.
Course syllabus and organization
Single session
Responsible
Lesson period
First semester
Teaching methods.
Lectures will be given on the Zoom platform and can be followed both synchronously, based on the timetable of the first semester, and asynchronously, as lectures will be recorded and uploaded on the Ariel website of the course.
Course syllabus and Teaching Resources.
No changes.
Assessment methods and Criteria.
Assessments methods and criteria are unchanged: exams will be either in class or online, depending on the rules in force at that time.
Lectures will be given on the Zoom platform and can be followed both synchronously, based on the timetable of the first semester, and asynchronously, as lectures will be recorded and uploaded on the Ariel website of the course.
Course syllabus and Teaching Resources.
No changes.
Assessment methods and Criteria.
Assessments methods and criteria are unchanged: exams will be either in class or online, depending on the rules in force at that time.
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.
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 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
Web site: 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 course web site 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 course web site https://scastanosi.ariel.ctu.unimi.it/.
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.
Professor(s)