{"id":"https://openalex.org/W2292693431","doi":"https://doi.org/10.14778/2735496.2735499","title":"Memory-efficient hash joins","display_name":"Memory-efficient hash joins","publication_year":2014,"publication_date":"2014-12-01","ids":{"openalex":"https://openalex.org/W2292693431","doi":"https://doi.org/10.14778/2735496.2735499","mag":"2292693431"},"language":"en","primary_location":{"id":"doi:10.14778/2735496.2735499","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2735496.2735499","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5007953196","display_name":"Ronald Barber","orcid":"https://orcid.org/0009-0005-2952-7564"},"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":"R. Barber","raw_affiliation_strings":["IBM Research, Almaden"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Research, Almaden","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":"G. Lohman","raw_affiliation_strings":["IBM Research, Almaden"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Research, Almaden","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064208847","display_name":"Ippokratis Pandis","orcid":"https://orcid.org/0009-0008-6491-1678"},"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":"I. Pandis","raw_affiliation_strings":["IBM Research, Almaden"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Research, Almaden","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5036513384","display_name":"Venkat Raman","orcid":"https://orcid.org/0000-0002-2750-0246"},"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":"V. Raman","raw_affiliation_strings":["IBM Research, Almaden"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Research, Almaden","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5028660385","display_name":"Richard Sidle","orcid":"https://orcid.org/0009-0001-7577-8816"},"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":"R. Sidle","raw_affiliation_strings":["IBM Research, Almaden"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Research, Almaden","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007693540","display_name":"Gopi K. Attaluri","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"G. Attaluri","raw_affiliation_strings":["IBM Software Group"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Software Group","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022021662","display_name":"Naresh Chainani","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"N. Chainani","raw_affiliation_strings":["IBM Software Group"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Software Group","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030480168","display_name":"Sam Lightstone","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"S. Lightstone","raw_affiliation_strings":["IBM Software Group"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Software Group","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5063947384","display_name":"Dave Sharpe","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"D. Sharpe","raw_affiliation_strings":["IBM Software Group"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Software Group","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":8.3581,"has_fulltext":false,"cited_by_count":84,"citation_normalized_percentile":{"value":0.97818336,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":97,"max":99},"biblio":{"volume":"8","issue":"4","first_page":"353","last_page":"364"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11478","display_name":"Caching and Content Delivery","score":0.9988999962806702,"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/T11478","display_name":"Caching and Content Delivery","score":0.9988999962806702,"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.9969000220298767,"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"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9840999841690063,"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/joins","display_name":"Joins","score":0.8553950786590576},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.7466908097267151},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7364078164100647},{"id":"https://openalex.org/keywords/hash-tree","display_name":"Hash tree","score":0.6964794993400574},{"id":"https://openalex.org/keywords/hash-table","display_name":"Hash table","score":0.6959837675094604},{"id":"https://openalex.org/keywords/double-hashing","display_name":"Double hashing","score":0.6732288002967834},{"id":"https://openalex.org/keywords/bitmap","display_name":"Bitmap","score":0.5769244432449341},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.568930447101593},{"id":"https://openalex.org/keywords/hash-chain","display_name":"Hash chain","score":0.5551886558532715},{"id":"https://openalex.org/keywords/bloom-filter","display_name":"Bloom filter","score":0.42702147364616394},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.425750732421875},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3653082847595215},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.2302730679512024},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.09135019779205322}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.8553950786590576},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.7466908097267151},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7364078164100647},{"id":"https://openalex.org/C27353603","wikidata":"https://www.wikidata.org/wiki/Q16948622","display_name":"Hash tree","level":4,"score":0.6964794993400574},{"id":"https://openalex.org/C67388219","wikidata":"https://www.wikidata.org/wiki/Q207440","display_name":"Hash table","level":3,"score":0.6959837675094604},{"id":"https://openalex.org/C138111711","wikidata":"https://www.wikidata.org/wiki/Q478351","display_name":"Double hashing","level":4,"score":0.6732288002967834},{"id":"https://openalex.org/C3115412","wikidata":"https://www.wikidata.org/wiki/Q1194708","display_name":"Bitmap","level":2,"score":0.5769244432449341},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.568930447101593},{"id":"https://openalex.org/C135783594","wikidata":"https://www.wikidata.org/wiki/Q5678864","display_name":"Hash chain","level":3,"score":0.5551886558532715},{"id":"https://openalex.org/C147224247","wikidata":"https://www.wikidata.org/wiki/Q885373","display_name":"Bloom filter","level":2,"score":0.42702147364616394},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.425750732421875},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3653082847595215},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.2302730679512024},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.09135019779205322},{"id":"https://openalex.org/C31972630","wikidata":"https://www.wikidata.org/wiki/Q844240","display_name":"Computer vision","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.14778/2735496.2735499","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2735496.2735499","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.666.9682","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.666.9682","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.vldb.org/pvldb/vol8/p353-barber.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":19,"referenced_works":["https://openalex.org/W42901544","https://openalex.org/W1602137482","https://openalex.org/W1852059679","https://openalex.org/W1967601791","https://openalex.org/W2003515726","https://openalex.org/W2007030756","https://openalex.org/W2043934800","https://openalex.org/W2046609653","https://openalex.org/W2072541977","https://openalex.org/W2097880677","https://openalex.org/W2099035968","https://openalex.org/W2099580433","https://openalex.org/W2104003087","https://openalex.org/W2125529470","https://openalex.org/W2144839430","https://openalex.org/W2157174514","https://openalex.org/W2188889839","https://openalex.org/W2406955896","https://openalex.org/W2913618476"],"related_works":["https://openalex.org/W2069568684","https://openalex.org/W2154676777","https://openalex.org/W4252190074","https://openalex.org/W2185147150","https://openalex.org/W2144564205","https://openalex.org/W4285028289","https://openalex.org/W2765699882","https://openalex.org/W4210289650","https://openalex.org/W2159756639","https://openalex.org/W2292693431"],"abstract_inverted_index":{"We":[0,91,108,195],"present":[1,161],"new":[2,49],"hash":[3,9,29,45,51,57,98,106,193,207],"tables":[4,36,135],"for":[5,86,104,132],"joins,":[6,99],"and":[7,19,64,100,186,202],"a":[8,48,54,66,83,110,162,167,197],"join":[10,30,46,189],"based":[11],"on":[12],"them,":[13],"that":[14,37,59,172,212],"consumes":[15],"far":[16],"less":[17],"memory":[18,217],"is":[20,31,47,120,125,129,180,184],"usually":[21],"faster":[22],"than":[23,136],"recently":[24],"published":[25],"in-memory":[26,206],"joins.":[27,90,107,139,208],"Our":[28,209],"not":[32],"restricted":[33],"to":[34,43,73,221],"outer":[35,134],"fit":[38],"wholly":[39],"in":[40,88,115,191,230],"memory.":[41],"Key":[42],"this":[44,128],"concise":[50,168],"table":[52,58,170],"(CHT),":[53],"linear":[55],"probing":[56],"has":[60],"100%":[61],"fill":[62],"factor,":[63],"uses":[65],"sparse":[67],"bitmap":[68,79],"with":[69],"embedded":[70],"population":[71],"counts":[72],"almost":[74],"entirely":[75],"avoid":[76],"collisions.":[77],"This":[78,140],"also":[80,141,227],"serves":[81],"as":[82,127],"Bloom":[84],"filter":[85],"use":[87],"multi-table":[89],"study":[92],"the":[93,102,118,123,146,150,177,192,216],"random":[94],"access":[95],"characteristics":[96],"of":[97,112,164,200,224],"renew":[101],"case":[103],"non-partitioned":[105],"introduce":[109],"variant":[111,163],"partitioned":[113,138],"joins":[114],"which":[116],"only":[117],"build":[119,155],"partitioned,":[121],"but":[122],"probe":[124],"not,":[126],"more":[130],"efficient":[131],"large":[133],"traditional":[137],"avoids":[142,187],"partitioning":[143],"costs":[144],"during":[145],"probe,":[147],"while":[148,226],"at":[149],"same":[151],"time":[152],"allowing":[153],"parallel":[154],"without":[156],"latching":[157],"overheads.":[158],"Additionally,":[159],"we":[160,213],"CHT,":[165],"called":[166],"array":[169],"(CAT),":[171],"can":[173,214],"be":[174],"used":[175],"when":[176],"key":[178],"domain":[179],"moderately":[181],"dense.":[182],"CAT":[183,203],"collision-free":[185],"storing":[188],"keys":[190],"table.":[194],"perform":[196],"detailed":[198],"comparison":[199],"CHT":[201],"against":[204],"leading":[205],"experiments":[210],"show":[211],"reduce":[215],"usage":[218],"by":[219],"one":[220],"three":[222],"orders":[223],"magnitude,":[225],"being":[228],"competitive":[229],"performance.":[231]},"counts_by_year":[{"year":2025,"cited_by_count":7},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":10},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":10},{"year":2020,"cited_by_count":10},{"year":2019,"cited_by_count":6},{"year":2018,"cited_by_count":7},{"year":2017,"cited_by_count":7},{"year":2016,"cited_by_count":6},{"year":2015,"cited_by_count":10}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}