{"id":"https://openalex.org/W4405304407","doi":"https://doi.org/10.1109/nas63802.2024.10781372","title":"SAQO: Empowering Computational Storage Device for Efficient SQL Query Acceleration","display_name":"SAQO: Empowering Computational Storage Device for Efficient SQL Query Acceleration","publication_year":2024,"publication_date":"2024-11-09","ids":{"openalex":"https://openalex.org/W4405304407","doi":"https://doi.org/10.1109/nas63802.2024.10781372"},"language":"en","primary_location":{"id":"doi:10.1109/nas63802.2024.10781372","is_oa":false,"landing_page_url":"https://doi.org/10.1109/nas63802.2024.10781372","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 International Conference on Networking, Architecture and Storage (NAS)","raw_type":"proceedings-article"},"type":"conference-paper","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/A5078394815","display_name":"Yao Deng","orcid":"https://orcid.org/0000-0002-0602-1457"},"institutions":[{"id":"https://openalex.org/I47720641","display_name":"Huazhong University of Science and Technology","ror":"https://ror.org/00p991c53","country_code":"CN","type":"education","lineage":["https://openalex.org/I47720641"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yao Deng","raw_affiliation_strings":["Huazhong University of Science and Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Huazhong University of Science and Technology","institution_ids":["https://openalex.org/I47720641"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069492002","display_name":"Pei Lv","orcid":"https://orcid.org/0000-0002-2654-0561"},"institutions":[{"id":"https://openalex.org/I4210095624","display_name":"Alibaba Group (United States)","ror":"https://ror.org/00rn0m335","country_code":"US","type":"company","lineage":["https://openalex.org/I4210095624","https://openalex.org/I45928872"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Pengze Lv","raw_affiliation_strings":["Alibaba Group"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Alibaba Group","institution_ids":["https://openalex.org/I4210095624"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5091753560","display_name":"Mengran Zhang","orcid":null},"institutions":[{"id":"https://openalex.org/I47720641","display_name":"Huazhong University of Science and Technology","ror":"https://ror.org/00p991c53","country_code":"CN","type":"education","lineage":["https://openalex.org/I47720641"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Mengran Zhang","raw_affiliation_strings":["Huazhong University of Science and Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Huazhong University of Science and Technology","institution_ids":["https://openalex.org/I47720641"]}]},{"author_position":"last","author":{"id":null,"display_name":"Wei Tong","orcid":null},"institutions":[{"id":"https://openalex.org/I47720641","display_name":"Huazhong University of Science and Technology","ror":"https://ror.org/00p991c53","country_code":"CN","type":"education","lineage":["https://openalex.org/I47720641"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Wei Tong","raw_affiliation_strings":["Huazhong University of Science and Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Huazhong University of Science and Technology","institution_ids":["https://openalex.org/I47720641"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"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.31975267,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"4"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9969000220298767,"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"}},"topics":[{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9969000220298767,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9955000281333923,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9865999817848206,"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.807404637336731},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7180554866790771},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.6844422221183777},{"id":"https://openalex.org/keywords/acceleration","display_name":"Acceleration","score":0.5945981740951538},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5843473672866821},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5023050308227539},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.4743815064430237},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.4672303795814514},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.4307063817977905},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.324786901473999},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.25155773758888245},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.21791264414787292},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.12992945313453674},{"id":"https://openalex.org/keywords/physics","display_name":"Physics","score":0.08960822224617004}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.807404637336731},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7180554866790771},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6844422221183777},{"id":"https://openalex.org/C117896860","wikidata":"https://www.wikidata.org/wiki/Q11376","display_name":"Acceleration","level":2,"score":0.5945981740951538},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5843473672866821},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5023050308227539},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4743815064430237},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.4672303795814514},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4307063817977905},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.324786901473999},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.25155773758888245},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.21791264414787292},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.12992945313453674},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.08960822224617004},{"id":"https://openalex.org/C74650414","wikidata":"https://www.wikidata.org/wiki/Q11397","display_name":"Classical mechanics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/nas63802.2024.10781372","is_oa":false,"landing_page_url":"https://doi.org/10.1109/nas63802.2024.10781372","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 International Conference on Networking, Architecture and Storage (NAS)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/7","score":0.6299999952316284,"display_name":"Affordable and clean energy"}],"awards":[{"id":"https://openalex.org/G119041766","display_name":null,"funder_award_id":"62172178","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G923017793","display_name":null,"funder_award_id":"2023YFB4502100","funder_id":"https://openalex.org/F4320335777","funder_display_name":"National Key Research and Development Program of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320335777","display_name":"National Key Research and Development Program of China","ror":null}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W2004376136","https://openalex.org/W2036895660","https://openalex.org/W2038412523","https://openalex.org/W2517657787","https://openalex.org/W2547860654","https://openalex.org/W2766040387","https://openalex.org/W3022915021","https://openalex.org/W3165439173","https://openalex.org/W4205764711","https://openalex.org/W6773730542"],"related_works":["https://openalex.org/W2955368753","https://openalex.org/W2391725132","https://openalex.org/W2384284661","https://openalex.org/W319014924","https://openalex.org/W2588167896","https://openalex.org/W1987288934","https://openalex.org/W2389888740","https://openalex.org/W2362460270","https://openalex.org/W2188347403","https://openalex.org/W2550810496"],"abstract_inverted_index":{"It":[0],"is":[1],"efficient":[2],"to":[3,32,37,50,57,123,142,150],"accelerate":[4,22],"SQL":[5,24,48,118],"queries":[6,49],"by":[7,88,139],"utilizing":[8],"Computational":[9],"Storage":[10],"Device":[11],"(CSD).":[12],"Since":[13],"current":[14],"CSDs":[15],"have":[16],"limited":[17],"processing":[18],"capacity":[19],"and":[20,100,119,147],"cannot":[21],"all":[23,44],"queries,":[25],"existing":[26],"schemes":[27],"typically":[28],"offload":[29],"filter":[30,45],"operators":[31,46,87],"significantly":[33],"reduce":[34],"data":[35,111,136],"movement":[36],"the":[38,51,66,81,90,93,95,101,107,125,132,143,151],"computational":[39,52,96],"storage":[40,53,97],"device.":[41],"However,":[42],"leaving":[43],"in":[47],"device":[54],"directly":[55],"leads":[56],"poor":[58],"performance.":[59],"To":[60],"address":[61],"these":[62],"problems,":[63],"we":[64],"propose":[65],"Self-Adaptive":[67],"Query":[68],"Offloading":[69],"(SAQO)":[70],"strategy":[71,78,130,146],"for":[72,85],"offloading":[73,153],"filtering":[74,86],"operators.":[75],"The":[76,114,128],"SAQO":[77,126,129],"dynamically":[79],"chooses":[80],"best":[82],"execution":[83,133,145],"location":[84],"considering":[89],"selectivity":[91],"of":[92,109,135],"operator,":[94],"device's":[98],"load,":[99],"task":[102],"characteristics,":[103],"which":[104],"ultimately":[105],"accelerates":[106],"speed":[108],"executing":[110],"query":[112,137],"tasks.":[113],"real-world":[115],"applications":[116],"Spark":[117],"TPC-H":[120],"are":[121],"used":[122],"evaluate":[124],"strategy.":[127,154],"reduces":[131],"time":[134],"tasks":[138],"58.7%":[140],"compared":[141,149],"host":[144],"9.4%":[148],"state-of-the-art":[152]},"counts_by_year":[],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}