Extracting event data from databases to unleash process mining

Increasingly organizations are using process mining to understand the way that operational processes are executed. Process mining can be used to systematically drive innovation in a digitalized world. Next to the automated discovery of the real underlying process, there are process-mining techniques to analyze bottlenecks, to uncover hidden inefficiencies, to check compliance, to explain deviations, to predict performance, and to guide users towards "better" processes. Dozens (if not hundreds) of process-mining techniques are available and their value has been proven in many case studies. However, process mining stands or falls with the availability of event logs. Existing techniques assume that events are clearly defined and refer to precisely one case (i.e. process instance) and one activity (i.e., step in the process). Although there are systems that directly generate such event logs (e.g., BPM/WFM systems), most information systems do not record events explicitly. Cases and activities only exist implicitly. However, when creating or using process models "raw data" need to be linked to cases and activities. This paper uses a novel perspective to conceptualize a database view on event data. Starting from a class model and corresponding object models it is shown that events correspond to the creation, deletion, or modification of objects and relations. The key idea is that events leave footprints by changing the underlying database. Based on this an approach is described that scopes, binds, and classifies data to create "flat" event logs that can be analyzed using traditional process-mining techniques

Extracting event data from databases to unleash process mining

Increasingly organizations are using process mining to understand the way that operational processes are executed. Process mining can be used to systematically drive innovation in a digitalized world. Next to the automated discovery of the real underlying process, there are process-mining techniques to analyze bottlenecks, to uncover hidden inefficiencies, to check compliance, to explain deviations, to predict performance, and to guide users towards "better" processes. Dozens (if not hundreds) of process-mining techniques are available and their value has been proven in many case studies. However, process mining stands or falls with the availability of event logs. Existing techniques assume that events are clearly defined and refer to precisely one case (i.e. process instance) and one activity (i.e., step in the process). Although there are systems that directly generate such event logs (e.g., BPM/WFM systems), most information systems do not record events explicitly. Cases and activities only exist implicitly. However, when creating or using process models "raw data" need to be linked to cases and activities. This paper uses a novel perspective to conceptualize a database view on event data. Starting from a class model and corresponding object models it is shown that events correspond to the creation, deletion, or modification of objects and relations. The key idea is that events leave footprints by changing the underlying database. Based on this an approach is described that scopes, binds, and classifies data to create "flat" event logs that can be analyzed using traditional process-mining techniques

Enabling Process Mining in Airbus Manufacturing : Extracting Event Logs and Discovering Processes from Complex Data

Ministerio de Ciencia y Tecnología RTI2018-094283-B-C3

An investigation of discovering business processes from operational databases

Process discovery techniques aim to discover process models from event-logs. An event-log records process activities carried out on related data items and the timestamp where the event occurred. While the event-log is explicitly recorded in the process-awareness information systems such as modern ERP and CRM systems, other in-house information systems may not record event-log, but an operational database. This raises the need to develop process discovery solutions from operational databases. Meanwhile, process models can be represented from various perspectives, e.g. functional, behavioural, organisational, informational and business context perspectives. However, none of the existing techniques supports to discover process models from different perspectives using operational databases. This paper aims to deal with these gaps by proposing process expressive artefacts based on process perspectives adopted in the literature, as well as discussing how these artefacts can be extracted from data components of a typical operational database

A Cross-Organizational Process Mining Framework for Obtaining Insights from Software Products: Accurate Comparison Challenges

Software vendors offer various software products to large numbers of enterprises to support their organization, in particular Enterprise Resource Planning (ERP) software. Each of these enterprises use the same product for similar goals, albeit with different processes and configurations. Therefore, software vendors want to obtain insights into how the enterprises use the software product, what the differences are in usage between enterprises, and the reasons behind these differences. Cross-organizational process mining is a possible solution to address these needs, as it aims at comparing enterprises based on their usage. In this paper, we present a novel Cross-Organizational Process Mining Framework which takes as input, besides event log, semantics (meaning of terms in an enterprise) and organizational context (characteristics of an enterprise). The framework provides reasoning capabilities to determine what to compare and how. Besides, the framework enables one to create a catalog of metrics by deducing diagnostics from the usage. By using this catalog, the framework can monitor the (positive) effects of changes on processes. An enterprise operating in a similar context might also benefit from the same changes. To accommodate these improvement suggestions, the framework creates an improvement catalog of observed changes. Later, we provide a set of challenges which have to be met in order to obtain the inputs from current products to show the feasibility of the framework. Next to this, we provide preliminary results showing they can be met and illustrate an example application of the framework in cooperation with an ERP software vendor

