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

    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 - 1 Jan 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 Sep 20196 Sep 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
    CountryAustria
    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