{"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":{"id":"doi:10.14778/2735703.2735704","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":"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":true,"oa_status":"green","oa_url":"https://hdl.handle.net/10356/87784","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":true,"raw_author_name":"Saurabh Jha","raw_affiliation_strings":["Nanyang Technological University, Singapore","Nanyang Technological University (Singapore)"],"affiliations":[{"raw_affiliation_string":"Nanyang Technological University, Singapore","institution_ids":["https://openalex.org/I172675005"]},{"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","Nanyang Technological University (Singapore)"],"affiliations":[{"raw_affiliation_string":"Nanyang Technological University, Singapore","institution_ids":["https://openalex.org/I172675005"]},{"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"]},{"id":"https://openalex.org/I4210161496","display_name":"A*STAR Graduate Academy","ror":"https://ror.org/059yjzn93","country_code":"SG","type":"education","lineage":["https://openalex.org/I115228651","https://openalex.org/I4210161496"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Mian Lu","raw_affiliation_strings":["A*STAR IHPC, Singapore","A*Star, IHPC, Singapore"],"affiliations":[{"raw_affiliation_string":"A*STAR IHPC, Singapore","institution_ids":["https://openalex.org/I4210161496"]},{"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"]},{"id":"https://openalex.org/I4210161496","display_name":"A*STAR Graduate Academy","ror":"https://ror.org/059yjzn93","country_code":"SG","type":"education","lineage":["https://openalex.org/I115228651","https://openalex.org/I4210161496"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Huynh Phung Huynh","raw_affiliation_strings":["A*STAR IHPC, Singapore","A*Star, IHPC, Singapore"],"affiliations":[{"raw_affiliation_string":"A*STAR IHPC, Singapore","institution_ids":["https://openalex.org/I4210161496"]},{"raw_affiliation_string":"A*Star, IHPC, Singapore","institution_ids":["https://openalex.org/I115228651"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5016778130"],"corresponding_institution_ids":["https://openalex.org/I172675005"],"apc_list":null,"apc_paid":null,"fwci":15.2245,"has_fulltext":false,"cited_by_count":74,"citation_normalized_percentile":{"value":0.99352184,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":100},"biblio":{"volume":"8","issue":"6","first_page":"642","last_page":"653"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12326","display_name":"Network Packet Processing and Optimization","score":0.21559999883174896,"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"}},"topics":[{"id":"https://openalex.org/T12326","display_name":"Network Packet Processing and Optimization","score":0.21559999883174896,"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"}},{"id":"https://openalex.org/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.15219999849796295,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.12250000238418579,"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/xeon-phi","display_name":"Xeon Phi","score":0.976415753364563},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8097261190414429},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.7363322973251343},{"id":"https://openalex.org/keywords/x86","display_name":"x86","score":0.7208285331726074},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.6235328912734985},{"id":"https://openalex.org/keywords/simd","display_name":"SIMD","score":0.5756788849830627},{"id":"https://openalex.org/keywords/xeon","display_name":"Xeon","score":0.5457351803779602},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.5361167788505554},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.5245835185050964},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.47363418340682983},{"id":"https://openalex.org/keywords/computer-architecture","display_name":"Computer architecture","score":0.325018048286438},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.2542264461517334},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.13187900185585022}],"concepts":[{"id":"https://openalex.org/C96972482","wikidata":"https://www.wikidata.org/wiki/Q1049168","display_name":"Xeon Phi","level":2,"score":0.976415753364563},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8097261190414429},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.7363322973251343},{"id":"https://openalex.org/C170723468","wikidata":"https://www.wikidata.org/wiki/Q182933","display_name":"x86","level":3,"score":0.7208285331726074},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.6235328912734985},{"id":"https://openalex.org/C150552126","wikidata":"https://www.wikidata.org/wiki/Q339387","display_name":"SIMD","level":2,"score":0.5756788849830627},{"id":"https://openalex.org/C145108525","wikidata":"https://www.wikidata.org/wiki/Q656154","display_name":"Xeon","level":2,"score":0.5457351803779602},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.5361167788505554},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.5245835185050964},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.47363418340682983},{"id":"https://openalex.org/C118524514","wikidata":"https://www.wikidata.org/wiki/Q173212","display_name":"Computer architecture","level":1,"score":0.325018048286438},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2542264461517334},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.13187900185585022}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.14778/2735703.2735704","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":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmh:oai:dr.ntu.edu.sg:10356/87784","is_oa":true,"landing_page_url":"https://hdl.handle.net/10356/87784","pdf_url":null,"source":{"id":"https://openalex.org/S4306402609","display_name":"DR-NTU (Nanyang Technological University)","issn_l":null,"issn":null,"is_oa":false,"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":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Journal Article"}],"best_oa_location":{"id":"pmh:oai:dr.ntu.edu.sg:10356/87784","is_oa":true,"landing_page_url":"https://hdl.handle.net/10356/87784","pdf_url":null,"source":{"id":"https://openalex.org/S4306402609","display_name":"DR-NTU (Nanyang Technological University)","issn_l":null,"issn":null,"is_oa":false,"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":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Journal Article"},"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320322724","display_name":"Ministry of Education, India","ror":"https://ror.org/048xjjh50"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"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/W2740999212","https://openalex.org/W2188971969","https://openalex.org/W2056079253","https://openalex.org/W1994052277","https://openalex.org/W2769399951","https://openalex.org/W2024554511","https://openalex.org/W2588843388","https://openalex.org/W3042238487","https://openalex.org/W2885985254","https://openalex.org/W2599563411"],"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]},"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":8},{"year":2019,"cited_by_count":13},{"year":2018,"cited_by_count":14},{"year":2017,"cited_by_count":12},{"year":2016,"cited_by_count":11},{"year":2015,"cited_by_count":8}],"updated_date":"2026-03-03T08:47:05.690250","created_date":"2025-10-10T00:00:00"}