{"id":"https://openalex.org/W2089160619","doi":"https://doi.org/10.1145/2213836.2213971","title":"Reducing cache misses in hash join probing phase by pre-sorting strategy (abstract only)","display_name":"Reducing cache misses in hash join probing phase by pre-sorting strategy (abstract only)","publication_year":2012,"publication_date":"2012-05-20","ids":{"openalex":"https://openalex.org/W2089160619","doi":"https://doi.org/10.1145/2213836.2213971","mag":"2089160619"},"language":"en","primary_location":{"id":"doi:10.1145/2213836.2213971","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2213836.2213971","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},"type":"conference-paper","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/A5050816517","display_name":"Gihwan Oh","orcid":"https://orcid.org/0000-0002-3335-2841"},"institutions":[{"id":"https://openalex.org/I848706","display_name":"Sungkyunkwan University","ror":"https://ror.org/04q78tk20","country_code":"KR","type":"education","lineage":["https://openalex.org/I848706"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Gi-Hwan Oh","raw_affiliation_strings":["SungKyunKwan University, Suwon, Kyungkido, South Korea","SungKyunKwan University, Suwon, Kyungkido, South Korea#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SungKyunKwan University, Suwon, Kyungkido, South Korea","institution_ids":["https://openalex.org/I848706"]},{"raw_affiliation_string":"SungKyunKwan University, Suwon, Kyungkido, South Korea#TAB#","institution_ids":["https://openalex.org/I848706"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101819642","display_name":"Jae-Myung Kim","orcid":"https://orcid.org/0009-0005-3157-495X"},"institutions":[{"id":"https://openalex.org/I848706","display_name":"Sungkyunkwan University","ror":"https://ror.org/04q78tk20","country_code":"KR","type":"education","lineage":["https://openalex.org/I848706"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Jae-Myung Kim","raw_affiliation_strings":["SungKyunKwan University, Suwon, Kyungkido, South Korea","SungKyunKwan University, Suwon, Kyungkido, South Korea#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SungKyunKwan University, Suwon, Kyungkido, South Korea","institution_ids":["https://openalex.org/I848706"]},{"raw_affiliation_string":"SungKyunKwan University, Suwon, Kyungkido, South Korea#TAB#","institution_ids":["https://openalex.org/I848706"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001976671","display_name":"Woon-Hak Kang","orcid":null},"institutions":[{"id":"https://openalex.org/I848706","display_name":"Sungkyunkwan University","ror":"https://ror.org/04q78tk20","country_code":"KR","type":"education","lineage":["https://openalex.org/I848706"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Woon-Hak Kang","raw_affiliation_strings":["SungKyunKwan University, Suwon,Kyungkido, South Korea","SungKyunKwan University, Suwon, Kyungkido, South Korea#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SungKyunKwan University, Suwon,Kyungkido, South Korea","institution_ids":["https://openalex.org/I848706"]},{"raw_affiliation_string":"SungKyunKwan University, Suwon, Kyungkido, South Korea#TAB#","institution_ids":["https://openalex.org/I848706"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100360904","display_name":"Sang-Won Lee","orcid":"https://orcid.org/0000-0002-4206-3718"},"institutions":[{"id":"https://openalex.org/I848706","display_name":"Sungkyunkwan University","ror":"https://ror.org/04q78tk20","country_code":"KR","type":"education","lineage":["https://openalex.org/I848706"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Sang-Won Lee","raw_affiliation_strings":["SungKyunKwan University, Suwon, Kyungkido, South Africa","SungKyunKwan University, Suwon, Kyungkido, South Africa#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SungKyunKwan University, Suwon, Kyungkido, South Africa","institution_ids":["https://openalex.org/I848706"]},{"raw_affiliation_string":"SungKyunKwan University, Suwon, Kyungkido, South Africa#TAB#","institution_ids":["https://openalex.org/I848706"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I848706"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.20381541,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"864","last_page":"864"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11478","display_name":"Caching and Content Delivery","score":0.9983999729156494,"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.9983999729156494,"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.9944000244140625,"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.9921000003814697,"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/computer-science","display_name":"Computer science","score":0.8240852355957031},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.6955690979957581},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.652834951877594},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.6393234133720398},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.6294530034065247},{"id":"https://openalex.org/keywords/hash-table","display_name":"Hash table","score":0.5317517518997192},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.410685658454895},{"id":"https://openalex.org/keywords/double-hashing","display_name":"Double hashing","score":0.41052064299583435},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1109667420387268},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.0883939266204834}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8240852355957031},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.6955690979957581},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.652834951877594},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.6393234133720398},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.6294530034065247},{"id":"https://openalex.org/C67388219","wikidata":"https://www.wikidata.org/wiki/Q207440","display_name":"Hash table","level":3,"score":0.5317517518997192},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.410685658454895},{"id":"https://openalex.org/C138111711","wikidata":"https://www.wikidata.org/wiki/Q478351","display_name":"Double hashing","level":4,"score":0.41052064299583435},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1109667420387268},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0883939266204834},{"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.1145/2213836.2213971","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2213836.2213971","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":2,"referenced_works":["https://openalex.org/W2029131452","https://openalex.org/W2097880677"],"related_works":["https://openalex.org/W2381211091","https://openalex.org/W2091359263","https://openalex.org/W2069568684","https://openalex.org/W3019245231","https://openalex.org/W113683524","https://openalex.org/W4387251676","https://openalex.org/W4385261619","https://openalex.org/W93624718","https://openalex.org/W2159756639","https://openalex.org/W2292693431"],"abstract_inverted_index":{"Recently,":[0],"several":[1],"studies":[2],"on":[3],"multi-core":[4],"cache-aware":[5,187],"hash":[6,26,40,79,85,108,127,152,160,220],"join":[7,27,41,128,135,153,221],"have":[8],"been":[9],"carried":[10],"out":[11],"[Kim09VLDB,":[12],"Blanas11SIGMOD].":[13],"In":[14],"particular,":[15],"the":[16,30,35,53,77,82,97,105,123,144,156,159,171,175,186,192,209,242],"work":[17,31],"of":[18,32,42,56,84,87,96,110,148,151,162,182,197,211,251],"Blanas":[19,43],"has":[20,69,165],"shown":[21],"that":[22,95,104,155],"rather":[23],"simple":[24,36],"no-partitioning":[25],"can":[28],"outperform":[29],"Kim.":[33],"Meanwhile,":[34],"but":[37],"best":[38],"performing":[39],"still":[44],"experiences":[45],"severe":[46],"cache":[47,119,124,172],"misses":[48,125,173],"in":[49,58,126,231],"probing":[50,129,176,249],"phase.":[51,177],"Because":[52],"key":[54,72,146,193],"values":[55,147],"tuples":[57],"outer":[59,67,115,149],"relation":[60],"are":[61],"not":[62],"sorted":[63,202],"or":[64],"clustered,":[65],"each":[66,114,195,248,258],"record":[68,116,196],"different":[70,78],"hashed":[71,145],"value":[73],"and":[74,203,206,228,244,253,255,262],"thus":[75,169],"accesses":[76],"bucket.":[80],"Since":[81],"size":[83],"table":[86,89,112,150,164],"inner":[88,111,163],"is":[90,101,273],"usually":[91],"much":[92],"larger":[93],"than":[94,275],"CPU":[98],"cache,":[99],"it":[100,246],"highly":[102],"probable":[103],"reference":[106],"to":[107,158,200,279],"bucket":[109,161],"by":[113,237],"would":[117],"encounter":[118],"miss.":[120],"To":[121],"reduce":[122],"phase,":[130],"we":[131,184,217,240,256],"propose":[132],"a":[133,232],"new":[134],"algorithm,":[136],"Sorted":[137],"Probing":[138],"(in":[139],"short,":[140],"SP),":[141],"which":[142,190],"pre-sorts":[143],"so":[154],"access":[157],"strong":[166],"temporal":[167],"locality,":[168],"minimizing":[170],"during":[174],"As":[178],"an":[179],"optimization":[180],"technique":[181],"sorting,":[183],"used":[185,218],"AlphaSort":[188,243],"technique,":[189],"extracts":[191],"from":[194,223],"data":[198],"set":[199],"be":[201],"its":[204],"pointer,":[205],"then":[207],"sorts":[208],"pairs":[210],"(key,":[212],"rec_ptr).":[213],"For":[214,264],"performance":[215],"evaluation,":[216],"two":[219],"algorithms":[222],"Blanas'":[224],"work,":[225],"no":[226],"partitioning(NP)":[227],"independent":[229],"partitioning(IP)":[230],"standard":[233],"C++":[234],"program,":[235],"provided":[236],"Blanas.":[238],"Also,":[239],"implemented":[241],"added":[245],"before":[247],"phase":[250],"NP":[252],"IP,":[254],"call":[257],"algorithm":[259],"as":[260],"NP+SP":[261],"IP+SP.":[263],"syntactic":[265],"workload,":[266],"IP+SP":[267,272],"outperforms":[268],"all":[269],"other":[270,276],"algorithms:":[271],"faster":[274],"altorithms":[277],"up":[278],"30%.":[280]},"counts_by_year":[],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}