{"id":"https://openalex.org/W4366660365","doi":"https://doi.org/10.14778/3583140.3583144","title":"A Design Space Exploration and Evaluation for Main-Memory Hash Joins in Storage Class Memory","display_name":"A Design Space Exploration and Evaluation for Main-Memory Hash Joins in Storage Class Memory","publication_year":2023,"publication_date":"2023-02-01","ids":{"openalex":"https://openalex.org/W4366660365","doi":"https://doi.org/10.14778/3583140.3583144"},"language":"en","primary_location":{"id":"doi:10.14778/3583140.3583144","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3583140.3583144","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/A5100608427","display_name":"Wentao Huang","orcid":"https://orcid.org/0000-0003-1583-9258"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":true,"raw_author_name":"Wentao Huang","raw_affiliation_strings":["National University of Singapore"],"affiliations":[{"raw_affiliation_string":"National University of Singapore","institution_ids":["https://openalex.org/I165932596"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001589491","display_name":"Yunhong Ji","orcid":"https://orcid.org/0000-0002-6950-1415"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yunhong Ji","raw_affiliation_strings":["Renmin University of China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5104109005","display_name":"Xuan Zhou","orcid":"https://orcid.org/0000-0001-5750-1728"},"institutions":[{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xuan Zhou","raw_affiliation_strings":["East China Normal University"],"affiliations":[{"raw_affiliation_string":"East China Normal University","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5039946576","display_name":"Bingsheng He","orcid":"https://orcid.org/0000-0001-8618-4581"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Bingsheng He","raw_affiliation_strings":["National University of Singapore"],"affiliations":[{"raw_affiliation_string":"National University of Singapore","institution_ids":["https://openalex.org/I165932596"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5077593594","display_name":"Kian\u2010Lee Tan","orcid":"https://orcid.org/0000-0001-9315-4057"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Kian-Lee Tan","raw_affiliation_strings":["National University of Singapore"],"affiliations":[{"raw_affiliation_string":"National University of Singapore","institution_ids":["https://openalex.org/I165932596"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5100608427"],"corresponding_institution_ids":["https://openalex.org/I165932596"],"apc_list":null,"apc_paid":null,"fwci":1.4064,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.81669274,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":98},"biblio":{"volume":"16","issue":"6","first_page":"1249","last_page":"1263"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11478","display_name":"Caching and Content Delivery","score":0.9998999834060669,"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.9998999834060669,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998000264167786,"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/T12326","display_name":"Network Packet Processing and Optimization","score":0.9926000237464905,"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/joins","display_name":"Joins","score":0.9050793647766113},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.7882825136184692},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7690651416778564},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.7295237183570862},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.5869654417037964},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.4643457531929016},{"id":"https://openalex.org/keywords/space","display_name":"Space (punctuation)","score":0.43420708179473877},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.41065704822540283},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.3561212122440338},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.13820713758468628},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.11247578263282776},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.11241832375526428},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.08715838193893433}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.9050793647766113},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.7882825136184692},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7690651416778564},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.7295237183570862},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.5869654417037964},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.4643457531929016},{"id":"https://openalex.org/C2778572836","wikidata":"https://www.wikidata.org/wiki/Q380933","display_name":"Space (punctuation)","level":2,"score":0.43420708179473877},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.41065704822540283},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.3561212122440338},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.13820713758468628},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.11247578263282776},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.11241832375526428},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.08715838193893433},{"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/3583140.3583144","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3583140.3583144","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":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":49,"referenced_works":["https://openalex.org/W2007030756","https://openalex.org/W2014332937","https://openalex.org/W2026165893","https://openalex.org/W2028802049","https://openalex.org/W2072541977","https://openalex.org/W2099580433","https://openalex.org/W2112553085","https://openalex.org/W2117169958","https://openalex.org/W2122048769","https://openalex.org/W2125529470","https://openalex.org/W2127277527","https://openalex.org/W2258963578","https://openalex.org/W2282225439","https://openalex.org/W2292693431","https://openalex.org/W2294108820","https://openalex.org/W2406955896","https://openalex.org/W2578260324","https://openalex.org/W2734941459","https://openalex.org/W2894678934","https://openalex.org/W2897266976","https://openalex.org/W2911664490","https://openalex.org/W3000259868","https://openalex.org/W3012122565","https://openalex.org/W3012257206","https://openalex.org/W3012550338","https://openalex.org/W3024918606","https://openalex.org/W3033163384","https://openalex.org/W3037631006","https://openalex.org/W3094882177","https://openalex.org/W3095213285","https://openalex.org/W3100941245","https://openalex.org/W3131236281","https://openalex.org/W3136326637","https://openalex.org/W3136572593","https://openalex.org/W3165152505","https://openalex.org/W4206548428","https://openalex.org/W4220669418","https://openalex.org/W4220971929","https://openalex.org/W4221109816","https://openalex.org/W4255327858","https://openalex.org/W4286800516","https://openalex.org/W4312277017","https://openalex.org/W4312478967","https://openalex.org/W4312578340","https://openalex.org/W4312757686","https://openalex.org/W4312932778","https://openalex.org/W4313013338","https://openalex.org/W4366660365","https://openalex.org/W7011105484"],"related_works":["https://openalex.org/W2393491644","https://openalex.org/W4206577045","https://openalex.org/W650102067","https://openalex.org/W2740404111","https://openalex.org/W1550806730","https://openalex.org/W1496672428","https://openalex.org/W2589740103","https://openalex.org/W1501284171","https://openalex.org/W1966967794","https://openalex.org/W3086237447"],"abstract_inverted_index":{"In":[0,20],"this":[1],"paper,":[2],"we":[3,22,57,93],"seek":[4],"to":[5,51,110],"perform":[6,23],"a":[7,24,59,63],"rigorous":[8,60],"experimental":[9,90],"study":[10],"of":[11,66],"main-memory":[12],"hash":[13,37,42],"joins":[14,70],"in":[15,28,82,103,112],"storage":[16],"class":[17],"memory":[18],"(SCM).":[19],"particular,":[21],"design":[25],"space":[26],"exploration":[27],"real":[29,83,113],"SCM":[30,84],"for":[31,68,76],"two":[32],"state-of-the-art":[33],"join":[34,38,43],"algorithms:":[35],"partitioned":[36],"(PHJ)":[39],"and":[40,45,71],"non-partitioned":[41],"(NPHJ),":[44],"identify":[46],"the":[47,78,87],"most":[48,79,88],"crucial":[49],"factors":[50],"implement":[52],"an":[53,73],"SCM-friendly":[54],"join.":[55],"Moreover,":[56],"present":[58],"evaluation":[61],"with":[62],"broad":[64],"spectrum":[65],"workloads":[67],"both":[69],"provide":[72],"in-depth":[74],"analysis":[75,91],"choosing":[77],"suitable":[80],"algorithm":[81],"environment.":[85],"With":[86],"extensive":[89],"up-to-date,":[92],"maintain":[94],"that":[95],"although":[96],"there":[97],"is":[98,107],"no":[99],"one":[100],"universal":[101],"winner":[102],"all":[104],"scenarios,":[105],"PHJ":[106],"generally":[108],"superior":[109],"NPHJ":[111],"SCM.":[114]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}