{"id":"https://openalex.org/W2203398219","doi":"https://doi.org/10.1109/bigdata.2015.7364051","title":"Join algorithms on GPUs: A revisit after seven years","display_name":"Join algorithms on GPUs: A revisit after seven years","publication_year":2015,"publication_date":"2015-10-01","ids":{"openalex":"https://openalex.org/W2203398219","doi":"https://doi.org/10.1109/bigdata.2015.7364051","mag":"2203398219"},"language":"en","primary_location":{"id":"doi:10.1109/bigdata.2015.7364051","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata.2015.7364051","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE International Conference on Big Data (Big Data)","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/A5032729619","display_name":"Ran Rui","orcid":null},"institutions":[{"id":"https://openalex.org/I2613432","display_name":"University of South Florida","ror":"https://ror.org/032db5x82","country_code":"US","type":"education","lineage":["https://openalex.org/I2613432"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Ran Rui","raw_affiliation_strings":["Department of Computer Science and Engineering, University of South Florida, Florida, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, University of South Florida, Florida, USA","institution_ids":["https://openalex.org/I2613432"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113713546","display_name":"Hao Li","orcid":"https://orcid.org/0000-0002-0558-6245"},"institutions":[{"id":"https://openalex.org/I2613432","display_name":"University of South Florida","ror":"https://ror.org/032db5x82","country_code":"US","type":"education","lineage":["https://openalex.org/I2613432"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hao Li","raw_affiliation_strings":["Department of Computer Science and Engineering, University of South Florida, Florida, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, University of South Florida, Florida, USA","institution_ids":["https://openalex.org/I2613432"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5032673243","display_name":"Yi-Cheng Tu","orcid":"https://orcid.org/0000-0002-4062-2694"},"institutions":[{"id":"https://openalex.org/I2613432","display_name":"University of South Florida","ror":"https://ror.org/032db5x82","country_code":"US","type":"education","lineage":["https://openalex.org/I2613432"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yi-Cheng Tu","raw_affiliation_strings":["Department of Computer Science and Engineering, University of South Florida, Florida, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, University of South Florida, Florida, USA","institution_ids":["https://openalex.org/I2613432"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5032729619"],"corresponding_institution_ids":["https://openalex.org/I2613432"],"apc_list":null,"apc_paid":null,"fwci":3.2881,"has_fulltext":false,"cited_by_count":25,"citation_normalized_percentile":{"value":0.93247604,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"2541","last_page":"2550"},"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.9984999895095825,"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.9984999895095825,"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/T11106","display_name":"Data Management and Algorithms","score":0.9976999759674072,"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9969000220298767,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8830161094665527},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.7134774327278137},{"id":"https://openalex.org/keywords/speedup","display_name":"Speedup","score":0.6667769551277161},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.6338552236557007},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.5476682186126709},{"id":"https://openalex.org/keywords/multi-core-processor","display_name":"Multi-core processor","score":0.4198625683784485},{"id":"https://openalex.org/keywords/pace","display_name":"Pace","score":0.4192041754722595}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8830161094665527},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.7134774327278137},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.6667769551277161},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.6338552236557007},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.5476682186126709},{"id":"https://openalex.org/C78766204","wikidata":"https://www.wikidata.org/wiki/Q555032","display_name":"Multi-core processor","level":2,"score":0.4198625683784485},{"id":"https://openalex.org/C2777526511","wikidata":"https://www.wikidata.org/wiki/Q691543","display_name":"Pace","level":2,"score":0.4192041754722595},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","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},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","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}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/bigdata.2015.7364051","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata.2015.7364051","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE International Conference on Big Data (Big Data)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/7","display_name":"Affordable and clean energy","score":0.8999999761581421}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W1492783156","https://openalex.org/W1979107684","https://openalex.org/W2004772832","https://openalex.org/W2039767911","https://openalex.org/W2050277572","https://openalex.org/W2054468361","https://openalex.org/W2066860750","https://openalex.org/W2068418796","https://openalex.org/W2068743743","https://openalex.org/W2104003087","https://openalex.org/W2110975861","https://openalex.org/W2111643426","https://openalex.org/W2112828875","https://openalex.org/W2114640218","https://openalex.org/W2122817518","https://openalex.org/W2127766448","https://openalex.org/W2135903696","https://openalex.org/W2271272914","https://openalex.org/W3023445147","https://openalex.org/W4206627351","https://openalex.org/W4229957504","https://openalex.org/W6693947434"],"related_works":["https://openalex.org/W2058965144","https://openalex.org/W2164382479","https://openalex.org/W2146343568","https://openalex.org/W98480971","https://openalex.org/W2150291671","https://openalex.org/W2013643406","https://openalex.org/W2027972911","https://openalex.org/W2157978810","https://openalex.org/W2597809628","https://openalex.org/W3012895752"],"abstract_inverted_index":{"Implementing":[0],"database":[1,30,224],"operations":[2,97],"on":[3,46,65,109],"parallel":[4],"platforms":[5],"has":[6],"gain":[7],"a":[8,40,60,77,88,132,200],"lot":[9],"of":[10,18,24,39,62,72,82,91,104,159,182,189,220],"momentum":[11],"in":[12,44,127,146,186,236],"the":[13,22,69,83,118,141,147,190,196,216],"past":[14],"decade.":[15],"A":[16],"number":[17,61],"studies":[19],"have":[20,74],"shown":[21],"potential":[23],"using":[25,221],"GPUs":[26,73,222,232],"to":[27,93,124,213],"speed":[28],"up":[29,123],"operations.":[31,225],"In":[32,50,226],"this":[33,52],"paper,":[34],"we":[35,194,228],"present":[36,152],"empirical":[37],"evaluations":[38],"state-of-the-art":[41],"work":[42,53],"published":[43],"SIGMOD'08":[45],"GPU-based":[47],"join":[48,57,96,120],"processing.":[49],"particular,":[51],"presents":[54],"four":[55],"major":[56],"algorithms":[58],"and":[59,113,172,209,218,245],"join-related":[63],"primitives":[64],"GPUs.":[66],"Since":[67],"2008,":[68],"compute":[70],"capabilities":[71],"increased":[75],"following":[76],"pace":[78],"faster":[79,235],"than":[80,140,250],"that":[81,117,156,230],"multi-core":[84],"CPUs.":[85,252],"We":[86,150],"run":[87],"comprehensive":[89],"set":[90],"experiments":[92,108],"study":[94],"how":[95],"can":[98,240],"benefit":[99],"from":[100,199],"such":[101,164,177],"rapid":[102],"expansion":[103],"GPU":[105,112,119,154,161,191],"capabilities.":[106],"Our":[107],"today's":[110,231],"mainstream":[111],"CPU":[114,134],"hardware":[115],"show":[116],"program":[121,198,210],"achieves":[122],"20X":[125],"speedup":[126],"end-to-end":[128],"running":[129],"time":[130],"over":[131],"highly-optimized":[133],"version.":[135],"This":[136],"is":[137,184],"significantly":[138,234],"better":[139],"7X":[142],"performance":[143,180],"gap":[144],"reported":[145],"original":[148],"paper.":[149],"also":[151],"improved":[153],"programs":[155],"take":[157],"advantage":[158],"new":[160],"hardware/software":[162],"features":[163],"as":[165],"read-only":[166],"data":[167],"cache,":[168,171],"large":[169],"L2":[170],"shuffle":[173],"instructions.":[174],"By":[175],"applying":[176],"optimizations,":[178],"extra":[179],"improvement":[181],"30-52%":[183],"observed":[185],"various":[187],"components":[188],"program.":[192],"Finally,":[193],"evaluate":[195],"same":[197],"few":[201],"other":[202],"perspectives":[203],"including":[204],"energy":[205,248],"efficiency,":[206],"floatingpoint":[207],"performance,":[208],"development":[211],"considerations":[212],"further":[214],"reveal":[215],"advantages":[217],"limitations":[219],"for":[223],"summary,":[227],"find":[229],"are":[233],"floating":[237],"point":[238],"operations,":[239],"process":[241],"more":[242],"on-board":[243],"data,":[244],"achieve":[246],"higher":[247],"efficiency":[249],"modern":[251]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":4},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":7},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":3}],"updated_date":"2026-04-02T13:48:15.688549","created_date":"2025-10-10T00:00:00"}
