Merging eventlogs for process mining

Introduction
I am using the following SQL query to join eventlogs from multiple applications into one log. According to the literature this is called a ‘raw data merge’. I like this kind of join since it is adaptable and quicker when merging logs from more than two applications. The results of this query can be further processed by exporting them as a CSV and loading them into a conversion tool for eventlogs (XESame, Disco/Nitro, ProM Import).

Goal
To merge cleaned logging data and output in a suitable format for conversion to .xes or .mxml.

Usage instructions
1. Export logfiles from an application that fulfill the requirements for process mining (see image).
2. Import some logfiles into a database, one table per file (for example CSV file import using SQL developer and Oracle XE db).
3. Clean the data by making case id and timestamp format match. Also make sure the appropriate datatypes are used.
4. Adapt the following query to suit your situation and execute.
5. Export the results to a CSV file (SQL developer: right click, export, CSV file).
6. Convert the CSV file with the merged logs using a conversion tool.
7. Analyse the eventlog using a process mining tool (Disco, ProM, …)

Images

SQL query for merging multiple eventlogs
SQL query for merging eventlogs Creative Commons-Licentie
Source:
Eventlog format and requirements. Source: http://fluxicon.com/disco/files/Disco-User-Guide.pdf
Advertenties

Geef een reactie

Vul je gegevens in of klik op een icoon om in te loggen.

WordPress.com logo

Je reageert onder je WordPress.com account. Log uit / Bijwerken )

Twitter-afbeelding

Je reageert onder je Twitter account. Log uit / Bijwerken )

Facebook foto

Je reageert onder je Facebook account. Log uit / Bijwerken )

Google+ photo

Je reageert onder je Google+ account. Log uit / Bijwerken )

Verbinden met %s