scispace - formally typeset
Open AccessBook ChapterDOI

Connecting Databases with Process Mining: A Meta Model and Toolset

About
This article is published in Exploring Modeling Methods for Systems Analysis and Design.The article was published on 2016-06-13 and is currently open access. It has received 39 citations till now. The article focuses on the topics: Database schema & Process mining.

read more

Content maybe subject to copyright    Report

Citations
More filters
Book ChapterDOI

Object-Centric Process Mining: Dealing with Divergence and Convergence in Event Data

TL;DR: The gap between real event data and the event logs required by traditional process mining techniques is discussed and a specific logging format is proposed where events can be related to objects of different types.
Journal ArticleDOI

Connecting Databases with Process Mining: A Meta Model and Toolset

TL;DR: In this article, the authors propose a meta model to integrate both process and data perspectives, relating one to the other and allowing to generate different views from it at any moment in a highly flexible way.
Book ChapterDOI

Extracting Object-Centric Event Logs to Support Process Mining on Databases

TL;DR: This paper proposes an approach to extract, transform and store object-centric data, resulting in eXtensible Object-Centric (XOC) event logs, which does not require a case notion to avoid flattening multi-dimensional data.
Journal ArticleDOI

How active learning and process mining can act as Continuous Auditing catalyst

TL;DR: This paper presents an actionable framework to address one specific level of continuous auditing: the transaction verification level, which combines the techniques of data mining and process mining on one hand, and includes the auditor as a human expert to deal with the typical alarm flood.
Book ChapterDOI

From Relational Database to Event Log: Decisions with Quality Impact

TL;DR: This work relates to other studies on how to build an event log from relational databases, but puts more emphasis on how the technical decisions have a direct impact on the analyses of the practitioner that will use the event log afterwards.
References
More filters
Book ChapterDOI

XES, XESame, and ProM 6

TL;DR: Two tools that use the eXtensible Event Stream format are presented - XESame and ProM 6 - and the main innovations and the role of XES are highlighted.
Book ChapterDOI

Modeling and enacting complex data dependencies in business processes

TL;DR: This paper extends BPMN data objects with few annotations to allow data dependency handling as well as data instance differentiation and introduces a pattern-based approach to derive SQL queries from process models utilizing the above mentioned extensions.
Book ChapterDOI

Extracting Event Data from Databases to Unleash Process Mining

TL;DR: A novel perspective is used to conceptualize a database view on event data that scopes, binds, and classifies data to create “flat” event logs that can be analyzed using traditional process-mining techniques.
Journal ArticleDOI

On multi-column foreign key discovery

TL;DR: This work proposes a robust algorithm for discovering single-column and multi-column foreign keys using a general rule, termed Randomness, that subsumes a variety of other rules and develops efficient approximation algorithms for evaluating randomness, using only two passes over the data.
Book ChapterDOI

Preprocessing support for large scale process mining of SAP transactions

TL;DR: An ERP log analysis system that allows the users to define at a meta level how events, resources and their inter-relations are stored and transformed for use in process mining is described.
Related Papers (5)
Frequently Asked Questions (13)
Q1. What have the authors contributed in "Connecting databases with process mining: a meta model and toolset" ?

This paper proposes a meta model to integrate both process and data perspectives, relating one to the other. 

Process discovery, conformance and compliance checking, performance analysis, process monitoring and prediction, and operational support are some of the techniques that process mining provides to better understand and improve business processes. 

in order to make them as flexible as possible, the implementation tries to be independent of the specific storage technology running underneath. 

To have a better view on performance metrics and accurate task duration, the life-cycle attribute should be properly assigned to pair events in activity instances. 

The main flaw of most of these approaches resides in the way they force the representation of complex systems by means of a flat event log. 

Because the meta model structure and the data inserted into it are stored in a SQLite file, it is possible to execute SQL queries in a straightforward way. 

As demonstrated with this example, the proposed meta model is able to merge information from different systems into a single structure, enabling the analysis of process and data in a holistic way, beyond the boundaries of IT systems infrastructure. 

The goal of providing these tools is to assist in the task of populating the proposed meta model, in order to query it in a posterior step. 

To be able to combine the data and process perspectives in a single structure, it is important to define a set of requirements that a meta model must fulfill. 

Table 5 shows that, in order to populate their meta model, what the authors obtain from SAP are the following entities: data model, class, attribute, object and event. 

These sectors: data models, objects, versions, events, cases and process models contain tightly related concepts and provide an abbreviated representation of the meta model. 

The main advantage of transforming all their source information into the proposedmetamodel structure is that, regardless of the origin of data, the authors can pose questions in a standard way. 

Starting from this input and applying schema, primary key and foreign key discovery techniques [17,25], it is possible to obtain a data model describing the structure of the original data.