Skip to main content
Top

2019 | OriginalPaper | Chapter

Storing and Querying Multi-dimensional Process Event Logs Using Graph Databases

Authors : Stefan Esser, Dirk Fahland

Published in: Business Process Management Workshops

Publisher: Springer International Publishing

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

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.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literature
4.
go back to reference Bottrighi, A., Canensi, L., Leonardi, G., Montani, S., Terenziani, P.: Trace retrieval for business process operational support. Expert Syst. Appl. 55, 212–221 (2016)CrossRef Bottrighi, A., Canensi, L., Leonardi, G., Montani, S., Terenziani, P.: Trace retrieval for business process operational support. Expert Syst. Appl. 55, 212–221 (2016)CrossRef
5.
go back to reference Cuevas-Vicenttín, V., Dey, S.C., Wang, M.L.Y., Song, T., Ludäscher, B.: Modeling and querying scientific workflow provenance in the D-OPM. In: 2012 SC Companion, pp. 119–128. IEEE Computer Society (2012) Cuevas-Vicenttín, V., Dey, S.C., Wang, M.L.Y., Song, T., Ludäscher, B.: Modeling and querying scientific workflow provenance in the D-OPM. In: 2012 SC Companion, pp. 119–128. IEEE Computer Society (2012)
6.
go back to reference Deutch, D., Milo, T.: TOP-K projection queries for probabilistic business processes. In: ICDT 2009, ACM International Conference Proceeding Series, vol. 361, pp. 239–251. ACM (2009) Deutch, D., Milo, T.: TOP-K projection queries for probabilistic business processes. In: ICDT 2009, ACM International Conference Proceeding Series, vol. 361, pp. 239–251. ACM (2009)
9.
go back to reference Francis, N., et al.: Cypher: an evolving query language for property graphs. In: Management of Data, pp. 1433–1445. ACM (2018) Francis, N., et al.: Cypher: an evolving query language for property graphs. In: Management of Data, pp. 1433–1445. ACM (2018)
10.
go back to reference Gonzalez Lopez de Murillas, E.: Process mining on databases: extracting event data from real-life data sources. Ph.D. thesis, Department of Mathematics and Computer Science, proefschrift, February 2019 Gonzalez Lopez de Murillas, E.: Process mining on databases: extracting event data from real-life data sources. Ph.D. thesis, Department of Mathematics and Computer Science, proefschrift, February 2019
11.
go back to reference Huang, X., Bao, Z., Davidson, S.B., Milo, T., Yuan, X.: Answering regular path queries on workflow provenance. In: ICDE 2015, pp. 375–386. IEEE Computer Society (2015) Huang, X., Bao, Z., Davidson, S.B., Milo, T., Yuan, X.: Answering regular path queries on workflow provenance. In: ICDE 2015, pp. 375–386. IEEE Computer Society (2015)
13.
go back to reference Liu, D., Pedrinaci, C., Domingue, J.: Semantic enabled complex event language for business process monitoring. In: 4th International Workshop on Semantic Business Process Management, pp. 31–34 (2009) Liu, D., Pedrinaci, C., Domingue, J.: Semantic enabled complex event language for business process monitoring. In: 4th International Workshop on Semantic Business Process Management, pp. 31–34 (2009)
14.
go back to reference Lu, X., Nagelkerke, M., van de Wiel, D., Fahland, D.: Discovering interacting artifacts from ERP systems. IEEE Trans. Serv. Comput. 8(6), 861–873 (2015)CrossRef Lu, X., Nagelkerke, M., van de Wiel, D., Fahland, D.: Discovering interacting artifacts from ERP systems. IEEE Trans. Serv. Comput. 8(6), 861–873 (2015)CrossRef
16.
go back to reference de Murillas, E.G.L., Reijers, H.A., van der Aalst, W.M.P.: Connecting databases with process mining: a meta model and toolset. Softw. Syst. Model. 18(2), 1209–1247 (2019)CrossRef de Murillas, E.G.L., Reijers, H.A., van der Aalst, W.M.P.: Connecting databases with process mining: a meta model and toolset. Softw. Syst. Model. 18(2), 1209–1247 (2019)CrossRef
18.
go back to reference Robinson, I., Webber, J., Eifrem, E.: Graph Databases. O’Reilly Media (2013) Robinson, I., Webber, J., Eifrem, E.: Graph Databases. O’Reilly Media (2013)
19.
go back to reference Song, L., Wang, J., Wen, L., Wang, W., Tan, S., Kong, H.: Querying process models based on the temporal relations between tasks. In: EDOCW 2011, pp. 213–222. IEEE Computer Society (2011) Song, L., Wang, J., Wen, L., Wang, W., Tan, S., Kong, H.: Querying process models based on the temporal relations between tasks. In: EDOCW 2011, pp. 213–222. IEEE Computer Society (2011)
20.
go back to reference Tang, Y., Mackey, I., Su, J.: Querying workflow logs. Information 9(2), 25 (2018)CrossRef Tang, Y., Mackey, I., Su, J.: Querying workflow logs. Information 9(2), 25 (2018)CrossRef
Metadata
Title
Storing and Querying Multi-dimensional Process Event Logs Using Graph Databases
Authors
Stefan Esser
Dirk Fahland
Copyright Year
2019
DOI
https://doi.org/10.1007/978-3-030-37453-2_51

Premium Partner