Multi-Dimensional Event Data in Graph Databases

05/29/2020
by   Stefan Esser, et al.
0

Process event data is usually stored either in a sequential process event log or in a relational database. While the sequential, single-dimensional nature of event logs aids querying for (sub)sequences of events based on temporal relations such as "directly/eventually-follows", it does not support querying multi-dimensional event data of multiple related entities. Relational databases allow storing multi-dimensional event data but existing query languages do not support querying for sequences or paths of events in terms of temporal relations. In this paper, we propose a general data model for multi-dimensional event data based on labeled property graphs that allows storing structural and temporal relations in a single, integrated graph-based data structure in a systematic way. We provide semantics for all concepts of our data model, and generic queries for modeling event data over multiple entities that interact synchronously and asynchronously . The queries allow for efficiently converting large real-life event data sets into our data model and we provide 5 converted data sets for further research. We show that typical and advanced queries for retrieving and aggregating such multidimensional event data can be formulated and executed efficiently in the existing query language Cypher, giving rise to several new research questions. Specifically aggregation queries on our data model enable process mining over multiple interrelated entities using off-the-shelf technology.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
12/24/2018

PatientEG Dataset: Bringing Event Graph Model with Temporal Relations to Electronic Medical Records

Medical activities, such as diagnoses, medicine treatments, and laborato...
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
11/26/2021

Bitemporal Property Graphs to Organize Evolving Systems

This work is a summarized view on the results of a one-year cooperation ...
research
12/13/2022

Interactive Process Identification and Selection from SAP ERP

SAP ERP is one of the most popular information systems supporting variou...
research
07/29/2018

DataJoint: A Simpler Relational Data Model

The relational data model offers unrivaled rigor and precision in defini...
research
02/13/2019

Snapshot Semantics for Temporal Multiset Relations (Extended Version)

Snapshot semantics is widely used for evaluating queries over temporal d...
research
09/03/2019

Online Analytical Processsing on Graph Data

Online Analytical Processing (OLAP) comprises tools and algorithms that ...

Please sign up or login with your details

Forgot password? Click here to reset