{"id":"https://openalex.org/W4360831827","doi":"https://doi.org/10.1109/hpca56546.2023.10070958","title":"VAQUERO: A Scratchpad-based Vector Accelerator for Query Processing","display_name":"VAQUERO: A Scratchpad-based Vector Accelerator for Query Processing","publication_year":2023,"publication_date":"2023-02-01","ids":{"openalex":"https://openalex.org/W4360831827","doi":"https://doi.org/10.1109/hpca56546.2023.10070958"},"language":"en","primary_location":{"id":"doi:10.1109/hpca56546.2023.10070958","is_oa":false,"landing_page_url":"http://dx.doi.org/10.1109/hpca56546.2023.10070958","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 IEEE International Symposium on High-Performance Computer Architecture (HPCA)","raw_type":"proceedings-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/A5012920678","display_name":"Juli\u00e1n Pav\u00f3n","orcid":"https://orcid.org/0000-0002-8291-509X"},"institutions":[{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]},{"id":"https://openalex.org/I2799803557","display_name":"Barcelona Supercomputing Center","ror":"https://ror.org/05sd8tv96","country_code":"ES","type":"facility","lineage":["https://openalex.org/I2799803557","https://openalex.org/I9617848"]}],"countries":["ES"],"is_corresponding":true,"raw_author_name":"Juli\u00e1n Pav\u00f3n","raw_affiliation_strings":["Barcelona Supercomputing Center,Barcelona,Spain","Barcelona Supercomputing Center, Barcelona, Spain"],"affiliations":[{"raw_affiliation_string":"Barcelona Supercomputing Center,Barcelona,Spain","institution_ids":["https://openalex.org/I9617848","https://openalex.org/I2799803557"]},{"raw_affiliation_string":"Barcelona Supercomputing Center, Barcelona, Spain","institution_ids":["https://openalex.org/I9617848","https://openalex.org/I2799803557"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102799920","display_name":"Ivan Vargas Valdivieso","orcid":"https://orcid.org/0000-0002-5092-3829"},"institutions":[{"id":"https://openalex.org/I2799803557","display_name":"Barcelona Supercomputing Center","ror":"https://ror.org/05sd8tv96","country_code":"ES","type":"facility","lineage":["https://openalex.org/I2799803557","https://openalex.org/I9617848"]},{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Ivan Vargas Valdivieso","raw_affiliation_strings":["Barcelona Supercomputing Center,Barcelona,Spain","Barcelona Supercomputing Center, Barcelona, Spain"],"affiliations":[{"raw_affiliation_string":"Barcelona Supercomputing Center,Barcelona,Spain","institution_ids":["https://openalex.org/I9617848","https://openalex.org/I2799803557"]},{"raw_affiliation_string":"Barcelona Supercomputing Center, Barcelona, Spain","institution_ids":["https://openalex.org/I9617848","https://openalex.org/I2799803557"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5090878527","display_name":"Joan Marimon","orcid":"https://orcid.org/0000-0002-0607-5615"},"institutions":[{"id":"https://openalex.org/I2799803557","display_name":"Barcelona Supercomputing Center","ror":"https://ror.org/05sd8tv96","country_code":"ES","type":"facility","lineage":["https://openalex.org/I2799803557","https://openalex.org/I9617848"]},{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Joan Marimon","raw_affiliation_strings":["Barcelona Supercomputing Center,Barcelona,Spain","Barcelona Supercomputing Center, Barcelona, Spain"],"affiliations":[{"raw_affiliation_string":"Barcelona Supercomputing Center,Barcelona,Spain","institution_ids":["https://openalex.org/I9617848","https://openalex.org/I2799803557"]},{"raw_affiliation_string":"Barcelona Supercomputing Center, Barcelona, Spain","institution_ids":["https://openalex.org/I9617848","https://openalex.org/I2799803557"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088522684","display_name":"Roger Figueras","orcid":"https://orcid.org/0000-0003-2407-1228"},"institutions":[{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]},{"id":"https://openalex.org/I2799803557","display_name":"Barcelona Supercomputing Center","ror":"https://ror.org/05sd8tv96","country_code":"ES","type":"facility","lineage":["https://openalex.org/I2799803557","https://openalex.org/I9617848"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Roger Figueras","raw_affiliation_strings":["Barcelona Supercomputing Center,Barcelona,Spain","Barcelona Supercomputing Center, Barcelona, Spain"],"affiliations":[{"raw_affiliation_string":"Barcelona Supercomputing Center,Barcelona,Spain","institution_ids":["https://openalex.org/I9617848","https://openalex.org/I2799803557"]},{"raw_affiliation_string":"Barcelona Supercomputing Center, Barcelona, Spain","institution_ids":["https://openalex.org/I9617848","https://openalex.org/I2799803557"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5028715959","display_name":"Francesc Moll","orcid":"https://orcid.org/0000-0002-1290-3253"},"institutions":[{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Francesc Moll","raw_affiliation_strings":["Universitat Politècnica de Catalunya,Barcelona,Spain"],"affiliations":[{"raw_affiliation_string":"Universitat Politècnica de Catalunya,Barcelona,Spain","institution_ids":["https://openalex.org/I9617848"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075162875","display_name":"Osman \u00dcnsal","orcid":"https://orcid.org/0000-0002-0544-9697"},"institutions":[{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]},{"id":"https://openalex.org/I2799803557","display_name":"Barcelona Supercomputing Center","ror":"https://ror.org/05sd8tv96","country_code":"ES","type":"facility","lineage":["https://openalex.org/I2799803557","https://openalex.org/I9617848"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Osman Unsal","raw_affiliation_strings":["Barcelona Supercomputing Center,Barcelona,Spain","Barcelona Supercomputing Center, Barcelona, Spain"],"affiliations":[{"raw_affiliation_string":"Barcelona Supercomputing Center,Barcelona,Spain","institution_ids":["https://openalex.org/I9617848","https://openalex.org/I2799803557"]},{"raw_affiliation_string":"Barcelona Supercomputing Center, Barcelona, Spain","institution_ids":["https://openalex.org/I9617848","https://openalex.org/I2799803557"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5020844763","display_name":"Mateo Valero","orcid":"https://orcid.org/0000-0003-2917-2482"},"institutions":[{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]},{"id":"https://openalex.org/I2799803557","display_name":"Barcelona Supercomputing Center","ror":"https://ror.org/05sd8tv96","country_code":"ES","type":"facility","lineage":["https://openalex.org/I2799803557","https://openalex.org/I9617848"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Mateo Valero","raw_affiliation_strings":["Barcelona Supercomputing Center,Barcelona,Spain","Barcelona Supercomputing Center, Barcelona, Spain"],"affiliations":[{"raw_affiliation_string":"Barcelona Supercomputing Center,Barcelona,Spain","institution_ids":["https://openalex.org/I9617848","https://openalex.org/I2799803557"]},{"raw_affiliation_string":"Barcelona Supercomputing Center, Barcelona, Spain","institution_ids":["https://openalex.org/I9617848","https://openalex.org/I2799803557"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5084390427","display_name":"Adri\u00e1n Cristal","orcid":"https://orcid.org/0000-0003-1277-9296"},"institutions":[{"id":"https://openalex.org/I2799803557","display_name":"Barcelona Supercomputing Center","ror":"https://ror.org/05sd8tv96","country_code":"ES","type":"facility","lineage":["https://openalex.org/I2799803557","https://openalex.org/I9617848"]},{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Adrian Cristal","raw_affiliation_strings":["Barcelona Supercomputing Center,Barcelona,Spain","Barcelona Supercomputing Center, Barcelona, Spain"],"affiliations":[{"raw_affiliation_string":"Barcelona Supercomputing Center,Barcelona,Spain","institution_ids":["https://openalex.org/I9617848","https://openalex.org/I2799803557"]},{"raw_affiliation_string":"Barcelona Supercomputing Center, Barcelona, Spain","institution_ids":["https://openalex.org/I9617848","https://openalex.org/I2799803557"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":8,"corresponding_author_ids":["https://openalex.org/A5012920678"],"corresponding_institution_ids":["https://openalex.org/I2799803557","https://openalex.org/I9617848"],"apc_list":null,"apc_paid":null,"fwci":0.9178,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.7714841,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"13","issue":null,"first_page":"1289","last_page":"1302"},"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.9994000196456909,"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.9994000196456909,"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9991999864578247,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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.9986000061035156,"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.8596310615539551},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6303105354309082},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.5494550466537476},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.5197020173072815},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.42882847785949707},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.20319890975952148}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8596310615539551},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6303105354309082},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.5494550466537476},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.5197020173072815},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.42882847785949707},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.20319890975952148}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/hpca56546.2023.10070958","is_oa":false,"landing_page_url":"http://dx.doi.org/10.1109/hpca56546.2023.10070958","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 IEEE International Symposium on High-Performance Computer Architecture (HPCA)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.6200000047683716}],"awards":[],"funders":[{"id":"https://openalex.org/F4320323868","display_name":"Barcelona Supercomputing Center","ror":"https://ror.org/05sd8tv96"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":45,"referenced_works":["https://openalex.org/W1604972505","https://openalex.org/W1701312224","https://openalex.org/W1967601791","https://openalex.org/W1993795298","https://openalex.org/W1995302096","https://openalex.org/W2022643129","https://openalex.org/W2029866183","https://openalex.org/W2031029774","https://openalex.org/W2086977914","https://openalex.org/W2114965603","https://openalex.org/W2124257970","https://openalex.org/W2130283598","https://openalex.org/W2147657366","https://openalex.org/W2227629474","https://openalex.org/W2286264920","https://openalex.org/W2321294477","https://openalex.org/W2396727930","https://openalex.org/W2401640580","https://openalex.org/W2613207303","https://openalex.org/W2613514830","https://openalex.org/W2724920573","https://openalex.org/W2846921863","https://openalex.org/W2899485899","https://openalex.org/W2950461515","https://openalex.org/W2984774785","https://openalex.org/W3013717674","https://openalex.org/W3033004298","https://openalex.org/W3042235401","https://openalex.org/W3093626305","https://openalex.org/W3099436583","https://openalex.org/W3130339525","https://openalex.org/W3157142721","https://openalex.org/W3158454049","https://openalex.org/W3158543914","https://openalex.org/W3166039404","https://openalex.org/W4226264732","https://openalex.org/W4243240312","https://openalex.org/W4244568827","https://openalex.org/W4244855685","https://openalex.org/W6639328637","https://openalex.org/W6669644914","https://openalex.org/W6713059071","https://openalex.org/W6776092565","https://openalex.org/W6779824479","https://openalex.org/W6811503504"],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W2088925915","https://openalex.org/W2382891957","https://openalex.org/W2393491644","https://openalex.org/W2067184662","https://openalex.org/W3047837489","https://openalex.org/W2622139626","https://openalex.org/W2133660117","https://openalex.org/W2104496206","https://openalex.org/W3013303285"],"abstract_inverted_index":{"Database":[0],"Management":[1],"Systems":[2],"(DBMS)":[3],"have":[4,23,48],"be-come":[5],"an":[6,252],"essential":[7],"tool":[8],"for":[9,69,79,197],"industry":[10],"and":[11,13,86,130,167,200,222,232,265,269,275],"research":[12],"are":[14,94],"often":[15],"a":[16,117,183,245],"significant":[17,95],"component":[18],"of":[19,33,41,57,76,112,179,209],"data":[20,84],"centers.":[21],"There":[22],"been":[24,50,171],"many":[25],"efforts":[26],"to":[27,52,97,137,155,193],"accelerate":[28,138,194],"DBMS":[29,58,80,102,159,175,195],"application":[30],"performance.":[31],"One":[32],"the":[34,39,54,74,98,110,147,152,207,219,229,239,278],"most":[35],"explored":[36],"techniques":[37],"is":[38,191],"use":[40,156,162],"vector":[42,46,77],"processing.":[43],"Unfortunately,":[44],"conventional":[45],"architectures":[47,78],"not":[49],"able":[51],"exploit":[53],"full":[55],"potential":[56],"acceleration.In":[59],"this":[60,188,203],"paper,":[61,204],"we":[62,205],"present":[63],"VAQUERO,":[64],"our":[65],"Scratchpad-based":[66],"Vector":[67],"Accelerator":[68],"QUEry":[70],"pROcessing.":[71],"VAQUERO":[72,115,136,157,169,190,210,227,243,261],"improves":[73],"efficiency":[75,208],"operations":[81],"such":[82],"as":[83],"aggregation":[85],"hash":[87],"joins":[88],"featuring":[89],"lookup":[90],"tables.":[91],"Lookup":[92],"tables":[93],"contributors":[96],"performance":[99],"bottlenecks":[100],"in":[101,109],"processing":[103,273],"suffering":[104],"from":[105,277],"insufficient":[106],"ISA":[107],"support":[108],"form":[111],"scatter-gather":[113],"instructions.":[114],"introduces":[116],"novel":[118],"Advanced":[119],"Scratchpad":[120],"Memory":[121],"specifically":[122],"designed":[123,172],"with":[124,141,158,251],"two":[125,212],"mapping":[126],"modes":[127,134],"\u2014":[128],"direct-":[129],"associative-mode.":[131],"These":[132],"map-ping":[133],"enable":[135],"real-world":[139],"databases":[140],"workload":[142],"sizes":[143],"that":[144,161,260],"significantly":[145,262],"exceed":[146],"scratchpad":[148],"memory":[149],"capacity.":[150],"Additionally,":[151],"associative-mode":[153],"allows":[154],"operators":[160,196,274],"hashed":[163],"keys,":[164],"e.g.":[165],"hash-join":[166],"hash-aggregate.":[168],"has":[170],"considering":[173],"general":[174],"algorithm":[176],"requirements":[177],"instead":[178],"being":[180],"based":[181],"on":[182],"particular":[184],"database":[185],"organization.":[186],"For":[187],"reason,":[189],"capable":[192],"both":[198],"row-":[199],"column-oriented":[201],"databases.In":[202],"evaluate":[206],"using":[211],"highly":[213],"optimized":[214],"popular":[215],"open-source":[216],"DBMS,":[217],"namely":[218],"row-based":[220],"PostgreSQL":[221,264],"column-based":[223],"MonetDB.":[224],"We":[225],"imple-mented":[226],"at":[228,238],"RTL":[230],"level":[231],"prototype":[233],"it,":[234],"by":[235,267],"performing":[236],"Place&Route,":[237],"7nm":[240],"technology":[241],"node.":[242],"incurs":[244],"modest":[246],"0.15%":[247],"area":[248],"overhead":[249],"compared":[250],"Intel":[253],"Ice":[254],"Lake":[255],"processor.":[256],"Our":[257],"evaluation":[258],"shows":[259],"outperforms":[263],"MonetDB":[266],"2.09\u00d7":[268],"3.32\u00d7":[270],"respectively,":[271],"when":[272],"queries":[276],"TPC-H":[279],"benchmark.":[280]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1}],"updated_date":"2025-12-24T23:09:58.560324","created_date":"2025-10-10T00:00:00"}