{"id":"https://openalex.org/W4410886898","doi":"https://doi.org/10.1109/mm.2025.3574357","title":"Improving SQL Join Algorithms for Distributed Systems: A Case Study of Compute Express Link-Based Multihost Shared Memory","display_name":"Improving SQL Join Algorithms for Distributed Systems: A Case Study of Compute Express Link-Based Multihost Shared Memory","publication_year":2025,"publication_date":"2025-05-30","ids":{"openalex":"https://openalex.org/W4410886898","doi":"https://doi.org/10.1109/mm.2025.3574357"},"language":"en","primary_location":{"id":"doi:10.1109/mm.2025.3574357","is_oa":false,"landing_page_url":"https://doi.org/10.1109/mm.2025.3574357","pdf_url":null,"source":{"id":"https://openalex.org/S59697426","display_name":"IEEE Micro","issn_l":"0272-1732","issn":["0272-1732","1937-4143"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Micro","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/A5011583026","display_name":"JaeYung Jun","orcid":null},"institutions":[{"id":"https://openalex.org/I134353371","display_name":"SK Group (South Korea)","ror":"https://ror.org/03696td91","country_code":"KR","type":"company","lineage":["https://openalex.org/I134353371"]}],"countries":["KR"],"is_corresponding":true,"raw_author_name":"JaeYung Jun","raw_affiliation_strings":["SK hynix Inc., Icheon, South Korea"],"raw_orcid":"https://orcid.org/0000-0002-1840-8114","affiliations":[{"raw_affiliation_string":"SK hynix Inc., Icheon, South Korea","institution_ids":["https://openalex.org/I134353371"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112764084","display_name":"Hyun-Soo Ahn","orcid":null},"institutions":[{"id":"https://openalex.org/I134353371","display_name":"SK Group (South Korea)","ror":"https://ror.org/03696td91","country_code":"KR","type":"company","lineage":["https://openalex.org/I134353371"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"HyunWoong Ahn","raw_affiliation_strings":["SK hynix Inc., Icheon, South Korea"],"raw_orcid":"https://orcid.org/0009-0007-8418-209X","affiliations":[{"raw_affiliation_string":"SK hynix Inc., Icheon, South Korea","institution_ids":["https://openalex.org/I134353371"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Joohee Lee","orcid":"https://orcid.org/0000-0002-1519-8174"},"institutions":[{"id":"https://openalex.org/I134353371","display_name":"SK Group (South Korea)","ror":"https://ror.org/03696td91","country_code":"KR","type":"company","lineage":["https://openalex.org/I134353371"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Joohee Lee","raw_affiliation_strings":["SK hynix Inc., Icheon, South Korea"],"raw_orcid":"https://orcid.org/0000-0002-1519-8174","affiliations":[{"raw_affiliation_string":"SK hynix Inc., Icheon, South Korea","institution_ids":["https://openalex.org/I134353371"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5012713127","display_name":"Jungmin Choi","orcid":null},"institutions":[{"id":"https://openalex.org/I134353371","display_name":"SK Group (South Korea)","ror":"https://ror.org/03696td91","country_code":"KR","type":"company","lineage":["https://openalex.org/I134353371"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Jungmin Choi","raw_affiliation_strings":["SK hynix Inc., Icheon, South Korea"],"raw_orcid":"https://orcid.org/0000-0001-7875-5620","affiliations":[{"raw_affiliation_string":"SK hynix Inc., Icheon, South Korea","institution_ids":["https://openalex.org/I134353371"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057758277","display_name":"Byungil Koh","orcid":"https://orcid.org/0000-0002-1110-9971"},"institutions":[{"id":"https://openalex.org/I134353371","display_name":"SK Group (South Korea)","ror":"https://ror.org/03696td91","country_code":"KR","type":"company","lineage":["https://openalex.org/I134353371"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Byungil Koh","raw_affiliation_strings":["SK hynix Inc., Icheon, South Korea"],"raw_orcid":"https://orcid.org/0000-0002-1110-9971","affiliations":[{"raw_affiliation_string":"SK hynix Inc., Icheon, South Korea","institution_ids":["https://openalex.org/I134353371"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064436696","display_name":"Donguk Moon","orcid":"https://orcid.org/0000-0002-5821-6803"},"institutions":[{"id":"https://openalex.org/I134353371","display_name":"SK Group (South Korea)","ror":"https://ror.org/03696td91","country_code":"KR","type":"company","lineage":["https://openalex.org/I134353371"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Donguk Moon","raw_affiliation_strings":["SK hynix Inc., Icheon, South Korea"],"raw_orcid":"https://orcid.org/0000-0002-5821-6803","affiliations":[{"raw_affiliation_string":"SK hynix Inc., Icheon, South Korea","institution_ids":["https://openalex.org/I134353371"]}]},{"author_position":"last","author":{"id":null,"display_name":"Hoshik Kim","orcid":null},"institutions":[{"id":"https://openalex.org/I134353371","display_name":"SK Group (South Korea)","ror":"https://ror.org/03696td91","country_code":"KR","type":"company","lineage":["https://openalex.org/I134353371"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Hoshik Kim","raw_affiliation_strings":["SK hynix Inc., Icheon, South Korea"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SK hynix Inc., Icheon, South Korea","institution_ids":["https://openalex.org/I134353371"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5011583026"],"corresponding_institution_ids":["https://openalex.org/I134353371"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.11863559,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"45","issue":"6","first_page":"73","last_page":"81"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9800000190734863,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9800000190734863,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9409999847412109,"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/T13734","display_name":"Advanced Computational Techniques and Applications","score":0.930400013923645,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.9177588224411011},{"id":"https://openalex.org/keywords/host","display_name":"Host (biology)","score":0.692404568195343},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.5974785089492798},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.5767673254013062},{"id":"https://openalex.org/keywords/shared-memory","display_name":"Shared memory","score":0.44279956817626953},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.42333558201789856},{"id":"https://openalex.org/keywords/distributed-memory","display_name":"Distributed memory","score":0.4222296476364136},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.39673560857772827},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.3303726613521576},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.32521241903305054},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2871297001838684}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9177588224411011},{"id":"https://openalex.org/C126831891","wikidata":"https://www.wikidata.org/wiki/Q221673","display_name":"Host (biology)","level":2,"score":0.692404568195343},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.5974785089492798},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.5767673254013062},{"id":"https://openalex.org/C133875982","wikidata":"https://www.wikidata.org/wiki/Q764810","display_name":"Shared memory","level":2,"score":0.44279956817626953},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.42333558201789856},{"id":"https://openalex.org/C91481028","wikidata":"https://www.wikidata.org/wiki/Q1054686","display_name":"Distributed memory","level":3,"score":0.4222296476364136},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.39673560857772827},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3303726613521576},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.32521241903305054},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2871297001838684},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/mm.2025.3574357","is_oa":false,"landing_page_url":"https://doi.org/10.1109/mm.2025.3574357","pdf_url":null,"source":{"id":"https://openalex.org/S59697426","display_name":"IEEE Micro","issn_l":"0272-1732","issn":["0272-1732","1937-4143"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Micro","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":9,"referenced_works":["https://openalex.org/W2043099794","https://openalex.org/W2173213060","https://openalex.org/W3110410193","https://openalex.org/W4281764368","https://openalex.org/W4316660797","https://openalex.org/W4317033481","https://openalex.org/W4318541517","https://openalex.org/W4318767786","https://openalex.org/W4381326897"],"related_works":["https://openalex.org/W2026512611","https://openalex.org/W1985165680","https://openalex.org/W4245497162","https://openalex.org/W2353146130","https://openalex.org/W1990817968","https://openalex.org/W2150064838","https://openalex.org/W2135766592","https://openalex.org/W2185094550","https://openalex.org/W2088823210","https://openalex.org/W2398725611"],"abstract_inverted_index":{"The":[0],"advent":[1],"of":[2,11,24],"Compute":[3],"Express":[4],"Link":[5],"(CXL)":[6],"has":[7,20],"introduced":[8],"the":[9,28,78,84,111,125],"possibility":[10],"multi-host":[12],"shared":[13,25,74,88,113,119],"memory":[14,26,75,89,114,120],"architectures.":[15],"Despite":[16],"this":[17,59],"advancement,":[18],"there":[19],"been":[21],"limited":[22],"exploration":[23],"at":[27],"application":[29],"layer.":[30],"Traditional":[31],"distributed":[32],"systems":[33],"typically":[34],"partition":[35],"data":[36,50],"across":[37],"multiple":[38],"servers,":[39,97],"enabling":[40],"independent":[41],"processing.":[42],"However,":[43],"cross-partition":[44],"operations,":[45],"such":[46],"as":[47],"joins,":[48],"require":[49],"repartitioning,":[51],"leading":[52],"to":[53,76,95,134,139],"significant":[54],"communication":[55,101],"overhead.":[56,102],"To":[57,103],"address":[58],"challenge,":[60],"we":[61,107],"propose":[62],"Merge":[63],"Hash":[64],"Join":[65],"(MHJ),":[66],"a":[67,117],"novel":[68],"SQL":[69],"join":[70,141],"algorithm":[71],"that":[72,130],"leverages":[73],"eliminate":[77],"need":[79],"for":[80],"repartitioning.":[81],"By":[82],"storing":[83],"joining":[85],"table":[86],"in":[87],"and":[90,110],"making":[91],"it":[92],"directly":[93],"accessible":[94],"all":[96],"MHJ":[98,109,131],"significantly":[99],"reduces":[100],"validate":[104],"our":[105],"approach,":[106],"implemented":[108],"necessary":[112],"functionalities":[115],"on":[116],"CXL-based":[118],"prototype.":[121],"Extensive":[122],"evaluations":[123],"using":[124],"industry-standard":[126],"TPC-DS":[127],"benchmark":[128],"demonstrate":[129],"achieves":[132],"up":[133],"1.5\u00d7":[135],"performance":[136],"improvement":[137],"compared":[138],"conventional":[140],"algorithms.":[142]},"counts_by_year":[],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}