Umeå University's logo

umu.sePublications
Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
One language to rule them all: behavioural querying of process data using SQL
Humboldt-Universität zu Berlin, Berlin, Germany.
Umeå University, Faculty of Science and Technology, Department of Computing Science. SAP Signavio. (Interactive and Intelligent Systems Group)ORCID iD: 0000-0002-6458-2252
Umeå University, Faculty of Science and Technology, Department of Computing Science.ORCID iD: 0000-0002-7742-0439
Humboldt-Universität zu Berlin, Berlin, Germany; SAP Signavio.
2025 (English)In: Process mining workshops / [ed] Andrea Delgado; Tijs Slaats, Cham: Springer Nature, 2025, p. 18-30Chapter in book (Refereed)
Abstract [en]

State-of-the-art solutions for process mining rely on proprietary, domain-specific languages to query data recorded during business process execution. To support common analysis tasks, these languages focus on the definition of queries for behavioural patterns. Yet, the use of domain-specific languages for process mining has drawbacks: they require specific user training, lead to a decoupling of the query models for (i) data extraction and transformation, and (ii) the actual analysis, and induce engineering overhead through the development of a dedicated query engine. In this work, we therefore explore the use of standard SQL for process mining tasks. In particular, we demonstrate that the SQL concepts for row pattern recognition as realised by the MATCH_RECOGNIZE clause are sufficient to capture queries for behavioural patterns as specified in the SIGNAL language by SAP Signavio as well as the Process Querying Language (PQL) by Celonis. Based on a discussion of the respective language features, we outline a translation of SIGNAL and PQL queries into standard SQL. This way, we provide the basis for the adoption of widely used, general purpose query engines for process mining tasks.

Place, publisher, year, edition, pages
Cham: Springer Nature, 2025. p. 18-30
Series
Lecture Notes in Business Information Processing ; 533
Keywords [en]
Process Querying, Process Mining, Pattern Recognition
National Category
Computer Sciences
Research subject
Computer Science
Identifiers
URN: urn:nbn:se:umu:diva-237256DOI: 10.1007/978-3-031-82225-4_2Scopus ID: 2-s2.0-105002040834OAI: oai:DiVA.org:umu-237256DiVA, id: diva2:1949921
Conference
ICPM 2024 International Workshops, Lyngby, Denmark, October 14–18, 2024
Available from: 2025-04-03 Created: 2025-04-03 Last updated: 2025-05-06Bibliographically approved

Open Access in DiVA

fulltext(486 kB)22 downloads
File information
File name FULLTEXT01.pdfFile size 486 kBChecksum SHA-512
a75773d0958c9aaa9318ee7688c1ba21b0c61a76b6e2c025dfc28b8fc86c6c9bae775b2514246f8b148b66ba73b67736fea5264f753151567d224a50e19a3aab
Type fulltextMimetype application/pdf

Other links

Publisher's full textScopus

Authority records

Kampik, TimotheusOkulmus, Cem

Search in DiVA

By author/editor
Kampik, TimotheusOkulmus, Cem
By organisation
Department of Computing Science
Computer Sciences

Search outside of DiVA

GoogleGoogle Scholar
Total: 22 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

doi
urn-nbn

Altmetric score

doi
urn-nbn
Total: 323 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf