{"id":"https://openalex.org/W4281732221","doi":"https://doi.org/10.1145/3470496.3527435","title":"Accelerating database analytic query workloads using an associative processor","display_name":"Accelerating database analytic query workloads using an associative processor","publication_year":2022,"publication_date":"2022-05-31","ids":{"openalex":"https://openalex.org/W4281732221","doi":"https://doi.org/10.1145/3470496.3527435"},"language":"en","primary_location":{"id":"doi:10.1145/3470496.3527435","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3470496.3527435","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 49th Annual International Symposium on Computer Architecture","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/A5010142123","display_name":"Helena Caminal","orcid":"https://orcid.org/0000-0002-2052-8107"},"institutions":[{"id":"https://openalex.org/I205783295","display_name":"Cornell University","ror":"https://ror.org/05bnh6r87","country_code":"US","type":"education","lineage":["https://openalex.org/I205783295"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Helena Caminal","raw_affiliation_strings":["Cornell University"],"affiliations":[{"raw_affiliation_string":"Cornell University","institution_ids":["https://openalex.org/I205783295"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035128721","display_name":"Yannis Chronis","orcid":null},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yannis Chronis","raw_affiliation_strings":["University of Wisconsin-Madison"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030198756","display_name":"Tianshu Wu","orcid":null},"institutions":[{"id":"https://openalex.org/I205783295","display_name":"Cornell University","ror":"https://ror.org/05bnh6r87","country_code":"US","type":"education","lineage":["https://openalex.org/I205783295"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tianshu Wu","raw_affiliation_strings":["Cornell University"],"affiliations":[{"raw_affiliation_string":"Cornell University","institution_ids":["https://openalex.org/I205783295"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069237428","display_name":"Jignesh M. Patel","orcid":"https://orcid.org/0000-0003-3653-2538"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jignesh M. Patel","raw_affiliation_strings":["University of Wisconsin-Madison"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5083127721","display_name":"Jos\u00e9 F. Mart\u00ednez","orcid":"https://orcid.org/0000-0001-5451-5681"},"institutions":[{"id":"https://openalex.org/I205783295","display_name":"Cornell University","ror":"https://ror.org/05bnh6r87","country_code":"US","type":"education","lineage":["https://openalex.org/I205783295"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jos\u00e9 F. Mart\u00ednez","raw_affiliation_strings":["Cornell University"],"affiliations":[{"raw_affiliation_string":"Cornell University","institution_ids":["https://openalex.org/I205783295"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5010142123"],"corresponding_institution_ids":["https://openalex.org/I205783295"],"apc_list":null,"apc_paid":null,"fwci":1.934,"has_fulltext":false,"cited_by_count":15,"citation_normalized_percentile":{"value":0.8620254,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"623","last_page":"637"},"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.9980999827384949,"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.9980999827384949,"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.9957000017166138,"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.9941999912261963,"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.88102126121521},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.6266010999679565},{"id":"https://openalex.org/keywords/speedup","display_name":"Speedup","score":0.5723605155944824},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4956735372543335},{"id":"https://openalex.org/keywords/suite","display_name":"Suite","score":0.4947742819786072},{"id":"https://openalex.org/keywords/simd","display_name":"SIMD","score":0.4736163318157196},{"id":"https://openalex.org/keywords/data-parallelism","display_name":"Data parallelism","score":0.454474538564682},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.4371987581253052},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.43395617604255676},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.42759090662002563},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.4148625135421753},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.41214078664779663},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.24538758397102356},{"id":"https://openalex.org/keywords/parallelism","display_name":"Parallelism (grammar)","score":0.23840627074241638},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.16695481538772583},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1294577419757843}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.88102126121521},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.6266010999679565},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.5723605155944824},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4956735372543335},{"id":"https://openalex.org/C79581498","wikidata":"https://www.wikidata.org/wiki/Q1367530","display_name":"Suite","level":2,"score":0.4947742819786072},{"id":"https://openalex.org/C150552126","wikidata":"https://www.wikidata.org/wiki/Q339387","display_name":"SIMD","level":2,"score":0.4736163318157196},{"id":"https://openalex.org/C61483411","wikidata":"https://www.wikidata.org/wiki/Q3124522","display_name":"Data parallelism","level":3,"score":0.454474538564682},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.4371987581253052},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.43395617604255676},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.42759090662002563},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.4148625135421753},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.41214078664779663},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.24538758397102356},{"id":"https://openalex.org/C2781172179","wikidata":"https://www.wikidata.org/wiki/Q853109","display_name":"Parallelism (grammar)","level":2,"score":0.23840627074241638},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.16695481538772583},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1294577419757843},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3470496.3527435","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3470496.3527435","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 49th Annual International Symposium on Computer Architecture","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":55,"referenced_works":["https://openalex.org/W1578512165","https://openalex.org/W1791587242","https://openalex.org/W1966831051","https://openalex.org/W1987565267","https://openalex.org/W1993819379","https://openalex.org/W1995302096","https://openalex.org/W2004772832","https://openalex.org/W2007069074","https://openalex.org/W2020515441","https://openalex.org/W2050277572","https://openalex.org/W2058490651","https://openalex.org/W2059226577","https://openalex.org/W2066443755","https://openalex.org/W2074084814","https://openalex.org/W2080427212","https://openalex.org/W2082371124","https://openalex.org/W2082964163","https://openalex.org/W2086977914","https://openalex.org/W2088602658","https://openalex.org/W2094332102","https://openalex.org/W2097880677","https://openalex.org/W2112547256","https://openalex.org/W2112980698","https://openalex.org/W2116784058","https://openalex.org/W2125529470","https://openalex.org/W2126479028","https://openalex.org/W2127766448","https://openalex.org/W2136268150","https://openalex.org/W2147076738","https://openalex.org/W2158237121","https://openalex.org/W2166955231","https://openalex.org/W2167911783","https://openalex.org/W2187802606","https://openalex.org/W2250636351","https://openalex.org/W2270203991","https://openalex.org/W2323528361","https://openalex.org/W2396309311","https://openalex.org/W2611786849","https://openalex.org/W2766885499","https://openalex.org/W2798629639","https://openalex.org/W3016903199","https://openalex.org/W3028661980","https://openalex.org/W3032789239","https://openalex.org/W3042803431","https://openalex.org/W3090164555","https://openalex.org/W3094660140","https://openalex.org/W3099436583","https://openalex.org/W3155004489","https://openalex.org/W3173761726","https://openalex.org/W4210401038","https://openalex.org/W4232446824","https://openalex.org/W4251828973","https://openalex.org/W4299617642","https://openalex.org/W4300869451","https://openalex.org/W6792366016"],"related_works":["https://openalex.org/W2889903446","https://openalex.org/W2150741898","https://openalex.org/W4281289408","https://openalex.org/W185198413","https://openalex.org/W3125756434","https://openalex.org/W2186703450","https://openalex.org/W1971797742","https://openalex.org/W2406556739","https://openalex.org/W2034583622","https://openalex.org/W4381740310"],"abstract_inverted_index":{"Database":[0],"analytic":[1,89,147],"query":[2,59,90,135],"workloads":[3,60],"are":[4,83],"heavy":[5],"consumers":[6],"of":[7,43,88,154,181],"data-center":[8],"cycles,":[9],"and":[10,54,66,71,129],"there":[11],"is":[12,48,106,111,141],"constant":[13],"demand":[14],"to":[15,38,84,127,133,158,160,173,185],"improve":[16,162],"their":[17],"performance.":[18,163],"Associative":[19,46],"processors":[20],"(AP)":[21],"have":[22],"re-emerged":[23],"as":[24],"an":[25,107,186],"attractive":[26],"architecture":[27],"that":[28,34,110,139],"offers":[29],"very":[30],"large":[31],"data-level":[32],"parallelism":[33],"can":[35],"be":[36],"used":[37],"implement":[39],"a":[40,142,152,167],"wide":[41],"range":[42],"general-purpose":[44],"operations.":[45,57,74],"processing":[47],"based":[49],"primarily":[50],"on":[51,170,175],"efficient":[52],"search":[53,70],"bulk":[55,72],"update":[56,73],"Analytic":[58],"benefit":[61],"from":[62],"data":[63],"parallel":[64],"execution":[65],"often":[67],"feature":[68],"both":[69],"In":[75],"this":[76,93],"paper,":[77],"we":[78,95,137],"investigate":[79],"how":[80],"amenable":[81],"APs":[82],"improving":[85],"the":[86,97,115,134,176],"performance":[87],"workloads.":[91,148],"For":[92],"study,":[94],"use":[96],"recently":[98],"proposed":[99],"Content-Addressable":[100],"Processing":[101],"Engine":[102],"(CAPE)":[103],"framework.":[104],"CAPE":[105,128,140,159,165],"AP":[108],"core":[109],"highly":[112],"programmable":[113],"via":[114],"RISC-V":[116],"ISA":[117],"with":[118,191],"standard":[119],"vector":[120],"extensions.":[121],"By":[122],"mapping":[123],"key":[124],"database":[125,146],"operators":[126],"introducing":[130],"AP-aware":[131],"changes":[132,157],"optimizer,":[136],"show":[138],"good":[143],"match":[144],"for":[145],"We":[149],"also":[150],"propose":[151],"set":[153],"database-aware":[155],"microarchitectural":[156],"further":[161],"Overall,":[164],"achieves":[166],"10.8\u00d7":[168],"speedup":[169],"average":[171],"(up":[172],"61.1\u00d7)":[174],"SSB":[177],"benchmark":[178],"(a":[179],"suite":[180],"13":[182],"queries)":[183],"compared":[184],"iso-area":[187],"aggressive":[188],"out-of-order":[189],"processor":[190],"AVX-512":[192],"SIMD":[193],"support.":[194]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":1}],"updated_date":"2026-03-01T08:55:55.761014","created_date":"2025-10-10T00:00:00"}