Towards a Domain-Specific Modeling Language for Extracting Event Logs from ERP Systems

• Published in: Applied sciences Vol. 11; no. 12; p. 5476
• Main Authors: Pajić Simović, Ana, Babarogić, Slađan, Pantelić, Ognjen, Krstović, Stefan
• Format: Journal Article
• Language: English
• Published: Basel MDPI AG 01.06.2021
• Subjects: artifact-centric approach; Automation; business document; Enterprise resource planning; ERP system; event log; Information systems; Language; Ontology; Purchase orders; Semantics; Structured Query Language-SQL; Subject specialists; transaction log
• ISSN: 2076-3417; 2076-3417
• DOI: 10.3390/app11125476

Enterprise resource planning (ERP) systems are often seen as viable sources of data for process mining analysis. To perform most of the existing process mining techniques, it is necessary to obtain a valid event log that is fully compliant with the eXtensible Event Stream (XES) standard. In ERP systems, such event logs are not available as the concept of business activity is missing. Extracting event data from an ERP database is not a trivial task and requires in-depth knowledge of the business processes and underlying data structure. Therefore, domain experts require proper techniques and tools for extracting event data from ERP databases. In this paper, we present the full specification of a domain-specific modeling language for facilitating the extraction of appropriate event data from transactional databases by domain experts. The modeling language has been developed to support complex ambiguous cases when using ERP systems. We demonstrate its applicability using a case study with real data and show that the language includes constructs that enable a domain expert to easily model data of interest in the log extraction step. The language provides sufficient information to extract and transform data from transactional ERP databases to the XES format.