{"id":"https://openalex.org/W2050277572","doi":"https://doi.org/10.1145/1376616.1376670","title":"Relational joins on graphics processors","display_name":"Relational joins on graphics processors","publication_year":2008,"publication_date":"2008-06-09","ids":{"openalex":"https://openalex.org/W2050277572","doi":"https://doi.org/10.1145/1376616.1376670","mag":"2050277572"},"language":"en","primary_location":{"id":"doi:10.1145/1376616.1376670","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1376616.1376670","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2008 ACM SIGMOD international conference on Management of 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/A5039946576","display_name":"Bingsheng He","orcid":"https://orcid.org/0000-0001-8618-4581"},"institutions":[{"id":"https://openalex.org/I200769079","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597","country_code":"HK","type":"education","lineage":["https://openalex.org/I200769079"]}],"countries":["HK"],"is_corresponding":true,"raw_author_name":"Bingsheng He","raw_affiliation_strings":["Hong Kong Univ. of Science and Technology, Hong Kong, China","Hong Kong Univ. of Science and Technology (Hong Kong, China)"],"affiliations":[{"raw_affiliation_string":"Hong Kong Univ. of Science and Technology, Hong Kong, China","institution_ids":["https://openalex.org/I200769079"]},{"raw_affiliation_string":"Hong Kong Univ. of Science and Technology (Hong Kong, China)","institution_ids":["https://openalex.org/I200769079"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5031932067","display_name":"Ke Yang","orcid":"https://orcid.org/0000-0002-6441-2309"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ke Yang","raw_affiliation_strings":["Zhejiang University, China, China","[Zhejiang University China, China]"],"affiliations":[{"raw_affiliation_string":"Zhejiang University, China, China","institution_ids":["https://openalex.org/I76130692"]},{"raw_affiliation_string":"[Zhejiang University China, China]","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022399844","display_name":"Rui Fang","orcid":"https://orcid.org/0000-0001-6075-9201"},"institutions":[{"id":"https://openalex.org/I139787848","display_name":"Capital University","ror":"https://ror.org/00jy9e726","country_code":"US","type":"education","lineage":["https://openalex.org/I139787848"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rui Fang","raw_affiliation_strings":["Highbridge Capital Management LLC, USA, USA"],"affiliations":[{"raw_affiliation_string":"Highbridge Capital Management LLC, USA, USA","institution_ids":["https://openalex.org/I139787848"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103114808","display_name":"Mian Lu","orcid":"https://orcid.org/0009-0002-4853-8881"},"institutions":[{"id":"https://openalex.org/I200769079","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597","country_code":"HK","type":"education","lineage":["https://openalex.org/I200769079"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Mian Lu","raw_affiliation_strings":["Hong Kong Univ. of Science and Technology, Hong Kong, China","Hong Kong Univ. of Science and Technology (Hong Kong, China)"],"affiliations":[{"raw_affiliation_string":"Hong Kong Univ. of Science and Technology, Hong Kong, China","institution_ids":["https://openalex.org/I200769079"]},{"raw_affiliation_string":"Hong Kong Univ. of Science and Technology (Hong Kong, China)","institution_ids":["https://openalex.org/I200769079"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049041008","display_name":"Naga K. Govindaraju","orcid":null},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]},{"id":"https://openalex.org/I58610484","display_name":"Seattle University","ror":"https://ror.org/02jqc0m91","country_code":"US","type":"education","lineage":["https://openalex.org/I58610484"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Naga Govindaraju","raw_affiliation_strings":["Microsoft Corporation, USA, Seattle, USA","Microsoft Corporation, USA, Seattle, USA#TAB#"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, USA, Seattle, USA","institution_ids":["https://openalex.org/I1290206253","https://openalex.org/I58610484"]},{"raw_affiliation_string":"Microsoft Corporation, USA, Seattle, USA#TAB#","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034823616","display_name":"Qiong Luo","orcid":"https://orcid.org/0000-0002-2861-9492"},"institutions":[{"id":"https://openalex.org/I200769079","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597","country_code":"HK","type":"education","lineage":["https://openalex.org/I200769079"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Qiong Luo","raw_affiliation_strings":["Hong Kong Univ. of Science and Technology, Hong Kong, China","Hong Kong Univ. of Science and Technology (Hong Kong, China)"],"affiliations":[{"raw_affiliation_string":"Hong Kong Univ. of Science and Technology, Hong Kong, China","institution_ids":["https://openalex.org/I200769079"]},{"raw_affiliation_string":"Hong Kong Univ. of Science and Technology (Hong Kong, China)","institution_ids":["https://openalex.org/I200769079"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5066694652","display_name":"Pedro V. Sander","orcid":"https://orcid.org/0000-0002-0435-9833"},"institutions":[{"id":"https://openalex.org/I200769079","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597","country_code":"HK","type":"education","lineage":["https://openalex.org/I200769079"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Pedro Sander","raw_affiliation_strings":["Hong Kong Univ. of Science and Technology, Hong Kong, China","Hong Kong Univ. of Science and Technology (Hong Kong, China)"],"affiliations":[{"raw_affiliation_string":"Hong Kong Univ. of Science and Technology, Hong Kong, China","institution_ids":["https://openalex.org/I200769079"]},{"raw_affiliation_string":"Hong Kong Univ. of Science and Technology (Hong Kong, China)","institution_ids":["https://openalex.org/I200769079"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5039946576"],"corresponding_institution_ids":["https://openalex.org/I200769079"],"apc_list":null,"apc_paid":null,"fwci":25.8252,"has_fulltext":false,"cited_by_count":351,"citation_normalized_percentile":{"value":0.99791477,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":98,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"511","last_page":"524"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9988999962806702,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9988999962806702,"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/T10742","display_name":"Peer-to-Peer Network Technologies","score":0.9987000226974487,"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.9976000189781189,"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.8989392518997192},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.7638567686080933},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.6375556588172913},{"id":"https://openalex.org/keywords/nested-loop-join","display_name":"Nested loop join","score":0.5057311058044434},{"id":"https://openalex.org/keywords/graphics","display_name":"Graphics","score":0.500560998916626},{"id":"https://openalex.org/keywords/memory-bandwidth","display_name":"Memory bandwidth","score":0.45319047570228577},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.4413858950138092},{"id":"https://openalex.org/keywords/cuda","display_name":"CUDA","score":0.4210802912712097},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.1492181420326233},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.14588025212287903}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8989392518997192},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.7638567686080933},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.6375556588172913},{"id":"https://openalex.org/C1306188","wikidata":"https://www.wikidata.org/wiki/Q4060687","display_name":"Nested loop join","level":2,"score":0.5057311058044434},{"id":"https://openalex.org/C21442007","wikidata":"https://www.wikidata.org/wiki/Q1027879","display_name":"Graphics","level":2,"score":0.500560998916626},{"id":"https://openalex.org/C188045654","wikidata":"https://www.wikidata.org/wiki/Q17148339","display_name":"Memory bandwidth","level":2,"score":0.45319047570228577},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.4413858950138092},{"id":"https://openalex.org/C2778119891","wikidata":"https://www.wikidata.org/wiki/Q477690","display_name":"CUDA","level":2,"score":0.4210802912712097},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.1492181420326233},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.14588025212287903}],"mesh":[],"locations_count":6,"locations":[{"id":"doi:10.1145/1376616.1376670","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1376616.1376670","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2008 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:repository.hkust.edu.hk:1783.1-3279","is_oa":false,"landing_page_url":"http://repository.hkust.edu.hk/ir/Record/1783.1-3279","pdf_url":null,"source":{"id":"https://openalex.org/S4306401796","display_name":"Rare & Special e-Zone (The Hong Kong University of Science and Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I200769079","host_organization_name":"Hong Kong University of Science and Technology","host_organization_lineage":["https://openalex.org/I200769079"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":null,"raw_type":"Conference paper"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.129.8159","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.129.8159","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cse.ust.hk/catalac/papers/gpujoin_tr.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.144.9600","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.144.9600","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cse.ust.hk/catalac/papers/gpujoin_sigmod08.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.525.1580","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.525.1580","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.dsi.unive.it/~calpar/AA07-08/gpujoin_tr.pdf","raw_type":"text"},{"id":"pmh:oai:repository.ust.hk:1783.1-3279","is_oa":false,"landing_page_url":"http://www.scopus.com/record/display.url?eid=2-s2.0-54749089017&origin=inward","pdf_url":null,"source":{"id":"https://openalex.org/S4306401796","display_name":"Rare & Special e-Zone (The Hong Kong University of Science and Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I200769079","host_organization_name":"Hong Kong University of Science and Technology","host_organization_lineage":["https://openalex.org/I200769079"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Conference paper"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320323537","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":47,"referenced_works":["https://openalex.org/W50914958","https://openalex.org/W103315254","https://openalex.org/W1492783156","https://openalex.org/W1494822125","https://openalex.org/W1570320352","https://openalex.org/W1570477871","https://openalex.org/W1595783387","https://openalex.org/W1645807896","https://openalex.org/W1965387308","https://openalex.org/W1997020216","https://openalex.org/W1999478123","https://openalex.org/W2009036829","https://openalex.org/W2015823077","https://openalex.org/W2032309817","https://openalex.org/W2052050139","https://openalex.org/W2054468361","https://openalex.org/W2056014488","https://openalex.org/W2078528123","https://openalex.org/W2079450792","https://openalex.org/W2082701182","https://openalex.org/W2096668111","https://openalex.org/W2108157916","https://openalex.org/W2114640218","https://openalex.org/W2119547137","https://openalex.org/W2122817518","https://openalex.org/W2127091535","https://openalex.org/W2127766448","https://openalex.org/W2137077706","https://openalex.org/W2138512691","https://openalex.org/W2140453381","https://openalex.org/W2141389982","https://openalex.org/W2142820603","https://openalex.org/W2150054597","https://openalex.org/W2163229756","https://openalex.org/W2946046356","https://openalex.org/W3004540582","https://openalex.org/W3138367763","https://openalex.org/W3145128584","https://openalex.org/W4238594802","https://openalex.org/W4240697374","https://openalex.org/W4241513866","https://openalex.org/W4285719527","https://openalex.org/W6604179887","https://openalex.org/W6635487903","https://openalex.org/W6654450483","https://openalex.org/W6664581313","https://openalex.org/W6678107477"],"related_works":["https://openalex.org/W4385270656","https://openalex.org/W4380591969","https://openalex.org/W2148838171","https://openalex.org/W2069307110","https://openalex.org/W2947004196","https://openalex.org/W1984017666","https://openalex.org/W2572223517","https://openalex.org/W4226441432","https://openalex.org/W3214526314","https://openalex.org/W2102023823"],"abstract_inverted_index":{"We":[0,100],"present":[1],"a":[2,34,48,106,126],"novel":[3],"design":[4,47],"and":[5,33,56,58,69,88,92,113],"implementation":[6],"of":[7,42,50,85,129],"relational":[8],"join":[9,120],"algorithms":[10,73,104,121],"for":[11,24,37],"new-generation":[12],"graphics":[13],"processing":[14],"units":[15],"(GPUs).":[16],"The":[17],"most":[18],"recent":[19],"GPU":[20,112],"features":[21],"include":[22],"support":[23],"writing":[25],"to":[26,62,95,124],"random":[27],"memory":[28,83,93,98],"locations,":[29],"efficient":[30],"inter-processor":[31],"communication,":[32],"programming":[35],"model":[36],"general-purpose":[38],"computing.":[39],"Taking":[40],"advantage":[41],"these":[43,60],"new":[44],"features,":[45],"we":[46],"set":[49],"data-parallel":[51],"primitives":[52,61],"such":[53],"as":[54,78,80],"split":[55],"sort,":[57],"use":[59,89],"implement":[63],"indexed":[64],"or":[65],"non-indexed":[66],"nested-loop,":[67],"sort-merge":[68],"hash":[70],"joins.":[71],"Our":[72,118],"utilize":[74],"the":[75,81,86],"high":[76,82],"parallelism":[77],"well":[79],"bandwidth":[84],"GPU,":[87],"parallel":[90],"computation":[91],"optimizations":[94],"effectively":[96],"reduce":[97],"stalls.":[99],"have":[101],"implemented":[102],"our":[103],"on":[105],"PC":[107],"with":[108],"an":[109,114],"NVIDIA":[110],"G80":[111],"Intel":[115],"quad-core":[116],"CPU.":[117],"GPU-based":[119],"are":[122],"able":[123],"achieve":[125],"performance":[127],"improvement":[128],"2-7X":[130],"over":[131],"their":[132],"optimized":[133],"CPU-based":[134],"counterparts.":[135]},"counts_by_year":[{"year":2025,"cited_by_count":10},{"year":2024,"cited_by_count":11},{"year":2023,"cited_by_count":6},{"year":2022,"cited_by_count":12},{"year":2021,"cited_by_count":13},{"year":2020,"cited_by_count":10},{"year":2019,"cited_by_count":13},{"year":2018,"cited_by_count":22},{"year":2017,"cited_by_count":27},{"year":2016,"cited_by_count":31},{"year":2015,"cited_by_count":25},{"year":2014,"cited_by_count":36},{"year":2013,"cited_by_count":37},{"year":2012,"cited_by_count":28}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}