{"id":"https://openalex.org/W2125529470","doi":"https://doi.org/10.14778/1687553.1687564","title":"Sort vs. Hash revisited","display_name":"Sort vs. Hash revisited","publication_year":2009,"publication_date":"2009-08-01","ids":{"openalex":"https://openalex.org/W2125529470","doi":"https://doi.org/10.14778/1687553.1687564","mag":"2125529470"},"language":"en","primary_location":{"id":"doi:10.14778/1687553.1687564","is_oa":false,"landing_page_url":"https://doi.org/10.14778/1687553.1687564","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/A5101667271","display_name":"Changkyu Kim","orcid":"https://orcid.org/0000-0002-0283-8371"},"institutions":[{"id":"https://openalex.org/I4210158342","display_name":"Intel (United Kingdom)","ror":"https://ror.org/058cxws58","country_code":"GB","type":"company","lineage":["https://openalex.org/I1343180700","https://openalex.org/I4210158342"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Changkyu Kim","raw_affiliation_strings":["Intel Corporation"],"affiliations":[{"raw_affiliation_string":"Intel Corporation","institution_ids":["https://openalex.org/I4210158342"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5058607529","display_name":"Tim Kaldewey","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tim Kaldewey","raw_affiliation_strings":["Oracle Corporation","Oracle Corporation,#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle Corporation,#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109971580","display_name":"Victor W. Lee","orcid":null},"institutions":[{"id":"https://openalex.org/I4210158342","display_name":"Intel (United Kingdom)","ror":"https://ror.org/058cxws58","country_code":"GB","type":"company","lineage":["https://openalex.org/I1343180700","https://openalex.org/I4210158342"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Victor W. Lee","raw_affiliation_strings":["Intel Corporation"],"affiliations":[{"raw_affiliation_string":"Intel Corporation","institution_ids":["https://openalex.org/I4210158342"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5032299527","display_name":"Eric Sedlar","orcid":"https://orcid.org/0009-0007-1334-6317"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Eric Sedlar","raw_affiliation_strings":["Oracle Corporation","Oracle Corporation,#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle Corporation,#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047809126","display_name":"Anthony D. Nguyen","orcid":null},"institutions":[{"id":"https://openalex.org/I4210158342","display_name":"Intel (United Kingdom)","ror":"https://ror.org/058cxws58","country_code":"GB","type":"company","lineage":["https://openalex.org/I1343180700","https://openalex.org/I4210158342"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Anthony D. Nguyen","raw_affiliation_strings":["Intel Corporation"],"affiliations":[{"raw_affiliation_string":"Intel Corporation","institution_ids":["https://openalex.org/I4210158342"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111985072","display_name":"Nadathur Satish","orcid":null},"institutions":[{"id":"https://openalex.org/I4210158342","display_name":"Intel (United Kingdom)","ror":"https://ror.org/058cxws58","country_code":"GB","type":"company","lineage":["https://openalex.org/I1343180700","https://openalex.org/I4210158342"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Nadathur Satish","raw_affiliation_strings":["Intel Corporation"],"affiliations":[{"raw_affiliation_string":"Intel Corporation","institution_ids":["https://openalex.org/I4210158342"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5059686266","display_name":"Jatin Chhugani","orcid":null},"institutions":[{"id":"https://openalex.org/I4210158342","display_name":"Intel (United Kingdom)","ror":"https://ror.org/058cxws58","country_code":"GB","type":"company","lineage":["https://openalex.org/I1343180700","https://openalex.org/I4210158342"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Jatin Chhugani","raw_affiliation_strings":["Intel Corporation"],"affiliations":[{"raw_affiliation_string":"Intel Corporation","institution_ids":["https://openalex.org/I4210158342"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5089339093","display_name":"Andrea Di Blas","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Andrea Di Blas","raw_affiliation_strings":["Oracle Corporation","Oracle Corporation,#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle Corporation,#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5032238070","display_name":"Pradeep Dubey","orcid":"https://orcid.org/0000-0001-5853-0619"},"institutions":[{"id":"https://openalex.org/I4210158342","display_name":"Intel (United Kingdom)","ror":"https://ror.org/058cxws58","country_code":"GB","type":"company","lineage":["https://openalex.org/I1343180700","https://openalex.org/I4210158342"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Pradeep Dubey","raw_affiliation_strings":["Intel Corporation"],"affiliations":[{"raw_affiliation_string":"Intel Corporation","institution_ids":["https://openalex.org/I4210158342"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":9,"corresponding_author_ids":["https://openalex.org/A5101667271"],"corresponding_institution_ids":["https://openalex.org/I4210158342"],"apc_list":null,"apc_paid":null,"fwci":11.314,"has_fulltext":false,"cited_by_count":282,"citation_normalized_percentile":{"value":0.98695525,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":98,"max":100},"biblio":{"volume":"2","issue":"2","first_page":"1378","last_page":"1389"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9994000196456909,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9994000196456909,"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.9993000030517578,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.996999979019165,"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.845329761505127},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.7617886066436768},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.7104099988937378},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.7078484296798706},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6370587944984436},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.5702556371688843},{"id":"https://openalex.org/keywords/sort","display_name":"sort","score":0.5445684194564819},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.5184199810028076},{"id":"https://openalex.org/keywords/merge","display_name":"Merge (version control)","score":0.49688342213630676},{"id":"https://openalex.org/keywords/merge-sort","display_name":"Merge sort","score":0.4922257959842682},{"id":"https://openalex.org/keywords/double-hashing","display_name":"Double hashing","score":0.4580496847629547},{"id":"https://openalex.org/keywords/hash-table","display_name":"Hash table","score":0.370966374874115},{"id":"https://openalex.org/keywords/sorting-algorithm","display_name":"Sorting algorithm","score":0.3403699994087219},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.20832675695419312},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.15185332298278809},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.08156415820121765}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.845329761505127},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.7617886066436768},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.7104099988937378},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.7078484296798706},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6370587944984436},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.5702556371688843},{"id":"https://openalex.org/C88548561","wikidata":"https://www.wikidata.org/wiki/Q347599","display_name":"sort","level":2,"score":0.5445684194564819},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.5184199810028076},{"id":"https://openalex.org/C197129107","wikidata":"https://www.wikidata.org/wiki/Q1921621","display_name":"Merge (version control)","level":2,"score":0.49688342213630676},{"id":"https://openalex.org/C35555965","wikidata":"https://www.wikidata.org/wiki/Q189057","display_name":"Merge sort","level":4,"score":0.4922257959842682},{"id":"https://openalex.org/C138111711","wikidata":"https://www.wikidata.org/wiki/Q478351","display_name":"Double hashing","level":4,"score":0.4580496847629547},{"id":"https://openalex.org/C67388219","wikidata":"https://www.wikidata.org/wiki/Q207440","display_name":"Hash table","level":3,"score":0.370966374874115},{"id":"https://openalex.org/C108094655","wikidata":"https://www.wikidata.org/wiki/Q181593","display_name":"Sorting algorithm","level":3,"score":0.3403699994087219},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.20832675695419312},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.15185332298278809},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.08156415820121765},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/1687553.1687564","is_oa":false,"landing_page_url":"https://doi.org/10.14778/1687553.1687564","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"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.44999998807907104}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":42,"referenced_works":["https://openalex.org/W1484040604","https://openalex.org/W1493380042","https://openalex.org/W1513982482","https://openalex.org/W1540926161","https://openalex.org/W1568945110","https://openalex.org/W1570320352","https://openalex.org/W1570477871","https://openalex.org/W1598185176","https://openalex.org/W1598618182","https://openalex.org/W1602137482","https://openalex.org/W1645807896","https://openalex.org/W1967810725","https://openalex.org/W1992730709","https://openalex.org/W2007030756","https://openalex.org/W2012802704","https://openalex.org/W2029131452","https://openalex.org/W2050277572","https://openalex.org/W2051244613","https://openalex.org/W2088310495","https://openalex.org/W2098372784","https://openalex.org/W2102967864","https://openalex.org/W2103661488","https://openalex.org/W2111435979","https://openalex.org/W2111519186","https://openalex.org/W2122048769","https://openalex.org/W2127766448","https://openalex.org/W2138520521","https://openalex.org/W2141389982","https://openalex.org/W2147076738","https://openalex.org/W2149663533","https://openalex.org/W2150054597","https://openalex.org/W2155119349","https://openalex.org/W2166955231","https://openalex.org/W2169150396","https://openalex.org/W2170289748","https://openalex.org/W2295428206","https://openalex.org/W2760911295","https://openalex.org/W4243671184","https://openalex.org/W4247913514","https://openalex.org/W4248655967","https://openalex.org/W6629099681","https://openalex.org/W6663491889"],"related_works":["https://openalex.org/W2765396134","https://openalex.org/W1480783219","https://openalex.org/W3037448952","https://openalex.org/W4300167273","https://openalex.org/W4229364780","https://openalex.org/W3116699298","https://openalex.org/W2190513794","https://openalex.org/W3150444501","https://openalex.org/W1606108344","https://openalex.org/W2292693431"],"abstract_inverted_index":{"Join":[0],"is":[1,103,129,145,213,261],"an":[2],"important":[3],"database":[4],"operation.":[5],"As":[6],"computer":[7,36],"architectures":[8],"evolve,":[9],"the":[10,34,40,56,65,76,81,107,122,246,250,259,264],"best":[11,108],"join":[12,22,26,29,46,127,212,218,231,234,252],"algorithm":[13,253],"may":[14],"change":[15,260],"hand.":[16],"This":[17],"paper":[18],"re-examines":[19],"two":[20],"popular":[21],"algorithms":[23,63,177],"--":[24,30],"hash":[25,45,126,217,230,251],"and":[27,83,113,144,197,232],"sort-merge":[28,208,211,233],"to":[31,141,155,164,173,215],"determine":[32],"if":[33],"latest":[35,66,87],"architecture":[37,183],"trends":[38,191],"shift":[39],"tide":[41,247],"that":[42,117,161,188,245,248],"has":[43,254],"favored":[44],"for":[47,90,119,207],"many":[48],"years.":[49],"For":[50],"a":[51,132],"fair":[52],"comparison,":[53],"we":[54,225],"implemented":[55],"most":[57],"optimized":[58,158],"parallel":[59],"version":[60],"of":[61,78,86,124,135,192,229],"both":[62,176],"on":[64,111,219],"Intel":[67],"Core":[68],"i7":[69],"platform.":[70],"Both":[71],"implementations":[72,228],"scale":[73,179],"well":[74],"with":[75,180],"number":[77],"cores":[79],"in":[80],"system":[82],"take":[84],"advantages":[85],"processor":[88,182],"features":[89],"performance.":[91],"Our":[92,185],"hash-based":[93],"implementation":[94,128,154,160],"achieves":[95,162],"more":[96,195],"than":[97,106,116],"100M":[98],"tuples":[99,143,166],"per":[100,167,201],"second":[101],"which":[102,235],"17X":[104],"faster":[105,115],"reported":[109,118,240],"performance":[110,123],"CPUs":[112],"8X":[114],"GPUs.":[120],"Moreover,":[121],"our":[125,156],"consistent":[130],"over":[131],"wide":[133],"range":[134],"input":[136],"data":[137,149],"sizes":[138],"from":[139],"64K":[140],"128M":[142],"not":[146,255],"affected":[147],"by":[148],"skew.":[150],"We":[151,169,242],"compare":[152],"this":[153],"highly":[157],"sort-based":[159],"47M":[163],"80M":[165],"second.":[168],"developed":[170],"analytical":[171],"models":[172],"study":[174],"how":[175],"would":[178],"upcoming":[181,220],"trends.":[184],"analysis":[186],"projects":[187],"current":[189],"architectural":[190],"wider":[193],"SIMD,":[194],"cores,":[196],"smaller":[198],"memory":[199],"bandwidth":[200],"core":[202],"imply":[203],"better":[204],"scalability":[205],"potential":[206],"join.":[209],"Consequently,":[210],"likely":[214],"outperform":[216,237],"chip":[221],"multiprocessors.":[222],"In":[223],"summary,":[224],"offer":[226],"multicore":[227],"consistently":[236],"all":[238],"previously":[239],"results.":[241],"further":[243],"conclude":[244],"favors":[249],"changed":[256],"yet,":[257],"but":[258],"just":[262],"around":[263],"corner.":[265]},"counts_by_year":[{"year":2025,"cited_by_count":10},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":13},{"year":2022,"cited_by_count":11},{"year":2021,"cited_by_count":23},{"year":2020,"cited_by_count":19},{"year":2019,"cited_by_count":15},{"year":2018,"cited_by_count":18},{"year":2017,"cited_by_count":25},{"year":2016,"cited_by_count":16},{"year":2015,"cited_by_count":29},{"year":2014,"cited_by_count":34},{"year":2013,"cited_by_count":29},{"year":2012,"cited_by_count":16}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}