Skip to main content

2019 | OriginalPaper | Buchkapitel

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

verfasst von : Stefan Esser, Dirk Fahland

Erschienen in: Business Process Management Workshops

Verlag: Springer International Publishing

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

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.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

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!

Literatur
4.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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
Metadaten
Titel
Storing and Querying Multi-dimensional Process Event Logs Using Graph Databases
verfasst von
Stefan Esser
Dirk Fahland
Copyright-Jahr
2019
DOI
https://doi.org/10.1007/978-3-030-37453-2_51

Premium Partner