{"id":"https://openalex.org/W7155376016","doi":"https://doi.org/10.1145/3810900.3810914","title":"Partial UDF Inlining","display_name":"Partial UDF Inlining","publication_year":2026,"publication_date":"2026-04-23","ids":{"openalex":"https://openalex.org/W7155376016","doi":"https://doi.org/10.1145/3810900.3810914"},"language":"en","primary_location":{"id":"doi:10.1145/3810900.3810914","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3810900.3810914","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMOD Record","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5006653831","display_name":"Samuel Arch","orcid":"https://orcid.org/0000-0001-7282-1658"},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Samuel Arch","raw_affiliation_strings":["Carnegie Mellon University, Pittsburgh, PA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Carnegie Mellon University, Pittsburgh, PA, USA","institution_ids":["https://openalex.org/I74973139"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5134430829","display_name":"Yuchen Liu","orcid":null},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yuchen Liu","raw_affiliation_strings":["Carnegie Mellon University, Pittsburgh, PA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Carnegie Mellon University, Pittsburgh, PA, USA","institution_ids":["https://openalex.org/I74973139"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5076667915","display_name":"Todd C. Mowry","orcid":"https://orcid.org/0000-0003-4076-5684"},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Todd C. Mowry","raw_affiliation_strings":["Carnegie Mellon University, Pittsburgh, PA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Carnegie Mellon University, Pittsburgh, PA, USA","institution_ids":["https://openalex.org/I74973139"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5134364199","display_name":"Jignesh M. Pate","orcid":null},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jignesh M. Pate","raw_affiliation_strings":["Carnegie Mellon University, Pittsburgh, PA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Carnegie Mellon University, Pittsburgh, PA, USA","institution_ids":["https://openalex.org/I74973139"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049165312","display_name":"Andrew Pavlo","orcid":"https://orcid.org/0000-0001-6040-6991"},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Andrew Pavlo","raw_affiliation_strings":["Carnegie Mellon University, Pittsburgh, PA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Carnegie Mellon University, Pittsburgh, PA, USA","institution_ids":["https://openalex.org/I74973139"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.61742759,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"55","issue":"1","first_page":"74","last_page":"83"},"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.8418999910354614,"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.8418999910354614,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.0471000000834465,"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/T10126","display_name":"Logic, programming, and type systems","score":0.024900000542402267,"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/sql","display_name":"SQL","score":0.5958999991416931},{"id":"https://openalex.org/keywords/speedup","display_name":"Speedup","score":0.5159000158309937},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.3452000021934509},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.29760000109672546},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.29170000553131104},{"id":"https://openalex.org/keywords/lazy-evaluation","display_name":"Lazy evaluation","score":0.28850001096725464}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8445000052452087},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5958999991416931},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.5159000158309937},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.5127999782562256},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4975000023841858},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.35740000009536743},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.3452000021934509},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3368000090122223},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.29760000109672546},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.29170000553131104},{"id":"https://openalex.org/C128099668","wikidata":"https://www.wikidata.org/wiki/Q573952","display_name":"Lazy evaluation","level":3,"score":0.28850001096725464},{"id":"https://openalex.org/C2989134064","wikidata":"https://www.wikidata.org/wiki/Q288510","display_name":"Execution time","level":2,"score":0.2741999924182892},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.26980000734329224},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.26159998774528503},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.25119999051094055}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3810900.3810914","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3810900.3810914","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMOD Record","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W1969460277","https://openalex.org/W2007845800","https://openalex.org/W2010452422","https://openalex.org/W2049594497","https://openalex.org/W2060542629","https://openalex.org/W2076090418","https://openalex.org/W2099035968","https://openalex.org/W2127637733","https://openalex.org/W2134179408","https://openalex.org/W2441695939","https://openalex.org/W2963741525","https://openalex.org/W2970388058","https://openalex.org/W3023740622","https://openalex.org/W3029703673","https://openalex.org/W3085921543","https://openalex.org/W3164278511","https://openalex.org/W3173732543","https://openalex.org/W3205887319","https://openalex.org/W4210272490","https://openalex.org/W4246166885","https://openalex.org/W4312936523","https://openalex.org/W4313009712","https://openalex.org/W4386128201"],"related_works":[],"abstract_inverted_index":{"Although":[0,40],"user-defined":[1],"functions":[2],"(UDFs)":[3],"are":[4],"a":[5,22,93,100,138],"popular":[6],"way":[7],"to":[8,61,68,95],"augment":[9],"SQL's":[10],"declarative":[11],"approach":[12,66],"with":[13,36],"procedural":[14],"code,":[15],"the":[16,56,70,80,103],"mismatch":[17],"between":[18],"programming":[19],"paradigms":[20],"creates":[21],"fundamental":[23],"optimization":[24],"challenge.":[25],"UDF":[26,31,58,91,101,119],"inlining":[27,41,55,125],"automatically":[28],"removes":[29],"all":[30],"calls":[32],"by":[33,148],"replacing":[34],"them":[35],"equivalent":[37],"SQL":[38,46,135],"subqueries.":[39],"leaves":[42],"queries":[43],"entirely":[44],"in":[45,48,106],"(resulting":[47],"large":[49],"performance":[50,122],"gains),":[51],"we":[52,89],"observe":[53],"that":[54,82,118],"entire":[57],"often":[59],"leads":[60],"suboptimal":[62],"performance.":[63],"A":[64],"better":[65],"is":[67],"analyze":[69],"UDF,":[71],"deconstruct":[72],"it":[73],"into":[74],"smaller":[75],"pieces,":[76],"and":[77,109,132,147],"inline":[78],"only":[79],"pieces":[81,98],"help":[83],"query":[84,112],"optimization.":[85],"To":[86],"achieve":[87],"this,":[88],"propose":[90],"outlining,":[92],"technique":[94],"intentionally":[96],"hide":[97],"of":[99,140],"from":[102],"optimizer,":[104],"resulting":[105],"simpler":[107],"UDFs":[108],"significantly":[110],"faster":[111],"plans.":[113],"Our":[114],"implementation":[115],"(PRISM)":[116],"demonstrates":[117],"outlining":[120],"improves":[121],"over":[123],"conventional":[124],"(on":[126],"average":[127],"1.29\u00d7":[128],"speedup":[129],"for":[130,134],"DuckDB":[131],"298.73\u00d7":[133],"Server)":[136],"through":[137],"combination":[139],"more":[141],"effective":[142],"unnesting,":[143],"improved":[144],"data":[145],"skipping,":[146],"avoiding":[149],"unnecessary":[150],"joins.":[151]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2026-04-24T00:00:00"}