{"id":"https://openalex.org/W2942514375","doi":"https://doi.org/10.1145/3297280.3297532","title":"Configuring SQL-based process mining for performance and storage optimisation","display_name":"Configuring SQL-based process mining for performance and storage optimisation","publication_year":2019,"publication_date":"2019-04-08","ids":{"openalex":"https://openalex.org/W2942514375","doi":"https://doi.org/10.1145/3297280.3297532","mag":"2942514375"},"language":"en","primary_location":{"id":"doi:10.1145/3297280.3297532","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3297280.3297532","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 34th ACM/SIGAPP Symposium on Applied Computing","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://hdl.handle.net/11573/1361963","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5036711680","display_name":"Stefan Sch\u00f6nig","orcid":"https://orcid.org/0000-0002-7666-4482"},"institutions":[{"id":"https://openalex.org/I54009628","display_name":"University of Bayreuth","ror":"https://ror.org/0234wmv40","country_code":"DE","type":"education","lineage":["https://openalex.org/I54009628"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Stefan Sch\u00f6nig","raw_affiliation_strings":["University of Bayreuth, Bayreuth, Germany"],"affiliations":[{"raw_affiliation_string":"University of Bayreuth, Bayreuth, Germany","institution_ids":["https://openalex.org/I54009628"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007015446","display_name":"Claudio Di Ciccio","orcid":"https://orcid.org/0000-0001-5570-0475"},"institutions":[{"id":"https://openalex.org/I102248843","display_name":"Vienna University of Economics and Business","ror":"https://ror.org/03yn8s215","country_code":"AT","type":"education","lineage":["https://openalex.org/I102248843"]}],"countries":["AT"],"is_corresponding":false,"raw_author_name":"Claudio Di Ciccio","raw_affiliation_strings":["Vienna University of Economics and Business, Vienna, Austria"],"affiliations":[{"raw_affiliation_string":"Vienna University of Economics and Business, Vienna, Austria","institution_ids":["https://openalex.org/I102248843"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5062764959","display_name":"Jan Mendling","orcid":"https://orcid.org/0000-0002-7260-524X"},"institutions":[{"id":"https://openalex.org/I102248843","display_name":"Vienna University of Economics and Business","ror":"https://ror.org/03yn8s215","country_code":"AT","type":"education","lineage":["https://openalex.org/I102248843"]}],"countries":["AT"],"is_corresponding":false,"raw_author_name":"Jan Mendling","raw_affiliation_strings":["Vienna University of Economics and Business, Vienna, Austria"],"affiliations":[{"raw_affiliation_string":"Vienna University of Economics and Business, Vienna, Austria","institution_ids":["https://openalex.org/I102248843"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5036711680"],"corresponding_institution_ids":["https://openalex.org/I54009628"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.04326084,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"94","last_page":"97"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10703","display_name":"Business Process Modeling and Analysis","score":1.0,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T10703","display_name":"Business Process Modeling and Analysis","score":1.0,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9958000183105469,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9912999868392944,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8526329398155212},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7692774534225464},{"id":"https://openalex.org/keywords/process-mining","display_name":"Process mining","score":0.7163271307945251},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.680753231048584},{"id":"https://openalex.org/keywords/event","display_name":"Event (particle physics)","score":0.5925028920173645},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5475748777389526},{"id":"https://openalex.org/keywords/conformance-checking","display_name":"Conformance checking","score":0.5411126017570496},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.49630481004714966},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.4939935803413391},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4708060026168823},{"id":"https://openalex.org/keywords/business-process-discovery","display_name":"Business process discovery","score":0.43374791741371155},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.3395040035247803},{"id":"https://openalex.org/keywords/work-in-process","display_name":"Work in process","score":0.26925525069236755},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.22027364373207092},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1466151475906372},{"id":"https://openalex.org/keywords/business-process","display_name":"Business process","score":0.13360676169395447},{"id":"https://openalex.org/keywords/business-process-management","display_name":"Business process management","score":0.10020563006401062}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8526329398155212},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7692774534225464},{"id":"https://openalex.org/C124670913","wikidata":"https://www.wikidata.org/wiki/Q2608526","display_name":"Process mining","level":5,"score":0.7163271307945251},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.680753231048584},{"id":"https://openalex.org/C2779662365","wikidata":"https://www.wikidata.org/wiki/Q5416694","display_name":"Event (particle physics)","level":2,"score":0.5925028920173645},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5475748777389526},{"id":"https://openalex.org/C2775948798","wikidata":"https://www.wikidata.org/wiki/Q5160261","display_name":"Conformance checking","level":5,"score":0.5411126017570496},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.49630481004714966},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4939935803413391},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4708060026168823},{"id":"https://openalex.org/C93453677","wikidata":"https://www.wikidata.org/wiki/Q1017580","display_name":"Business process discovery","level":5,"score":0.43374791741371155},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.3395040035247803},{"id":"https://openalex.org/C174998907","wikidata":"https://www.wikidata.org/wiki/Q357662","display_name":"Work in process","level":2,"score":0.26925525069236755},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.22027364373207092},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1466151475906372},{"id":"https://openalex.org/C85345410","wikidata":"https://www.wikidata.org/wiki/Q851587","display_name":"Business process","level":3,"score":0.13360676169395447},{"id":"https://openalex.org/C80309976","wikidata":"https://www.wikidata.org/wiki/Q7007379","display_name":"Business process management","level":4,"score":0.10020563006401062},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0},{"id":"https://openalex.org/C207505557","wikidata":"https://www.wikidata.org/wiki/Q4374012","display_name":"Business process modeling","level":4,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/3297280.3297532","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3297280.3297532","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 34th ACM/SIGAPP Symposium on Applied Computing","raw_type":"proceedings-article"},{"id":"pmh:oai::49142","is_oa":false,"landing_page_url":"https://eref.uni-bayreuth.de/49142/","pdf_url":null,"source":{"id":"https://openalex.org/S4377196442","display_name":"ERef Bayreuth (University of Bayreuth)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I54009628","host_organization_name":"University of Bayreuth","host_organization_lineage":["https://openalex.org/I54009628"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Aufsatz in einem Buch"},{"id":"pmh:oai:iris.uniroma1.it:11573/1361963","is_oa":true,"landing_page_url":"http://hdl.handle.net/11573/1361963","pdf_url":null,"source":{"id":"https://openalex.org/S4377196107","display_name":"IRIS Research product catalog (Sapienza University of Rome)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/conferenceObject"},{"id":"pmh:oai:research.wu.ac.at:openaire_cris_publications/d1f674fa-6d25-4431-96a4-156e02e87efc","is_oa":false,"landing_page_url":"https://research.wu.ac.at/de/publications/d1f674fa-6d25-4431-96a4-156e02e87efc","pdf_url":null,"source":{"id":"https://openalex.org/S7407055123","display_name":"WU Research","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Stefan, S, Di Ciccio, C & Mendling, J 2019, Configuring SQL-based process mining for performance and storage optimisation. in Chih-Cheng Hung and George A. Papadopoulos (ed.), Proceedings of the 34th ACM/SIGAPP Symposium on Applied Computing, SAC 2019. ACM Press, Limassol, Cyprus, pp. 94 - 97. https://doi.org/10.1145/3297280.3297532","raw_type":"info:eu-repo/semantics/conferenceObject"}],"best_oa_location":{"id":"pmh:oai:iris.uniroma1.it:11573/1361963","is_oa":true,"landing_page_url":"http://hdl.handle.net/11573/1361963","pdf_url":null,"source":{"id":"https://openalex.org/S4377196107","display_name":"IRIS Research product catalog (Sapienza University of Rome)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/conferenceObject"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1785604624","display_name":null,"funder_award_id":"861213","funder_id":"https://openalex.org/F4320323031","funder_display_name":"\u00d6sterreichische Forschungsf\u00f6rderungsgesellschaft"},{"id":"https://openalex.org/G3998201246","display_name":null,"funder_award_id":"Social","funder_id":"https://openalex.org/F4320338080","funder_display_name":"European Social Fund"}],"funders":[{"id":"https://openalex.org/F4320323031","display_name":"\u00d6sterreichische Forschungsf\u00f6rderungsgesellschaft","ror":"https://ror.org/028jc0449"},{"id":"https://openalex.org/F4320338080","display_name":"European Social Fund","ror":"https://ror.org/00k4n6c32"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W66923425","https://openalex.org/W1413304420","https://openalex.org/W1660874201","https://openalex.org/W1688777878","https://openalex.org/W2042780115","https://openalex.org/W2043193064","https://openalex.org/W2129113676","https://openalex.org/W2142079217","https://openalex.org/W2475146772","https://openalex.org/W2504573221","https://openalex.org/W2522558969","https://openalex.org/W2524370299","https://openalex.org/W2524694828","https://openalex.org/W2538601868","https://openalex.org/W2621132487","https://openalex.org/W2775561574"],"related_works":["https://openalex.org/W2808742510","https://openalex.org/W2989593792","https://openalex.org/W2970064447","https://openalex.org/W2965882148","https://openalex.org/W2803918818","https://openalex.org/W794897257","https://openalex.org/W3082470505","https://openalex.org/W2098984483","https://openalex.org/W2144946338","https://openalex.org/W2116056094"],"abstract_inverted_index":{"Process":[0],"mining":[1,21,125],"is":[2],"the":[3,9,82,105],"area":[4],"of":[5,16,29,57,84,96,104,111],"research":[6],"that":[7,99],"embraces":[8],"automated":[10],"discovery,":[11],"conformance":[12],"checking":[13],"and":[14,108],"enhancement":[15],"process":[17,20,124],"models.":[18],"Declarative":[19],"approaches":[22],"offer":[23],"capabilities":[24],"to":[25,49,76],"automatically":[26],"discover":[27],"models":[28],"flexible":[30],"processes":[31],"from":[32,39],"event":[33,44],"logs.":[34],"However,":[35],"they":[36],"often":[37],"suffer":[38],"performance":[40,63,78],"issues":[41],"with":[42,126],"real-life":[43],"logs,":[45],"especially":[46],"when":[47],"constraints":[48,86],"be":[50],"discovered":[51,85],"go":[52],"beyond":[53],"a":[54,65,102,109],"standard":[55],"repertoire":[56],"templates.":[58],"By":[59],"leveraging":[60],"relational":[61,129],"database":[62],"technology,":[64],"new":[66],"approach":[67],"based":[68],"on":[69,128],"SQL":[70,127],"querying":[71],"has":[72],"been":[73],"recently":[74],"introduced,":[75],"improve":[77],"though":[79],"still":[80],"keeping":[81],"nature":[83],"customisable.":[87],"In":[88],"this":[89],"paper,":[90],"we":[91,119],"provide":[92,120],"an":[93],"in-depth":[94],"analysis":[95],"configuration":[97,121],"parameters":[98],"allow":[100],"for":[101,115,123],"speed-up":[103],"answering":[106],"time":[107],"decrease":[110],"storage":[112],"space":[113],"needed":[114],"query":[116],"processing.":[117],"Thereupon,":[118],"recommendations":[122],"databases.":[130]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2023,"cited_by_count":1}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}