{"id":"https://openalex.org/W2767926324","doi":"https://doi.org/10.1145/3132847.3132916","title":"A Study of Main-Memory Hash Joins on Many-core Processor","display_name":"A Study of Main-Memory Hash Joins on Many-core Processor","publication_year":2017,"publication_date":"2017-11-06","ids":{"openalex":"https://openalex.org/W2767926324","doi":"https://doi.org/10.1145/3132847.3132916","mag":"2767926324"},"language":"en","primary_location":{"id":"doi:10.1145/3132847.3132916","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3132847.3132916","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2017 ACM on Conference on Information and Knowledge Management","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/A5101024540","display_name":"Xuntao Cheng","orcid":null},"institutions":[{"id":"https://openalex.org/I172675005","display_name":"Nanyang Technological University","ror":"https://ror.org/02e7b5302","country_code":"SG","type":"education","lineage":["https://openalex.org/I172675005"]}],"countries":["SG"],"is_corresponding":true,"raw_author_name":"Xuntao Cheng","raw_affiliation_strings":["Nanyang Technological University, Singapore, Singapore"],"affiliations":[{"raw_affiliation_string":"Nanyang Technological University, Singapore, Singapore","institution_ids":["https://openalex.org/I172675005"]}]},{"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, Singapore, Singapore"],"affiliations":[{"raw_affiliation_string":"National University of Singapore, Singapore, Singapore","institution_ids":["https://openalex.org/I165932596"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5081729342","display_name":"Xiaoli Du","orcid":null},"institutions":[{"id":"https://openalex.org/I170215575","display_name":"National University of Defense Technology","ror":"https://ror.org/05d2yfz11","country_code":"CN","type":"education","lineage":["https://openalex.org/I170215575"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiaoli Du","raw_affiliation_strings":["National University of Defense Technology, Changsha, China"],"affiliations":[{"raw_affiliation_string":"National University of Defense Technology, Changsha, China","institution_ids":["https://openalex.org/I170215575"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5113573780","display_name":"Chiew Tong Lau","orcid":null},"institutions":[{"id":"https://openalex.org/I172675005","display_name":"Nanyang Technological University","ror":"https://ror.org/02e7b5302","country_code":"SG","type":"education","lineage":["https://openalex.org/I172675005"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Chiew Tong Lau","raw_affiliation_strings":["Nanyang Technological University, Singapore, Singapore"],"affiliations":[{"raw_affiliation_string":"Nanyang Technological University, Singapore, Singapore","institution_ids":["https://openalex.org/I172675005"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5101024540"],"corresponding_institution_ids":["https://openalex.org/I172675005"],"apc_list":null,"apc_paid":null,"fwci":4.3512,"has_fulltext":false,"cited_by_count":23,"citation_normalized_percentile":{"value":0.95151468,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"657","last_page":"666"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9990000128746033,"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.9990000128746033,"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/T11478","display_name":"Caching and Content Delivery","score":0.9987999796867371,"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9983999729156494,"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/computer-science","display_name":"Computer science","score":0.8557300567626953},{"id":"https://openalex.org/keywords/xeon-phi","display_name":"Xeon Phi","score":0.742638111114502},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.7156482338905334},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.6160643696784973},{"id":"https://openalex.org/keywords/memory-bandwidth","display_name":"Memory bandwidth","score":0.5743129253387451},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.5648953914642334},{"id":"https://openalex.org/keywords/bandwidth","display_name":"Bandwidth (computing)","score":0.4414075016975403},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.43336454033851624},{"id":"https://openalex.org/keywords/computer-architecture","display_name":"Computer architecture","score":0.4216667115688324},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.15265721082687378},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.08181267976760864}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8557300567626953},{"id":"https://openalex.org/C96972482","wikidata":"https://www.wikidata.org/wiki/Q1049168","display_name":"Xeon Phi","level":2,"score":0.742638111114502},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.7156482338905334},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.6160643696784973},{"id":"https://openalex.org/C188045654","wikidata":"https://www.wikidata.org/wiki/Q17148339","display_name":"Memory bandwidth","level":2,"score":0.5743129253387451},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.5648953914642334},{"id":"https://openalex.org/C2776257435","wikidata":"https://www.wikidata.org/wiki/Q1576430","display_name":"Bandwidth (computing)","level":2,"score":0.4414075016975403},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.43336454033851624},{"id":"https://openalex.org/C118524514","wikidata":"https://www.wikidata.org/wiki/Q173212","display_name":"Computer architecture","level":1,"score":0.4216667115688324},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.15265721082687378},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.08181267976760864}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3132847.3132916","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3132847.3132916","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2017 ACM on Conference on Information and Knowledge Management","raw_type":"proceedings-article"},{"id":"pmh:oai:scholarbank.nus.edu.sg:10635/173886","is_oa":false,"landing_page_url":"https://scholarbank.nus.edu.sg/handle/10635/173886","pdf_url":null,"source":{"id":"https://openalex.org/S7407052290","display_name":"National University of Singapore","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Conference Paper"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.46000000834465027}],"awards":[{"id":"https://openalex.org/G2227024940","display_name":null,"funder_award_id":"IDM Futures Funding Initiative","funder_id":"https://openalex.org/F4320320709","funder_display_name":"National Research Foundation Singapore"},{"id":"https://openalex.org/G3453858347","display_name":null,"funder_award_id":"T1 251RES1610","funder_id":"https://openalex.org/F4320320751","funder_display_name":"Ministry of Education - Singapore"}],"funders":[{"id":"https://openalex.org/F4320320709","display_name":"National Research Foundation Singapore","ror":"https://ror.org/03cpyc314"},{"id":"https://openalex.org/F4320320751","display_name":"Ministry of Education - Singapore","ror":"https://ror.org/01kcva023"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":31,"referenced_works":["https://openalex.org/W1194153933","https://openalex.org/W1570477871","https://openalex.org/W1816580784","https://openalex.org/W1970942435","https://openalex.org/W2003515726","https://openalex.org/W2004772832","https://openalex.org/W2014214820","https://openalex.org/W2019183416","https://openalex.org/W2050277572","https://openalex.org/W2055774867","https://openalex.org/W2066860750","https://openalex.org/W2072541977","https://openalex.org/W2082695854","https://openalex.org/W2086977914","https://openalex.org/W2090622351","https://openalex.org/W2097880677","https://openalex.org/W2099035968","https://openalex.org/W2099580433","https://openalex.org/W2102729946","https://openalex.org/W2125529470","https://openalex.org/W2131413854","https://openalex.org/W2406955896","https://openalex.org/W2438623667","https://openalex.org/W2440477515","https://openalex.org/W2444650685","https://openalex.org/W2475636809","https://openalex.org/W2485412435","https://openalex.org/W2548100623","https://openalex.org/W2578785406","https://openalex.org/W2746871167","https://openalex.org/W3139689176"],"related_works":["https://openalex.org/W4380591969","https://openalex.org/W2148838171","https://openalex.org/W2572223517","https://openalex.org/W2069307110","https://openalex.org/W2947004196","https://openalex.org/W2126624503","https://openalex.org/W4226441432","https://openalex.org/W2140894225","https://openalex.org/W3214526314","https://openalex.org/W2043224356"],"abstract_inverted_index":{"Advanced":[0],"processor":[1,24],"architectures":[2],"have":[3,111],"been":[4],"driving":[5],"new":[6,67],"designs,":[7],"implementations":[8],"and":[9,46,76,117],"optimizations":[10,98],"of":[11,25,70],"main-memory":[12,59],"hash":[13,60],"join":[14,61],"algorithms":[15,62,110],"recently.":[16],"The":[17],"newly":[18],"released":[19],"Intel":[20],"Xeon":[21],"Phi":[22],"many-core":[23],"the":[26,57,66,73,83,108,114],"Knights":[27],"Landing":[28],"architecture":[29],"(KNL)":[30],"embraces":[31],"interesting":[32],"hardware":[33,68,119],"features":[34,69],"such":[35],"as":[36,78,80],"many":[37,96],"low-frequency":[38],"out-of-order":[39],"cores":[40],"connected":[41],"on":[42,89,102],"a":[43],"2D":[44],"mesh,":[45],"high-bandwidth":[47],"multi-channel":[48],"memory":[49,115],"(MCDRAM).":[50],"In":[51],"this":[52],"paper,":[53],"we":[54],"experimentally":[55],"revisit":[56],"state-of-the-art":[58,109],"to":[63,81],"study":[64],"how":[65],"KNL":[71,103],"affect":[72],"algorithmic":[74],"design":[75],"tuning":[77],"well":[79],"identify":[82],"opportunities":[84],"for":[85],"further":[86],"performance":[87],"improvement":[88],"KNL.":[90],"Our":[91],"experiments":[92],"show":[93],"that,":[94],"although":[95],"existing":[97],"are":[99],"still":[100],"valid":[101],"with":[104],"proper":[105],"tuning,":[106],"even":[107],"severely":[112],"underutilized":[113],"bandwidth":[116],"other":[118],"resources.":[120]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":5},{"year":2019,"cited_by_count":10},{"year":2018,"cited_by_count":5},{"year":2017,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2017-11-17T00:00:00"}