{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,8]],"date-time":"2026-06-08T12:48:26Z","timestamp":1780922906865,"version":"3.54.1"},"publisher-location":"Cham","reference-count":17,"publisher":"Springer International Publishing","isbn-type":[{"value":"9783030928742","type":"print"},{"value":"9783030928759","type":"electronic"}],"license":[{"start":{"date-parts":[[2021,12,3]],"date-time":"2021-12-03T00:00:00Z","timestamp":1638489600000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"},{"start":{"date-parts":[[2021,12,3]],"date-time":"2021-12-03T00:00:00Z","timestamp":1638489600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2022]]},"abstract":"<jats:title>Abstract<\/jats:title><jats:p>Process mining studies data-driven methods to discover, enhance, and monitor business processes by gathering knowledge from event logs recorded by modern IT systems. To gain valuable process insights, it is essential for process mining users to formalize their process questions as executable queries. For this purpose, we present the Celonis Process Query Language (Celonis PQL), which is a domain-specific language tailored toward a special process data model and designed for business users. It translates process-related business questions into queries and executes them on a custom-built query engine. Celonis PQL covers a broad set of more than 150 operators, ranging from process-specific functions to machine learning and mathematical operators. Its syntax is inspired by SQL, but specialized for process-related queries. In addition, we present practical use cases and real-world applications, which demonstrate the expressiveness of the language and how business users can apply it to discover, enhance, and monitor business processes. The maturity and feasibility of Celonis PQL is shown by thousands of users from different industries, who apply it to various process types and huge amounts of event data every day.<\/jats:p>","DOI":"10.1007\/978-3-030-92875-9_13","type":"book-chapter","created":{"date-parts":[[2022,4,25]],"date-time":"2022-04-25T17:04:00Z","timestamp":1650906240000},"page":"377-408","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":16,"title":["Celonis PQL: A Query Language for Process Mining"],"prefix":"10.1007","author":[{"given":"Thomas","family":"Vogelgesang","sequence":"first","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Jessica","family":"Ambrosy","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"David","family":"Becher","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Robert","family":"Seilbeck","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Jerome","family":"Geyer-Klingeberg","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Martin","family":"Klenk","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"297","published-online":{"date-parts":[[2021,12,3]]},"reference":[{"key":"13_CR1","unstructured":"Badakhshan, P., Bernhart, G., Geyer-Klingeberg, J., Nakladal, J., Schenk, S., Vogelgesang, T.: The action engine \u2013 turning process insights into action. In: ICPM Demos 2019. CEUR Workshop Proceedings, vol. 2374. CEUR-WS.org (2019). http:\/\/ceur-ws.org\/Vol-2374\/paper8.pdf"},{"key":"13_CR2","unstructured":"Bernstein, P.A., Hadzilacos, V., Goodman, N.: Concurrency Control and Recovery in Database Systems. Addison-Wesley (1987). http:\/\/research.microsoft.com\/en-us\/people\/philbe\/ccontrol.aspx"},{"key":"13_CR3","unstructured":"Berti, A.: Increasing scalability of process mining using event dataframes: How data structure matters. CoRR abs\/1907.12817 (2019). http:\/\/arxiv.org\/abs\/1907.12817"},{"key":"13_CR4","doi-asserted-by":"crossref","unstructured":"Carmona, J., van Dongen, B.F., Solti, A., Weidlich, M.: Conformance Checking - Relating Processes and Models. Springer (2018). https:\/\/doi.org\/10.1007\/978-3-319-99414-7","DOI":"10.1007\/978-3-319-99414-7"},{"key":"13_CR5","unstructured":"Council, T.P.P.: TPC Benchmark H (Decision Support) Standard Specification Revision 2.18.0 (2018). http:\/\/www.tpc.org\/tpc_documents_current_versions\/pdf\/tpc-h_v2.18.0.pdf"},{"key":"13_CR6","first-page":"283","volume":"2019","author":"S Esser","year":"2019","unstructured":"Esser, S., Fahland, D.: Storing and querying multi-dimensional process event logs using graph databases. In: Process Querying (PQ) Workshop 2019, pp. 283\u2013294 (2019)","journal-title":"In: Process Querying (PQ) Workshop"},{"key":"13_CR7","doi-asserted-by":"crossref","unstructured":"Lang, H., M\u00fchlbauer, T., Funke, F., Boncz, P.A., Neumann, T., Kemper, A.: Data blocks: Hybrid OLTP and OLAP on compressed storage using both vectorization and compilation. In: SIGMOD 2016, pp. 311\u2013326. ACM (2016). https:\/\/doi.org\/10.1145\/2882903.2882925","DOI":"10.1145\/2882903.2882925"},{"key":"13_CR8","doi-asserted-by":"crossref","unstructured":"Leemans, S.J.J., Fahland, D., van der Aalst, W.M.P.: Discovering block-structured process models from event logs - A constructive approach. In: PETRI NETS 2013. Lecture Notes in Computer Science, vol. 7927, pp. 311\u2013329. Springer (2013). https:\/\/doi.org\/10.1007\/978-3-642-38697-8_17","DOI":"10.1007\/978-3-642-38697-8_17"},{"key":"13_CR9","doi-asserted-by":"crossref","unstructured":"Leis, V., Boncz, P.A., Kemper, A., Neumann, T.: Morsel-driven parallelism: a NUMA-aware query evaluation framework for the many-core age. In: SIGMOD 2014, pp. 743\u2013754. ACM (2014). https:\/\/doi.org\/10.1145\/2588555.2610507","DOI":"10.1145\/2588555.2610507"},{"key":"13_CR10","unstructured":"M\u00fcller, I., Ratsch, C., F\u00e4rber, F.: Adaptive string dictionary compression in in-memory column-store database systems. In: Proceedings of the EDBT 2014, pp. 283\u2013294. OpenProceedings.org (2014). https:\/\/doi.org\/10.5441\/002\/edbt.2014.27"},{"key":"13_CR11","doi-asserted-by":"crossref","unstructured":"Neumann, T.: Efficiently compiling efficient query plans for modern hardware. PVLDB 4(9), 539\u2013550 (2011). https:\/\/doi.org\/10.14778\/2002938.2002940. http:\/\/www.vldb.org\/pvldb\/vol4\/p539-neumann.pdf","DOI":"10.14778\/2002938.2002940"},{"key":"13_CR12","unstructured":"OMG: Business Process Model and Notation (BPMN), Version 2.0 (2011). http:\/\/www.omg.org\/spec\/BPMN\/2.0"},{"key":"13_CR13","doi-asserted-by":"publisher","first-page":"41","DOI":"10.1016\/j.dss.2017.04.011","volume":"100","author":"A Polyvyanyy","year":"2017","unstructured":"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\u201356 (2017). https:\/\/doi.org\/10.1016\/j.dss.2017.04.011","journal-title":"Decis. Support Syst."},{"key":"13_CR14","doi-asserted-by":"crossref","unstructured":"Sch\u00fcle, M., Schliski, P., Hutzelmann, T., Rosenberger, T., Leis, V., Vorona, D., Kemper, A., Neumann, T.: Monopedia: Staying single is good enough - the hyper way for Web scale applications. PVLDB 10(12), 1921\u20131924 (2017). https:\/\/doi.org\/10.14778\/3137765.3137809. http:\/\/www.vldb.org\/pvldb\/vol10\/p1921-schuele.pdf","DOI":"10.14778\/3137765.3137809"},{"key":"13_CR15","doi-asserted-by":"crossref","unstructured":"van der Aalst, W.M.P.: Process Mining - Data Science in Action, Second Edition. Springer (2016). https:\/\/doi.org\/10.1007\/978-3-662-49851-4","DOI":"10.1007\/978-3-662-49851-4_1"},{"key":"13_CR16","unstructured":"Veit, F., Geyer-Klingeberg, J., Madrzak, J., Haug, M., Thomson, J.: The proactive insights engine: Process mining meets machine learning and artificial intelligence. In: BPM Demos 2017. CEUR Workshop Proceedings, vol. 1920. CEUR-WS.org (2017). http:\/\/ceur-ws.org\/Vol-1920\/BPM_2017_paper_192.pdf"},{"key":"13_CR17","doi-asserted-by":"publisher","unstructured":"Weijters, A.J.M.M., Ribeiro, J.T.S.: Flexible heuristics miner (FHM). In: Proceedings of the IEEE CIDM 2011, pp. 310\u2013317. IEEE (2011). https:\/\/doi.org\/10.1109\/CIDM.2011.5949453","DOI":"10.1109\/CIDM.2011.5949453"}],"container-title":["Process Querying Methods"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-030-92875-9_13","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,4,25]],"date-time":"2022-04-25T17:20:46Z","timestamp":1650907246000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-030-92875-9_13"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2021,12,3]]},"ISBN":["9783030928742","9783030928759"],"references-count":17,"URL":"https:\/\/doi.org\/10.1007\/978-3-030-92875-9_13","relation":{},"subject":[],"published":{"date-parts":[[2021,12,3]]},"assertion":[{"value":"3 December 2021","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}}]}}