Enterprise Resource Planning Systems


Vsevolod S. Chernyshenko, docent of the National Mining University (Ukraine)

Sergiy Prykhodchenko, assistent professor of the National Mining University (Ukraine)

Jan Genci, docent of Technical University of Kosice

Abstract of the course

The course is devoted to the management and maintenance of information technology governance process in all type of organizations. Enterprise Resoucre Planning (ERP) systems automate this activity with an integrated software application. They facilitate information flow between all business functions inside the organization, and manage connections to outside stakeholders.

While this may imply that ERP is closely tied to IT, in case of university environment it should be viewed in the broader context of documents circulation and process, performance management and process architecture as well as more technical subjects. Depending on the organization, enterprise architecture teams may also be responsible for some aspects of performance engineering, IT portfolio management and metadata management.

ERP is always associated with the data analysis and reporting. So the knowledge domain of data warehouses (DWH) is considered to be analysed also within the course. Motivation of data analysis, presentation of DIKW (data-information-knowledge-wisdom) approach, basic architecture of DWH, characterisation and specification of each part of data will be considered, including relevant approaches and commands for data processing.

Moreover a systematic, disciplined, quantifiable approach to the design, development, operation and maintenance of software will be analysed. Participants will be proposed a theory of software construction that describes detailed design of computer systems by combination of coding, verification, unit testing, integration testing and program debugging. Obviously, software construction is driven by many practical considerations that will be analysed. Special attention will be drawn to construction for verification which means building software in such a way that faults can be ferreted out readily by the software engineers writing the software.


I. Introduction to Enterprise Architecture. Architecture Frameworks: comparison and conclusion, key components.

II. Motivation for DWH, DIKW, structure of DWH, ETL, information delivery.

III. Data models for DWH (STAR and SnowFlake schema)

IV. Tools for ETL, presentation of analysis

V. Approaches and commands for data processing, simple DWH solution

VI. Introduction to TOGAF methodology. Architecture Vision; Business Architecture; Information Systems Architecture.

VII. Technology Architecture: opportunities and solutions; migration planning; implementation governance; architecture change management.

VIII. Introduction to software construction models. Cascade model, eXtreme Programmin model, SCRUM model. Comparison of software construction methodologies.

Key Words / Areas

Information Architecture, DIKW, data warehouse, ETL, object oriented programming, software construction, architecture framework, system design, modularization, testing, code verification