Skip to main content

LoVizQL: A Query Language for Visualizing and Analyzing Business Processes from Event Logs

  • Conference paper
  • First Online:
Service-Oriented Computing (ICSOC 2023)

Abstract

Process event logs record information about the execution of the activities of a business process. Process mining techniques use these event logs to discover, analyze, and optimize business processes. Process mining tools offer many functionalities such as data filtering, process discovery, process visualization, or conformance checking. Process visualization is generally based on Directly-Follows Graphs (DFGs), where each node represents an activity of the process, and each transition represents a directly-follows relation between nodes (activities). A workflow frequently followed by process mining analysts involves manually comparing the DFGs of different event log subsets (e.g., subsets belonging to different product categories in a purchase-to-pay process) to identify patterns or behaviors in the process data (e.g., delays in process execution). However, performing this type of analysis with current process mining tools is usually a time-consuming task, especially if the number of event log subsets analyzed is large. This research aims to address this limitation by presenting LoVizQL, a query language to obtain collections of DFGs that meet specific user-defined conditions in the queries. The language is evaluated using reports belonging to various Business Process Intelligence Challenges. The evaluation demonstrates that LoVizQL covers analyses found in real scenarios and reduces the effort to find specific subsets of event log data and their corresponding DFGs.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 49.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 64.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

Notes

  1. 1.

    According to the XES standard, “concept:name" refers to the activity names.

  2. 2.

    https://doi.org/10.5281/zenodo.8182758.

References

  1. van der Aalst, W.M.P.: A practitioner’s guide to process mining: limitations of the directly-follows graph. Procedia Comput. Sci. 164, 321–328 (2019)

    Article  Google Scholar 

  2. Beheshti, A., Benatallah, B., Motahari-Nezhad, H.R., Ghodratnama, S., Amouzgar, F.: BP-SPARQL: a query language for summarizing and analyzing big process data. In: Polyvyanyy, A. (ed.) Process Querying Methods, pp. 21–48. Springer, Cham (2022). https://doi.org/10.1007/978-3-030-92875-9_2

    Chapter  Google Scholar 

  3. Capitán-Agudo, C., Salas-Urbano, M., Cabanillas, C., Resinas, M.: Analyzing how process mining reports answer time performance questions. In: Di Ciccio, C., Dijkman, R., del Río Ortega, A., Rinderle-Ma, S. (eds.) BPM 2022. LNCS, vol. 13420, pp. 234–250. Springer, Cham (2022). https://doi.org/10.1007/978-3-031-16103-2_17

    Chapter  Google Scholar 

  4. van Dongen, B.: BPI Challenge 2015. 4TU.ResearchData (2015). https://doi.org/10.4121/uuid:31a308ef-c844-48da-948c-305d167a0ec1

  5. van Dongen, B.: BPI Challenge 2019. 4TU.ResearchData (2019). https://doi.org/10.4121/uuid:d06aff4b-79f0-45e6-8ec8-e19730c248f1

  6. van Dongen, B.: BPI Challenge 2020. 4TU.ResearchData (2020). https://doi.org/10.4121/uuid:52fb97d4-4588-43c9-9d04-3604d4613b51

  7. Dumas, M., La Rosa, M., Mendling, J., Reijers, H.A.: Fundamentals of Business Process Management, 2nd edn. Springer, Heidelberg (2018). https://doi.org/10.1007/978-3-662-56509-4

    Book  Google Scholar 

  8. van der Ham, U.: Benchmarking of five dutch municipalities with process mining techniques reveals opportunities for improvement. Technical report, BPI Challenge (2015)

    Google Scholar 

  9. Kim, J., Ko, J., Lee, S.: Business Process Intelligence Challenge 2019: Process discovery and deviation analysis of purchase order handling process. Technical report, BPI Challenge (2019)

    Google Scholar 

  10. Klinkmüller, C., Müller, R., Weber, I.: Mining process mining practices: an exploratory characterization of information needs in process analytics. In: Business Process Management (BPM), pp. 322–337 (2019)

    Google Scholar 

  11. Momotko, M., Subieta, K.: Business process query language. In: Polyvyanyy, A. (ed.) Process Querying Methods, pp. 345–376. Springer, Cham (2022). https://doi.org/10.1007/978-3-030-92875-9_12

    Chapter  Google Scholar 

  12. González López de Murillas, E., Reijers, H.A., van der Aalst, W.M.P.: Everything you always wanted to know about your process, but did not know how to ask. In: BPM Workshops, vol. 281, pp. 296–309 (2017)

    Google Scholar 

  13. Polyvyanyy, A.: Process Querying Methods. Springer, Cham (2022). https://doi.org/10.1007/978-3-030-92875-9

    Book  Google Scholar 

  14. Polyvyanyy, A., Ouyang, C., Barros, A., van der Aalst, W.M.P.: Process querying: enabling business intelligence through query-based process analytics. Decis. Support Syst. 100, 41–56 (2017)

    Article  Google Scholar 

  15. Schuster, D., Martini, M., van Zelst, S.J., van der Aalst, W.M.P.: Control-flow-based querying of process executions from partially ordered event data. In: Service-Oriented Computing (ICSOC), pp. 19–35 (2022)

    Google Scholar 

  16. Seeliger, A., Sánchez Guinea, A., Nolle, T., Mühlhäuser, M.: ProcessExplorer: intelligent process mining guidance. In: Business Process Management (BPM), pp. 216–231 (2019)

    Google Scholar 

  17. Siddiqui, T., Kim, A., Lee, J., Karahalios, K., Parameswaran, A.: Effortless data exploration with zenvisage: an expressive and interactive visual analytics system. Proc. VLDB Endow. 10(4), 457–468 (2016)

    Article  Google Scholar 

  18. Tang, Y., Cui, W., Su, J.: A query language for workflow logs. ACM Trans. Manage. Inf. Syst. 13(2), 1–28 (2021)

    Article  Google Scholar 

  19. Vogelgesang, T., Ambrosy, J., Becher, D., Seilbeck, R., Geyer-Klingeberg, J., Klenk, M.: Celonis PQL: a query language for process mining. In: Polyvyanyy, A. (ed.) Process Querying Methods, pp. 377–408. Springer, Cham (2022). https://doi.org/10.1007/978-3-030-92875-9_13

    Chapter  Google Scholar 

  20. Wirth, N.: What can we do about the unnecessary diversity of notation for syntactic definitions? Commun. ACM 20(11), 822–823 (1977)

    Article  Google Scholar 

  21. Álvarez, J.M.P., Díaz, A.C., Parody, L., Quintero, A.M.R., Gómez-López, M.T.: Process instance query language and the process querying framework. In: Polyvyanyy, A. (ed.) Process Querying Methods, pp. 85–111. Springer, Cham (2022). https://doi.org/10.1007/978-3-030-92875-9_4

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to María Salas-Urbano .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2023 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Salas-Urbano, M., Capitán-Agudo, C., Cabanillas, C., Resinas, M. (2023). LoVizQL: A Query Language for Visualizing and Analyzing Business Processes from Event Logs. In: Monti, F., Rinderle-Ma, S., Ruiz Cortés, A., Zheng, Z., Mecella, M. (eds) Service-Oriented Computing. ICSOC 2023. Lecture Notes in Computer Science, vol 14420. Springer, Cham. https://doi.org/10.1007/978-3-031-48424-7_2

Download citation

  • DOI: https://doi.org/10.1007/978-3-031-48424-7_2

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-031-48423-0

  • Online ISBN: 978-3-031-48424-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics