Storing and querying multi-dimensional process event logs using graph databases

Stefan Esser, Dirk Fahland

Research output: Chapter in Book/Report/Conference proceedingConference contributionAcademicpeer-review

6 Citations (Scopus)

Abstract

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 report on an exploratory case study to store multi-dimensional event data in labeled property graphs and to query the graphs for structural and temporal relations combined. Our main finding is that event data over multiple entities and identifiers with complex relationships can be stored in graph databases in a systematic way. Typical and advanced queries over such multi-dimensional event data can be formulated in the query language Cypher and can be executed efficiently, giving rise to several new research questions.

Original languageEnglish
Title of host publicationBusiness Process Management Workshops - BPM 2019 International Workshops, Revised Selected Papers
EditorsChiara Di Francescomarino, Remco Dijkman, Uwe Zdun
Place of PublicationCham
PublisherSpringer
Pages632-644
Number of pages13
ISBN (Electronic)978-3-030-37453-2
ISBN (Print)978-3-030-37452-5
DOIs
Publication statusPublished - 2019
EventInternational Workshops on AI4BPM, BP-Meet-IoT, BPI, BPMinDIT, BPMS2, DEC2H, MIEL, PM-DiPro, PODS4H, PQ, SPBP, VEnMo 2019 held at the 17th International Conference on Business Process Management, BPM 2019 - Vienna, Austria
Duration: 1 Sept 20196 Sept 2019

Publication series

NameLecture Notes in Business Information Processing
Volume362 LNBIP
ISSN (Print)1865-1348
ISSN (Electronic)1865-1356

Conference

ConferenceInternational Workshops on AI4BPM, BP-Meet-IoT, BPI, BPMinDIT, BPMS2, DEC2H, MIEL, PM-DiPro, PODS4H, PQ, SPBP, VEnMo 2019 held at the 17th International Conference on Business Process Management, BPM 2019
Country/TerritoryAustria
CityVienna
Period1/09/196/09/19

Keywords

  • Event log
  • Graph databases
  • Labeled property graphs
  • Multi-dimensional processes
  • Process mining
  • Querying

Fingerprint

Dive into the research topics of 'Storing and querying multi-dimensional process event logs using graph databases'. Together they form a unique fingerprint.

Cite this