{"id":"https://openalex.org/W2004772832","doi":"https://doi.org/10.1145/2236584.2236592","title":"GPU join processing revisited","display_name":"GPU join processing revisited","publication_year":2012,"publication_date":"2012-05-21","ids":{"openalex":"https://openalex.org/W2004772832","doi":"https://doi.org/10.1145/2236584.2236592","mag":"2004772832"},"language":"en","primary_location":{"id":"doi:10.1145/2236584.2236592","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2236584.2236592","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Eighth International Workshop on Data Management on New Hardware","raw_type":"proceedings-article"},"type":"conference-paper","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/A5058607529","display_name":"Tim Kaldewey","orcid":null},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tim Kaldewey","raw_affiliation_strings":["IBM Almaden Research, San Jose, CA","IBM Almaden Research. San Jose, CA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research, San Jose, CA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research. San Jose, CA#TAB#","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5009419818","display_name":"Guy M. Lohman","orcid":null},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Guy Lohman","raw_affiliation_strings":["IBM Almaden Research, San Jose, CA","IBM Almaden Research. San Jose, CA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research, San Jose, CA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research. San Jose, CA#TAB#","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5068740327","display_name":"Rene Mueller","orcid":"https://orcid.org/0000-0001-6084-9944"},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rene Mueller","raw_affiliation_strings":["IBM Almaden Research, San Jose, CA","IBM Almaden Research. San Jose, CA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research, San Jose, CA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research. San Jose, CA#TAB#","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5072488588","display_name":"Peter Benjamin Volk","orcid":null},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"Technische Universit\u00e4t Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Peter Volk","raw_affiliation_strings":["Technische Universit\u00e4t Dresden","[Technische Universitat, Dresden]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t Dresden","institution_ids":["https://openalex.org/I78650965"]},{"raw_affiliation_string":"[Technische Universitat, Dresden]","institution_ids":["https://openalex.org/I78650965"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":161,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"55","last_page":"62"},"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.9994999766349792,"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.9994999766349792,"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.9984999895095825,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9984999895095825,"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.8771823048591614},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.6911668181419373},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.6499189138412476},{"id":"https://openalex.org/keywords/graphics","display_name":"Graphics","score":0.4808026850223541},{"id":"https://openalex.org/keywords/general-purpose-computing-on-graphics-processing-units","display_name":"General-purpose computing on graphics processing units","score":0.44044622778892517},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.42133766412734985},{"id":"https://openalex.org/keywords/central-processing-unit","display_name":"Central processing unit","score":0.41740041971206665},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.27620750665664673},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.15572622418403625}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8771823048591614},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.6911668181419373},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.6499189138412476},{"id":"https://openalex.org/C21442007","wikidata":"https://www.wikidata.org/wiki/Q1027879","display_name":"Graphics","level":2,"score":0.4808026850223541},{"id":"https://openalex.org/C50630238","wikidata":"https://www.wikidata.org/wiki/Q971505","display_name":"General-purpose computing on graphics processing units","level":3,"score":0.44044622778892517},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.42133766412734985},{"id":"https://openalex.org/C49154492","wikidata":"https://www.wikidata.org/wiki/Q5300","display_name":"Central processing unit","level":2,"score":0.41740041971206665},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.27620750665664673},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.15572622418403625}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/2236584.2236592","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2236584.2236592","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Eighth International Workshop on Data Management on New Hardware","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.887.2261","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.887.2261","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.kaldewey.com/pubs/GPU_Join__DAMON12.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.899.8320","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.899.8320","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"https://www.researchgate.net/profile/Tim_Kaldewey/publication/254005676_GPU_join_processing_revisited/links/545cbb090cf2c1a63bf8ddc5.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W27773700","https://openalex.org/W1529535786","https://openalex.org/W1570477871","https://openalex.org/W1577974847","https://openalex.org/W2016939324","https://openalex.org/W2050277572","https://openalex.org/W2068418796","https://openalex.org/W2097880677","https://openalex.org/W2101691077","https://openalex.org/W2122048769","https://openalex.org/W2125529470","https://openalex.org/W2155651153","https://openalex.org/W2249637006"],"related_works":["https://openalex.org/W2088925915","https://openalex.org/W2382891957","https://openalex.org/W2393491644","https://openalex.org/W2067184662","https://openalex.org/W3047837489","https://openalex.org/W641925902","https://openalex.org/W2149904643","https://openalex.org/W2061938028","https://openalex.org/W1972148443","https://openalex.org/W3015575992"],"abstract_inverted_index":{"Until":[0],"recently,":[1],"the":[2,15,20,76,118,122,127,130,133,144,152,169,182],"use":[3],"of":[4,17,61,100,104,161,165,171,184],"graphics":[5,21],"processing":[6,11],"units":[7],"(GPUs)":[8],"for":[9,148],"query":[10,48],"was":[12,46],"limited":[13],"by":[14],"amount":[16],"memory":[18,37,70,81,138],"on":[19,151],"card,":[22],"a":[23,68],"few":[24],"gigabytes":[25],"at":[26,117,139],"best.":[27],"Moreover,":[28],"input":[29,134],"tables":[30,135],"had":[31,50],"to":[32,35,51,55,78,112,143],"be":[33,41,52],"copied":[34,53],"GPU":[36,77,131],"before":[38],"they":[39],"could":[40],"processed,":[42],"and":[43,64,86,109,179,189],"after":[44],"computation":[45],"completed,":[47],"results":[49,147,167],"back":[54],"CPU":[56,80,137],"memory.":[57],"The":[58],"newest":[59],"generation":[60],"Nvidia":[62],"GPUs":[63],"development":[65],"tools":[66],"introduces":[67],"common":[69],"address":[71],"space,":[72],"which":[73],"now":[74],"allows":[75],"access":[79],"directly,":[82],"lifting":[83],"size":[84],"limitations":[85],"obviating":[87],"data":[88],"copy":[89],"operations.":[90],"We":[91],"confirm":[92],"that":[93],"this":[94,154],"new":[95],"technology":[96],"can":[97],"sustain":[98],"98%":[99],"its":[101],"nominal":[102],"rate":[103],"6.3":[105],"GB/sec":[106],"in":[107,176],"practice,":[108],"exploit":[110],"it":[111],"process":[113],"database":[114],"hash":[115],"joins":[116,150],"same":[119],"rate,":[120],"i.e.,":[121],"join":[123,186],"is":[124],"processed":[125],"\"on":[126],"fly\"":[128],"as":[129],"reads":[132],"from":[136],"PCI-E":[140],"speeds.":[141],"Compared":[142],"fastest":[145],"published":[146],"in-memory":[149],"CPU,":[153],"represents":[155],"more":[156],"than":[157],"half":[158],"an":[159],"order":[160],"magnitude":[162],"speed-up.":[163],"All":[164],"our":[166],"include":[168],"cost":[170],"result":[172],"materialization":[173],"(often":[174],"omitted":[175],"earlier":[177],"work),":[178],"we":[180],"investigate":[181],"implications":[183],"changing":[185],"predicate":[187],"selectivity":[188],"table":[190],"size.":[191]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":9},{"year":2024,"cited_by_count":8},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":11},{"year":2021,"cited_by_count":8},{"year":2020,"cited_by_count":12},{"year":2019,"cited_by_count":9},{"year":2018,"cited_by_count":14},{"year":2017,"cited_by_count":15},{"year":2016,"cited_by_count":14},{"year":2015,"cited_by_count":17},{"year":2014,"cited_by_count":19},{"year":2013,"cited_by_count":19},{"year":2012,"cited_by_count":2}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}