{"id":"https://openalex.org/W4411486133","doi":"https://doi.org/10.1145/3695053.3731005","title":"UPP: Universal Predicate Pushdown to Smart Storage","display_name":"UPP: Universal Predicate Pushdown to Smart Storage","publication_year":2025,"publication_date":"2025-06-20","ids":{"openalex":"https://openalex.org/W4411486133","doi":"https://doi.org/10.1145/3695053.3731005"},"language":"en","primary_location":{"id":"doi:10.1145/3695053.3731005","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3695053.3731005","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3695053.3731005","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 52nd Annual International Symposium on Computer Architecture","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3695053.3731005","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5012141172","display_name":"Ipoom Jeong","orcid":"https://orcid.org/0000-0001-7513-2858"},"institutions":[{"id":"https://openalex.org/I193775966","display_name":"Yonsei University","ror":"https://ror.org/01wjejq96","country_code":"KR","type":"education","lineage":["https://openalex.org/I193775966"]}],"countries":["KR"],"is_corresponding":true,"raw_author_name":"Ipoom Jeong","raw_affiliation_strings":["Yonsei University, Seoul, Republic of Korea"],"affiliations":[{"raw_affiliation_string":"Yonsei University, Seoul, Republic of Korea","institution_ids":["https://openalex.org/I193775966"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5033906953","display_name":"Jinghan Huang","orcid":"https://orcid.org/0009-0009-2314-2734"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jinghan Huang","raw_affiliation_strings":["University of Illinois Urbana-Champaign, Urbana, USA"],"affiliations":[{"raw_affiliation_string":"University of Illinois Urbana-Champaign, Urbana, USA","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5060192796","display_name":"Chuxuan Hu","orcid":"https://orcid.org/0009-0001-3746-2722"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Chuxuan Hu","raw_affiliation_strings":["University of Illinois Urbana-Champaign, Urbana, USA"],"affiliations":[{"raw_affiliation_string":"University of Illinois Urbana-Champaign, Urbana, USA","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055149546","display_name":"Dohyun Park","orcid":"https://orcid.org/0009-0009-2010-7757"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dohyun Park","raw_affiliation_strings":["University of Illinois Urbana-Champaign, Urbana, USA"],"affiliations":[{"raw_affiliation_string":"University of Illinois Urbana-Champaign, Urbana, USA","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110230358","display_name":"Jaeyoung Kang","orcid":null},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jaeyoung Kang","raw_affiliation_strings":["University of Illinois Urbana-Champaign, Urbana, USA"],"affiliations":[{"raw_affiliation_string":"University of Illinois Urbana-Champaign, Urbana, USA","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037648751","display_name":"Nam Sung Kim","orcid":"https://orcid.org/0000-0002-0442-5634"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Nam Sung Kim","raw_affiliation_strings":["University of Illinois Urbana-Champaign, Urbana, USA"],"affiliations":[{"raw_affiliation_string":"University of Illinois Urbana-Champaign, Urbana, USA","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5023168280","display_name":"Yongjoo Park","orcid":"https://orcid.org/0000-0003-3786-6214"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yongjoo Park","raw_affiliation_strings":["University of Illinois Urbana-Champaign, Urbana, USA"],"affiliations":[{"raw_affiliation_string":"University of Illinois Urbana-Champaign, Urbana, USA","institution_ids":["https://openalex.org/I157725225"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5012141172"],"corresponding_institution_ids":["https://openalex.org/I193775966"],"apc_list":null,"apc_paid":null,"fwci":5.6644,"has_fulltext":true,"cited_by_count":4,"citation_normalized_percentile":{"value":0.95922977,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"419","last_page":"433"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998000264167786,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998000264167786,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9987000226974487,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9983000159263611,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6757169365882874},{"id":"https://openalex.org/keywords/predicate","display_name":"Predicate (mathematical logic)","score":0.5526964664459229},{"id":"https://openalex.org/keywords/embedded-pushdown-automaton","display_name":"Embedded pushdown automaton","score":0.426751047372818},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3836701810359955},{"id":"https://openalex.org/keywords/context-free-grammar","display_name":"Context-free grammar","score":0.08726271986961365},{"id":"https://openalex.org/keywords/parsing","display_name":"Parsing","score":0.05657559633255005}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6757169365882874},{"id":"https://openalex.org/C140146324","wikidata":"https://www.wikidata.org/wiki/Q1144319","display_name":"Predicate (mathematical logic)","level":2,"score":0.5526964664459229},{"id":"https://openalex.org/C27034413","wikidata":"https://www.wikidata.org/wiki/Q5370010","display_name":"Embedded pushdown automaton","level":5,"score":0.426751047372818},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3836701810359955},{"id":"https://openalex.org/C97212296","wikidata":"https://www.wikidata.org/wiki/Q338047","display_name":"Context-free grammar","level":3,"score":0.08726271986961365},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.05657559633255005},{"id":"https://openalex.org/C134083981","wikidata":"https://www.wikidata.org/wiki/Q1754022","display_name":"Tree-adjoining grammar","level":4,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3695053.3731005","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3695053.3731005","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3695053.3731005","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 52nd Annual International Symposium on Computer Architecture","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3695053.3731005","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3695053.3731005","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3695053.3731005","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 52nd Annual International Symposium on Computer Architecture","raw_type":"proceedings-article"},"sustainable_development_goals":[{"score":0.7900000214576721,"id":"https://metadata.un.org/sdg/7","display_name":"Affordable and clean energy"}],"awards":[{"id":"https://openalex.org/G1452086972","display_name":null,"funder_award_id":"JUMP 2.0","funder_id":"https://openalex.org/F4320306087","funder_display_name":"Semiconductor Research Corporation"},{"id":"https://openalex.org/G2268491825","display_name":"CREST Center for Forest Ecosystems Assessment (CFEA)","funder_award_id":"0420541","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G3034753964","display_name":null,"funder_award_id":"grant","funder_id":"https://openalex.org/F4320320671","funder_display_name":"National Research Foundation"},{"id":"https://openalex.org/G342704958","display_name":null,"funder_award_id":"funded","funder_id":"https://openalex.org/F4320322120","funder_display_name":"National Research Foundation of Korea"},{"id":"https://openalex.org/G3436121829","display_name":null,"funder_award_id":"RS-2024-00405857","funder_id":"https://openalex.org/F4320322120","funder_display_name":"National Research Foundation of Korea"},{"id":"https://openalex.org/G3496473163","display_name":null,"funder_award_id":"2312561","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G6072120315","display_name":null,"funder_award_id":"funded","funder_id":"https://openalex.org/F4320335489","funder_display_name":"Institute for Information and Communications Technology Promotion"},{"id":"https://openalex.org/G7298062262","display_name":null,"funder_award_id":"RS-2024-00456287","funder_id":"https://openalex.org/F4320328359","funder_display_name":"Ministry of Science and ICT, South Korea"},{"id":"https://openalex.org/G7828307931","display_name":"US-UK Workshop: Cognitive Robots and Control","funder_award_id":"0456287","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G848032724","display_name":null,"funder_award_id":"Science","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8794816260","display_name":null,"funder_award_id":"PRISM","funder_id":"https://openalex.org/F4320306087","funder_display_name":"Semiconductor Research Corporation"},{"id":"https://openalex.org/G992484961","display_name":null,"funder_award_id":"Korea","funder_id":"https://openalex.org/F4320321681","funder_display_name":"Ministry of Trade, Industry and Energy"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320306087","display_name":"Semiconductor Research Corporation","ror":"https://ror.org/047z4n946"},{"id":"https://openalex.org/F4320320671","display_name":"National Research Foundation","ror":"https://ror.org/05s0g1g46"},{"id":"https://openalex.org/F4320321314","display_name":"Yonsei University","ror":"https://ror.org/01wjejq96"},{"id":"https://openalex.org/F4320321681","display_name":"Ministry of Trade, Industry and Energy","ror":"https://ror.org/008nkqk13"},{"id":"https://openalex.org/F4320322120","display_name":"National Research Foundation of Korea","ror":"https://ror.org/013aysd81"},{"id":"https://openalex.org/F4320328359","display_name":"Ministry of Science and ICT, South Korea","ror":"https://ror.org/01wpjm123"},{"id":"https://openalex.org/F4320332180","display_name":"Defense Advanced Research Projects Agency","ror":"https://ror.org/02caytj08"},{"id":"https://openalex.org/F4320335489","display_name":"Institute for Information and Communications Technology Promotion","ror":"https://ror.org/01g0hqq23"},{"id":"https://openalex.org/F4320337531","display_name":"Defense Sciences Office, DARPA","ror":"https://ror.org/0447fe631"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4411486133.pdf","grobid_xml":"https://content.openalex.org/works/W4411486133.grobid-xml"},"referenced_works_count":51,"referenced_works":["https://openalex.org/W1659263304","https://openalex.org/W1791587242","https://openalex.org/W1965869859","https://openalex.org/W1986470696","https://openalex.org/W2004376136","https://openalex.org/W2017513064","https://openalex.org/W2020515441","https://openalex.org/W2050277572","https://openalex.org/W2051793914","https://openalex.org/W2055774867","https://openalex.org/W2056871913","https://openalex.org/W2098730617","https://openalex.org/W2112828875","https://openalex.org/W2114640218","https://openalex.org/W2123686039","https://openalex.org/W2131595909","https://openalex.org/W2143125604","https://openalex.org/W2153329411","https://openalex.org/W2163422235","https://openalex.org/W2286264920","https://openalex.org/W2342922783","https://openalex.org/W2421547754","https://openalex.org/W2430301697","https://openalex.org/W2436120840","https://openalex.org/W2512638702","https://openalex.org/W2517657787","https://openalex.org/W2542459869","https://openalex.org/W2547860654","https://openalex.org/W2621340029","https://openalex.org/W2734941459","https://openalex.org/W2766040387","https://openalex.org/W2795530455","https://openalex.org/W2949762319","https://openalex.org/W2950590973","https://openalex.org/W3030235304","https://openalex.org/W3043776758","https://openalex.org/W3099436583","https://openalex.org/W3100965700","https://openalex.org/W3133100623","https://openalex.org/W3167346145","https://openalex.org/W3198682658","https://openalex.org/W4210675237","https://openalex.org/W4237212714","https://openalex.org/W4283326127","https://openalex.org/W4288062521","https://openalex.org/W4291713239","https://openalex.org/W4294904080","https://openalex.org/W4366660876","https://openalex.org/W4381329140","https://openalex.org/W4381329318","https://openalex.org/W4394998510"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2244615887","https://openalex.org/W2354484042","https://openalex.org/W1991406344","https://openalex.org/W392685101","https://openalex.org/W4389895524","https://openalex.org/W2390279801","https://openalex.org/W70405621"],"abstract_inverted_index":{"In":[0],"large-scale":[1],"analytics,":[2],"in-storage":[3],"processing":[4],"(ISP)":[5],"can":[6,124],"significantly":[7],"boost":[8],"query":[9,45,213],"performance":[10,214],"by":[11,188,215],"letting":[12],"ISP":[13,48,116],"engines":[14],"(e.g.,":[15,70,86],"FPGAs)":[16],"preselect":[17],"only":[18,32,62],"the":[19,28,110],"relevant":[20],"data":[21,33,91,219],"before":[22],"sending":[23],"them":[24],"to":[25,82,104,177],"databases.This":[26],"reduces":[27],"amount":[29],"of":[30,56,66,136,143,180],"not":[31],"transfer":[34],"between":[35],"storage":[36],"and":[37,168],"host,":[38],"but":[39],"also":[40],"database":[41],"computation,":[42],"facilitating":[43],"faster":[44],"processing.However,":[46],"existing":[47,102],"solutions":[49],"cannot":[50],"effectively":[51],"support":[52,63],"a":[53,114,133,152,174,178,199],"wide":[54],"range":[55],"modern":[57,77,126],"analytical":[58,127],"queries":[59,107],"because":[60],"they":[61],"simple":[64],"combinations":[65],"frequently":[67],"used":[68],"operators":[69],"=,":[71],"<),":[72],"particularly":[73],"on":[74,206],"fixed-length":[75],"columns.As":[76],"databases":[78],"allow":[79],"filter":[80,147],"predicates":[81],"include":[83],"numerous":[84],"operators/functions":[85],"dateadd)":[87],"compatible":[88],"with":[89,198],"diverse":[90],"formats":[92],"(and":[93],"their":[94],"complex":[95],"combinations),":[96],"it":[97],"becomes":[98],"more":[99],"challenging":[100],"for":[101,132,145,160],"approaches":[103],"accelerate":[105,125],"such":[106],"efficiently.To":[108],"address":[109],"limitations,":[111],"we":[112,149],"propose":[113],"new":[115],"approach,":[117],"called":[118],"Universal":[119],"Predicate":[120],"Pushdown":[121],"(UPP),":[122],"that":[123,141],"databases,":[128],"leveraging":[129,193],"hardware/software":[130],"co-design":[131],"high":[134],"level":[135],"flexibility.Our":[137],"core":[138],"insight":[139],"is":[140],"instead":[142],"programming":[144],"individual":[146],"operators/functions,":[148],"should":[150],"devise":[151],"compact":[153],"instruction":[154],"set":[155,179],"architecture":[156],"(ISA)":[157],"tailored":[158],"explicitly":[159],"predicate":[161],"pushdown.The":[162],"software":[163],"(i.e.,":[164],"database)":[165],"layer":[166],"recognizes":[167],"compiles":[169],"various":[170],"general":[171],"filters":[172],"(called":[173],"universal":[175],"predicate)":[176],"UPP-compliant":[181],"instructions,":[182],"which":[183],"are":[184],"then":[185],"processed":[186],"efficiently":[187],"FPGA":[189],"using":[190],"bitwise":[191],"comparisons,":[192],"lightweight":[194],"metadata.In":[195],"our":[196],"experiments":[197],"100":[200],"GB":[201],"TPC-H":[202],"dataset,":[203],"UPP":[204],"running":[205],"SmartSSD":[207],"could":[208],"speed":[209],"up":[210],"Spark's":[211],"end-to-end":[212],"1.2-7.9without":[216],"changing":[217],"input":[218],"formats.":[220]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}