{"id":"https://openalex.org/W4319870583","doi":"https://doi.org/10.1145/3543622.3573194","title":"A Study of Early Aggregation in Database Query Processing on FPGAs","display_name":"A Study of Early Aggregation in Database Query Processing on FPGAs","publication_year":2023,"publication_date":"2023-02-10","ids":{"openalex":"https://openalex.org/W4319870583","doi":"https://doi.org/10.1145/3543622.3573194"},"language":"en","primary_location":{"id":"doi:10.1145/3543622.3573194","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3543622.3573194","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2023 ACM/SIGDA International Symposium on Field Programmable Gate Arrays","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/A5080413745","display_name":"Mehdi Moghaddamfar","orcid":"https://orcid.org/0000-0002-6617-6944"},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"TU Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Mehdi Moghaddamfar","raw_affiliation_strings":["SAP SE & Technische Universit\u00e4t Dresden, Walldorf & Dresden, Germany"],"affiliations":[{"raw_affiliation_string":"SAP SE & Technische Universit\u00e4t Dresden, Walldorf & Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5040281275","display_name":"Norman May","orcid":"https://orcid.org/0000-0001-9671-0856"},"institutions":[{"id":"https://openalex.org/I4210132444","display_name":"Systems, Applications & Products in Data Processing (Germany)","ror":"https://ror.org/03dsc8d33","country_code":"DE","type":"company","lineage":["https://openalex.org/I4210132444"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Norman May","raw_affiliation_strings":["SAP SE, Walldorf, Germany"],"affiliations":[{"raw_affiliation_string":"SAP SE, Walldorf, Germany","institution_ids":["https://openalex.org/I4210132444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112247015","display_name":"Christian F\u00e4rber","orcid":null},"institutions":[{"id":"https://openalex.org/I4210094487","display_name":"Intel (Germany)","ror":"https://ror.org/00m2x0g47","country_code":"DE","type":"company","lineage":["https://openalex.org/I1343180700","https://openalex.org/I4210094487"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Christian F\u00e4rber","raw_affiliation_strings":["Intel Corporation, Munich, Germany"],"affiliations":[{"raw_affiliation_string":"Intel Corporation, Munich, Germany","institution_ids":["https://openalex.org/I4210094487"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063512642","display_name":"Wolfgang Lehner","orcid":"https://orcid.org/0000-0001-8107-2775"},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"TU Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Wolfgang Lehner","raw_affiliation_strings":["Technische Universit\u00e4t Dresden, Dresden, Germany"],"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t Dresden, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100755285","display_name":"Akash Kumar","orcid":"https://orcid.org/0000-0001-7125-1737"},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"TU Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Akash Kumar","raw_affiliation_strings":["Technische Universit\u00e4t Dresden, Dresden, Germany"],"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t Dresden, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5080413745"],"corresponding_institution_ids":["https://openalex.org/I78650965"],"apc_list":null,"apc_paid":null,"fwci":1.0046,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.75548843,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"55","last_page":"65"},"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.996999979019165,"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.996999979019165,"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.9954000115394592,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9944999814033508,"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/computer-science","display_name":"Computer science","score":0.8510979413986206},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.6205225586891174},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.5681731700897217},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5648452043533325},{"id":"https://openalex.org/keywords/associative-property","display_name":"Associative property","score":0.5473943948745728},{"id":"https://openalex.org/keywords/field-programmable-gate-array","display_name":"Field-programmable gate array","score":0.5311597585678101},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5067062973976135},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.49803781509399414},{"id":"https://openalex.org/keywords/property","display_name":"Property (philosophy)","score":0.488706111907959},{"id":"https://openalex.org/keywords/operator","display_name":"Operator (biology)","score":0.447416216135025},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.44096314907073975},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3094686269760132},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.2757197320461273},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.23756259679794312},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.20187914371490479},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.12388497591018677},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.09114980697631836}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8510979413986206},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.6205225586891174},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.5681731700897217},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5648452043533325},{"id":"https://openalex.org/C159423971","wikidata":"https://www.wikidata.org/wiki/Q177251","display_name":"Associative property","level":2,"score":0.5473943948745728},{"id":"https://openalex.org/C42935608","wikidata":"https://www.wikidata.org/wiki/Q190411","display_name":"Field-programmable gate array","level":2,"score":0.5311597585678101},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5067062973976135},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.49803781509399414},{"id":"https://openalex.org/C189950617","wikidata":"https://www.wikidata.org/wiki/Q937228","display_name":"Property (philosophy)","level":2,"score":0.488706111907959},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.447416216135025},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.44096314907073975},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3094686269760132},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.2757197320461273},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.23756259679794312},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.20187914371490479},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.12388497591018677},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.09114980697631836},{"id":"https://openalex.org/C158448853","wikidata":"https://www.wikidata.org/wiki/Q425218","display_name":"Repressor","level":4,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C86339819","wikidata":"https://www.wikidata.org/wiki/Q407384","display_name":"Transcription factor","level":3,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3543622.3573194","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3543622.3573194","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2023 ACM/SIGDA International Symposium on Field Programmable Gate Arrays","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W1977858936","https://openalex.org/W1980088630","https://openalex.org/W1983394510","https://openalex.org/W1999375498","https://openalex.org/W2054308357","https://openalex.org/W2059681118","https://openalex.org/W2067089961","https://openalex.org/W2114965603","https://openalex.org/W2117987151","https://openalex.org/W2124645273","https://openalex.org/W2146238719","https://openalex.org/W2161420356","https://openalex.org/W2163772659","https://openalex.org/W2286264920","https://openalex.org/W2415861698","https://openalex.org/W2527042725","https://openalex.org/W2612080955","https://openalex.org/W2950590973","https://openalex.org/W3022398217","https://openalex.org/W3173774939","https://openalex.org/W3205990334"],"related_works":["https://openalex.org/W3125756434","https://openalex.org/W2554271401","https://openalex.org/W2912995176","https://openalex.org/W2360617161","https://openalex.org/W1971797742","https://openalex.org/W2992414350","https://openalex.org/W185198413","https://openalex.org/W2566063947","https://openalex.org/W2249768123","https://openalex.org/W4281289408"],"abstract_inverted_index":{"In":[0,37],"database":[1,53],"query":[2,49,122],"processing,":[3],"aggregation":[4,24,35,43,91,116],"is":[5,15,25],"an":[6],"operator":[7],"by":[8],"which":[9],"data":[10],"with":[11,65],"a":[12,20,26,66,96,119],"common":[13],"property":[14],"grouped":[16],"and":[17,79],"expressed":[18],"in":[19,45,52],"summary":[21],"form.":[22],"Early":[23],"popular":[27],"method":[28],"for":[29,100,114],"improving":[30],"the":[31,34,46,87],"performance":[32,78],"of":[33,48,86,105,110],"operator.":[36],"this":[38],"paper,":[39],"we":[40],"study":[41,59],"early":[42,90],"algorithms":[44],"context":[47],"processing":[50],"acceleration":[51],"systems":[54],"on":[55],"FPGAs.":[56],"The":[57],"comparative":[58],"leads":[60],"us":[61],"to":[62,84,112,118],"set-associative":[63,102],"caches":[64],"low":[67],"inter-reference":[68],"recency":[69],"set":[70],"(LIRS)":[71],"replacement":[72],"policy.":[73],"They":[74],"show":[75,108],"both":[76],"great":[77],"modest":[80],"implementation":[81,107],"complexity":[82],"compared":[83,117],"some":[85],"most":[88],"prominent":[89],"algorithms.":[92],"We":[93],"also":[94],"present":[95],"novel":[97],"application-specific":[98],"architecture":[99],"implementing":[101],"caches.":[103],"Benchmarks":[104],"our":[106],"speedups":[109],"up":[111],"3x":[113],"end-to-end":[115],"state-of-the-art":[120],"FPGA-based":[121],"engine.":[123]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}