Process Mining in Frail Elderly Care: A Literature Review

Process mining has proved to be a valuable technique for extracting process knowledge from data within information systems. Much work has been conducted in applying process mining to domains such as logistics, banking, transportation and many areas of the government, including healthcare. Frail elderly people who have an increased risk of adverse outcomes are amongst the main users of healthcare services and understanding healthcare processes for the frail elderly is challenging because of their diverse and complex needs combined with an often high number of co-morbidities. This paper aims to provide an overview of work applying process mining techniques to improving the care of frail elderly people. We conducted a literature search using broad criteria to identify 1,047 potential papers followed by a review of titles, abstract and content which identified eight papers where process mining techniques have been successfully applied to the care of frail elderly people. Our review shows that, to date, there has been limited application of process mining to support this important segment of the population. We summarise the results based on five themes that emerged: types of source data and process; geographical location; analysis methodology; medical domain; and challenges. Our paper concludes with a discussion on the issues and opportunities for process mining to improve the care pathways for frail elderly people

Supporting Event Log Extraction based on Matching

Process mining allows organizations to obtain relevant insights into the execution of their processes. However, the starting point of any process mining analysis is an event log, which is typically not readily available in practice. The extraction of event logs from the relevant databases is a manual and highly time-consuming task, and often a hurdle for the application of process mining altogether. Available support for event log extraction comes with different assumptions and requirements and only provides limited automated support. In this paper, we therefore take a novel angle at supporting event log extraction. The core idea of our paper is to use an existing process model as a starting point and automatically identify to which database tables the activities of the considered process model relate to. Based on the resulting mapping, an event log can then be extracted in an automated fashion. We use this paper to define a first approach that is able to identify such a mapping between a process model and a database. We evaluate our approach using three real-world databases and five process models from the purchase-to-pay domain. The results of our evaluation show that our approach has the potential to successfully support event log extraction based on matching

Process Mining Contributions to Discrete-event Simulation Modelling

Background: Over the last 20 years, process mining has become a vibrant research area due to the advances in data management technologies and techniques and the advent of new process mining tools. Recently, the links between process mining and simulation modelling have become an area of interest. Objectives: The objective of the paper was to demonstrate and assess the role of process mining results as an input for discrete-event simulation modelling, using two different datasets, one of which is considered data-poor while the other one data-rich. Methods/Approach: Statistical calculations and process maps were prepared and presented based on the event log data from two case studies (smart mobility and higher education) using a process mining tool. Then, the implications of the results across the building blocks (entities, activities, control-flows, and resources) of simulation modelling are discussed. Results: Apart from providing a rationale and the framework for simulation that is more efficient modelling based on process mining results, the paper provides contributions in the two case studies by deliberating and identifying potential research topics that could be tackled and supported by the new combined approach. Conclusions: Event logs and process mining provide valuable information and techniques that could be a useful input for simulation modelling, especially in the first steps of building discrete-event models, but also for validation purposes

Ontology-Driven Extraction of Event Logs from Relational Databases

\u3cp\u3eProcess mining is an emerging discipline whose aim is to discover, monitor and improve real processes by extracting knowledge from event logs representing actual process executions in a given organizational setting. In this light, it can be applied only if faithful event logs, adhering to accepted standards (such as XES), are available. In many real-world settings, though, such event logs are not explicitly given, but are instead implicitly represented inside legacy information systems of organizations, which are typically managed through relational technology. In this work, we devise a novel framework that supports domain experts in the extraction of XES event log information from legacy relational databases, and consequently enables the application of standard process mining tools on such data. Differently from previous work, the extraction is driven by a conceptual representation of the domain of interest in terms of an ontology. On the one hand, this ontology is linked to the underlying legacy data leveraging the well-established ontology-based data access (OBDA) paradigm. On the other hand, our framework allows one to enrich the ontology through user-oriented log extraction annotations, which can be flexibly used to provide different log-oriented views over the data. Different data access modes are then devised so as to view the legacy data through the lens of XES.\u3c/p\u3