Native Directly Follows Operator

06/05/2018
by   Alifah Syamsiyah, et al.
0

Typical legacy information systems store data in relational databases. Process mining is a research discipline that analyzes this data to obtain insights into processes. Many different process mining techniques can be applied to data. In current techniques, an XES event log serves as a basis for analysis. However, because of the static characteristic of an XES event log, we need to create one XES file for each process mining question, which leads to overhead and inflexibility. As an alternative, people attempt to perform process mining directly on the data source using so-called intermediate structures. In previous work, we investigated methods to build intermediate structures on source data by executing a basic SQL query on the database. However, the nested form in the SQL query can cause performance issues on the database side. Therefore, in this paper, we propose a native SQL operator for direct process discovery on relational databases. We define a native operator for the simplest form of the intermediate structure, called the "directly follows relation". This approach has been evaluated with big event data and the experimental results show that it performs faster than the state-of-the-art of database approaches.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
06/26/2017

Relational Algebra for In-Database Process Mining

The execution logs that are used for process mining in practice are ofte...
research
02/16/2022

Causal Process Mining from Relational Databases with Domain Knowledge

The plethora of algorithms in the research field of process mining build...
research
07/18/2020

Graph-based process mining

Process mining is an area of research that supports discovering informat...
research
07/30/2019

Increasing Scalability of Process Mining using Event Dataframes: How Data Structure Matters

Process Mining is a branch of Data Science that aims to extract process-...
research
07/26/2017

A Comparative Analysis of XML Documents, XML Enabled Databases and Native XML Databases

With the increasing popularity of XML data and a great need for a databa...
research
04/01/2019

Data warehouse on Manpower Employment for Decision Support System

Since the use of computers in the business world, data collection has be...
research
12/13/2022

Interactive Process Identification and Selection from SAP ERP

SAP ERP is one of the most popular information systems supporting variou...

Please sign up or login with your details

Forgot password? Click here to reset