{"id":"https://openalex.org/W1194153933","doi":"https://doi.org/10.14778/2735703.2735704","title":"Improving main memory hash joins on Intel Xeon Phi processors","display_name":"Improving main memory hash joins on Intel Xeon Phi processors","publication_year":2015,"publication_date":"2015-02-01","ids":{"openalex":"https://openalex.org/W1194153933","doi":"https://doi.org/10.14778/2735703.2735704","mag":"1194153933"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.14778/2735703.2735704","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":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"journal-article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://dr.ntu.edu.sg/bitstream/10356/87784/1/Improving%20main%20memory%20hash%20joins%20on%20Intel%20Xeon%20Phi%20processors%20an%20experimental%20approach.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5016778130","display_name":"Saurabh Jha","orcid":"https://orcid.org/0000-0003-0926-0776"},"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":"Saurabh Jha","raw_affiliation_strings":["Nanyang Technological University (Singapore)"],"affiliations":[{"raw_affiliation_string":"Nanyang Technological University (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/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":"Bingsheng He","raw_affiliation_strings":["Nanyang Technological University (Singapore)"],"affiliations":[{"raw_affiliation_string":"Nanyang Technological University (Singapore)","institution_ids":["https://openalex.org/I172675005"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103114808","display_name":"Mian Lu","orcid":"https://orcid.org/0009-0002-4853-8881"},"institutions":[{"id":"https://openalex.org/I115228651","display_name":"Agency for Science, Technology and Research","ror":"https://ror.org/036wvzt09","country_code":"SG","type":"government","lineage":["https://openalex.org/I115228651"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Mian Lu","raw_affiliation_strings":["A*Star, IHPC, Singapore"],"affiliations":[{"raw_affiliation_string":"A*Star, IHPC, Singapore","institution_ids":["https://openalex.org/I115228651"]}]},{"author_position":"middle","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":false,"raw_author_name":"Xuntao Cheng","raw_affiliation_strings":["Nanyang Technological University"],"affiliations":[{"raw_affiliation_string":"Nanyang Technological University","institution_ids":["https://openalex.org/I172675005"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5077959628","display_name":"Huynh Phung Huynh","orcid":null},"institutions":[{"id":"https://openalex.org/I115228651","display_name":"Agency for Science, Technology and Research","ror":"https://ror.org/036wvzt09","country_code":"SG","type":"government","lineage":["https://openalex.org/I115228651"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Huynh Phung Huynh","raw_affiliation_strings":["A*Star, IHPC, Singapore"],"affiliations":[{"raw_affiliation_string":"A*Star, IHPC, Singapore","institution_ids":["https://openalex.org/I115228651"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":13.536,"has_fulltext":true,"fulltext_origin":"pdf","cited_by_count":75,"citation_normalized_percentile":{"value":0.999957,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":97,"max":98},"biblio":{"volume":"8","issue":"6","first_page":"642","last_page":"653"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9996,"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.9996,"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.9988,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.997,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/xeon-phi","display_name":"Xeon Phi","score":0.97641575},{"id":"https://openalex.org/keywords/x86","display_name":"x86","score":0.72082853},{"id":"https://openalex.org/keywords/simd","display_name":"SIMD","score":0.5756789},{"id":"https://openalex.org/keywords/xeon","display_name":"Xeon","score":0.5457352},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.5361168}],"concepts":[{"id":"https://openalex.org/C96972482","wikidata":"https://www.wikidata.org/wiki/Q1049168","display_name":"Xeon Phi","level":2,"score":0.97641575},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8097261},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.7363323},{"id":"https://openalex.org/C170723468","wikidata":"https://www.wikidata.org/wiki/Q182933","display_name":"x86","level":3,"score":0.72082853},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.6235329},{"id":"https://openalex.org/C150552126","wikidata":"https://www.wikidata.org/wiki/Q339387","display_name":"SIMD","level":2,"score":0.5756789},{"id":"https://openalex.org/C145108525","wikidata":"https://www.wikidata.org/wiki/Q656154","display_name":"Xeon","level":2,"score":0.5457352},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.5361168},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.5245835},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.47363418},{"id":"https://openalex.org/C118524514","wikidata":"https://www.wikidata.org/wiki/Q173212","display_name":"Computer architecture","level":1,"score":0.32501805},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.25422645},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.131879}],"mesh":[],"locations_count":2,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.14778/2735703.2735704","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":null,"is_accepted":false,"is_published":false},{"is_oa":true,"landing_page_url":"https://hdl.handle.net/10356/87784","pdf_url":"https://dr.ntu.edu.sg/bitstream/10356/87784/1/Improving%20main%20memory%20hash%20joins%20on%20Intel%20Xeon%20Phi%20processors%20an%20experimental%20approach.pdf","source":{"id":"https://openalex.org/S4306402609","display_name":"DR-NTU (Nanyang Technological University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I172675005","host_organization_name":"Nanyang Technological University","host_organization_lineage":["https://openalex.org/I172675005"],"host_organization_lineage_names":["Nanyang Technological University"],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true}],"best_oa_location":{"is_oa":true,"landing_page_url":"https://hdl.handle.net/10356/87784","pdf_url":"https://dr.ntu.edu.sg/bitstream/10356/87784/1/Improving%20main%20memory%20hash%20joins%20on%20Intel%20Xeon%20Phi%20processors%20an%20experimental%20approach.pdf","source":{"id":"https://openalex.org/S4306402609","display_name":"DR-NTU (Nanyang Technological University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I172675005","host_organization_name":"Nanyang Technological University","host_organization_lineage":["https://openalex.org/I172675005"],"host_organization_lineage_names":["Nanyang Technological University"],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true},"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":22,"referenced_works":["https://openalex.org/W1570477871","https://openalex.org/W1999329795","https://openalex.org/W2004772832","https://openalex.org/W2050277572","https://openalex.org/W2066860750","https://openalex.org/W2068418796","https://openalex.org/W2072541977","https://openalex.org/W2082695854","https://openalex.org/W2097880677","https://openalex.org/W2099580433","https://openalex.org/W2109631432","https://openalex.org/W2115229350","https://openalex.org/W2120385681","https://openalex.org/W2122048769","https://openalex.org/W2125529470","https://openalex.org/W2130911657","https://openalex.org/W2137269004","https://openalex.org/W2159287299","https://openalex.org/W2170996201","https://openalex.org/W2212175592","https://openalex.org/W2291942110","https://openalex.org/W2406955896"],"related_works":["https://openalex.org/W3042238487","https://openalex.org/W2885985254","https://openalex.org/W2769399951","https://openalex.org/W2740999212","https://openalex.org/W2599563411","https://openalex.org/W2588843388","https://openalex.org/W2188971969","https://openalex.org/W2056079253","https://openalex.org/W2024554511","https://openalex.org/W1994052277"],"abstract_inverted_index":{"Modern":[0],"processor":[1],"technologies":[2],"have":[3],"driven":[4],"new":[5,171],"designs":[6],"and":[7,48,96,114,151,173,201],"implementations":[8],"in":[9,120,161],"main-memory":[10],"hash":[11,65,79],"joins.":[12],"Recently,":[13],"Intel":[14],"Many":[15],"Integrated":[16],"Core":[17],"(MIC)":[18],"co-processors":[19],"(commonly":[20],"known":[21],"as":[22,51,53],"Xeon":[23,36,69,118,134,159,176],"Phi)":[24],"embrace":[25],"emerging":[26],"x86":[27],"single-chip":[28,208],"many-core":[29,209],"techniques.":[30],"Compared":[31],"with":[32,122,163],"contemporary":[33],"multi-core":[34,125,143],"CPUs,":[35],"Phi":[37,70,119,160],"has":[38,154],"quite":[39,155],"different":[40,139,156],"architectural":[41,112,149],"features:":[42],"wider":[43],"SIMD":[44],"instructions,":[45],"many":[46],"cores":[47],"hardware":[49,94,179,184],"contexts,":[50],"well":[52],"lower-frequency":[54],"in-order":[55],"cores.":[56],"In":[57,72],"this":[58],"paper,":[59],"we":[60,74,107],"experimentally":[61],"revisit":[62],"the":[63,89,109,146,166,199],"state-of-the-art":[64],"join":[66,80,90],"algorithms":[67,91,181,186],"on":[68,117,124,133,142,158,165,175,187,198,206],"co-processors.":[71],"particular,":[73],"study":[75,108],"two":[76,130,193],"camps":[77],"of":[78,88,111,148,203],"algorithms:":[81],"hardware-conscious":[82],"ones":[83,98],"that":[84,99],"advocate":[85],"careful":[86,102],"tailoring":[87],"to":[92],"underlying":[93],"architectures":[95],"hardware-oblivious":[97],"omit":[100],"such":[101],"tailoring.":[103],"For":[104],"each":[105],"camp,":[106],"impact":[110,147],"features":[113,150],"software":[115,152],"optimizations":[116,153],"comparison":[121,162],"results":[123],"CPUs.":[126,144],"Our":[127],"experiments":[128],"show":[129],"major":[131],"findings":[132,194],"Phi,":[135],"which":[136,168],"are":[137],"quantitatively":[138],"from":[140],"those":[141,164],"First,":[145],"behavior":[157],"CPU,":[167],"calls":[169],"for":[170],"optimization":[172],"tuning":[174],"Phi.":[177],"Second,":[178],"oblivious":[180],"can":[182],"outperform":[183],"conscious":[185],"a":[188],"wide":[189],"parameter":[190],"window.":[191],"These":[192],"further":[195],"shed":[196],"light":[197],"design":[200],"implementation":[202],"query":[204],"processing":[205],"new-generation":[207],"technologies.":[210]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W1194153933","counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":7},{"year":2019,"cited_by_count":14},{"year":2018,"cited_by_count":15},{"year":2017,"cited_by_count":12},{"year":2016,"cited_by_count":11},{"year":2015,"cited_by_count":8}],"updated_date":"2024-12-12T09:10:53.725633","created_date":"2016-06-24"}