{"id":"https://openalex.org/W4411374442","doi":"https://doi.org/10.1145/3722212.3725139","title":"UDFB <scp>ench</scp> : A Tool for Benchmarking UDF Queries on SQL Engines","display_name":"UDFB <scp>ench</scp> : A Tool for Benchmarking UDF Queries on SQL Engines","publication_year":2025,"publication_date":"2025-06-17","ids":{"openalex":"https://openalex.org/W4411374442","doi":"https://doi.org/10.1145/3722212.3725139"},"language":"en","primary_location":{"id":"doi:10.1145/3722212.3725139","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3722212.3725139","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2025 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3722212.3725139","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5036614082","display_name":"Yannis Foufoulas","orcid":"https://orcid.org/0000-0002-2785-946X"},"institutions":[{"id":"https://openalex.org/I4210156054","display_name":"Athena Research and Innovation Center In Information Communication & Knowledge Technologies","ror":"https://ror.org/0576by029","country_code":"GR","type":"facility","lineage":["https://openalex.org/I4210156054"]}],"countries":["GR"],"is_corresponding":true,"raw_author_name":"Yannis Foufoulas","raw_affiliation_strings":["Athena Research Center, Athens, Greece"],"affiliations":[{"raw_affiliation_string":"Athena Research Center, Athens, Greece","institution_ids":["https://openalex.org/I4210156054"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5104987449","display_name":"Theoni Palaiologou","orcid":null},"institutions":[{"id":"https://openalex.org/I200777214","display_name":"National and Kapodistrian University of Athens","ror":"https://ror.org/04gnjpq42","country_code":"GR","type":"education","lineage":["https://openalex.org/I200777214"]},{"id":"https://openalex.org/I4210156054","display_name":"Athena Research and Innovation Center In Information Communication & Knowledge Technologies","ror":"https://ror.org/0576by029","country_code":"GR","type":"facility","lineage":["https://openalex.org/I4210156054"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Theoni Palaiologou","raw_affiliation_strings":["University of Athens, Athens, Greece and Athena R.C, Athens, Greece"],"affiliations":[{"raw_affiliation_string":"University of Athens, Athens, Greece and Athena R.C, Athens, Greece","institution_ids":["https://openalex.org/I4210156054","https://openalex.org/I200777214"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5072082268","display_name":"Alkis Simitsis","orcid":"https://orcid.org/0009-0006-6078-5323"},"institutions":[{"id":"https://openalex.org/I4210156054","display_name":"Athena Research and Innovation Center In Information Communication & Knowledge Technologies","ror":"https://ror.org/0576by029","country_code":"GR","type":"facility","lineage":["https://openalex.org/I4210156054"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Alkis Simitsis","raw_affiliation_strings":["Athena Research Center, Athens, Greece"],"affiliations":[{"raw_affiliation_string":"Athena Research Center, Athens, Greece","institution_ids":["https://openalex.org/I4210156054"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5036614082"],"corresponding_institution_ids":["https://openalex.org/I4210156054"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.14338148,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"91","last_page":"94"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9947999715805054,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T11986","display_name":"Scientific Computing and Data Management","score":0.986299991607666,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/benchmarking","display_name":"Benchmarking","score":0.7288482189178467},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6486234664916992},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5663003325462341},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5344972014427185},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.20296737551689148},{"id":"https://openalex.org/keywords/marketing","display_name":"Marketing","score":0.07106530666351318}],"concepts":[{"id":"https://openalex.org/C86251818","wikidata":"https://www.wikidata.org/wiki/Q816754","display_name":"Benchmarking","level":2,"score":0.7288482189178467},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6486234664916992},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5663003325462341},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5344972014427185},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.20296737551689148},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.07106530666351318}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3722212.3725139","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3722212.3725139","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2025 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3722212.3725139","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3722212.3725139","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2025 International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G7427235454","display_name":null,"funder_award_id":"GA.101188416, GA.101092749, GA.101147319","funder_id":"https://openalex.org/F4320323817","funder_display_name":"Universitas Brawijaya"}],"funders":[{"id":"https://openalex.org/F4320323817","display_name":"Universitas Brawijaya","ror":"https://ror.org/01wk3d929"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W1578512165","https://openalex.org/W2396309311","https://openalex.org/W2475801470","https://openalex.org/W3164278511","https://openalex.org/W3175890395","https://openalex.org/W4255327858","https://openalex.org/W4385270707","https://openalex.org/W4386768666","https://openalex.org/W4400910514"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W4238897586","https://openalex.org/W435179959","https://openalex.org/W2619091065","https://openalex.org/W2059640416","https://openalex.org/W1490753184","https://openalex.org/W2284465472","https://openalex.org/W4320802139"],"abstract_inverted_index":{"User-defined":[0],"functions":[1],"(UDFs)":[2],"extend":[3],"SQL":[4,29,96],"with":[5,39,90,106,145],"functional":[6],"capabilities.":[7],"However,":[8],"integrating":[9],"UDFs":[10,123],"efficiently":[11],"into":[12],"a":[13,17,43,81,93,118,129],"data":[14],"engine":[15],"is":[16],"challenge,":[18],"mainly":[19],"due":[20],"to":[21,37,58,100,154],"the":[22,25,59,67,72,101,109,113],"mismatch":[23],"of":[24,45,71,95,108,120,124],"UDF":[26,87],"execution":[27,103],"and":[28,47,50,69,98,122,132,157],"processing":[30],"environments.":[31],"Several":[32],"techniques":[33],"have":[34],"been":[35,138],"proposed":[36],"deal":[38],"this":[40,76],"challenge":[41],"spanning":[42],"variety":[44,94],"logical":[46],"physical":[48],"optimizations,":[49],"architecture":[51],"designs.":[52],"These":[53],"however":[54],"are":[55],"not":[56],"evident":[57],"casual":[60],"user,":[61],"who":[62],"would":[63],"benefit":[64],"from":[65],"knowing":[66],"pros":[68],"cons":[70],"available":[73],"solutions.":[74],"Towards":[75],"direction,":[77],"we":[78],"present":[79],"UDFBench,":[80],"benchmarking":[82],"toolkit":[83],"for":[84],"running":[85],"seamlessly":[86],"queries":[88,121],"(queries":[89],"UDFs)":[91],"on":[92,128,140],"engines":[97,144],"presenting":[99],"user":[102],"results":[104],"accompanied":[105],"highlights":[107],"main":[110],"reasons":[111],"driving":[112],"query":[114],"performance.":[115],"UDFBench":[116,153],"comprises":[117],"set":[119],"varying":[125],"complexity":[126],"based":[127],"real-world":[130],"application":[131],"data.":[133],"Our":[134,148],"current":[135],"implementation":[136],"has":[137],"deployed":[139],"four":[141],"popular":[142],"database":[143],"different":[146],"characteristics.":[147],"pluggable":[149],"design":[150],"enables":[151],"extending":[152],"additional":[155],"systems":[156],"workloads.":[158]},"counts_by_year":[],"updated_date":"2026-04-09T08:11:56.329763","created_date":"2025-10-10T00:00:00"}