{"id":"https://openalex.org/W2081128697","doi":"https://doi.org/10.1145/1509084.1509091","title":"Exploiting multithreaded architectures to improve the hash join operation","display_name":"Exploiting multithreaded architectures to improve the hash join operation","publication_year":2008,"publication_date":"2008-10-26","ids":{"openalex":"https://openalex.org/W2081128697","doi":"https://doi.org/10.1145/1509084.1509091","mag":"2081128697"},"language":"en","primary_location":{"id":"doi:10.1145/1509084.1509091","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1509084.1509091","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 9th workshop on MEmory performance: DEaling with Applications, systems and architecture","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/A5043399003","display_name":"Layali Rashid","orcid":null},"institutions":[{"id":"https://openalex.org/I168635309","display_name":"University of Calgary","ror":"https://ror.org/03yjb2x39","country_code":"CA","type":"education","lineage":["https://openalex.org/I168635309"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Layali Rashid","raw_affiliation_strings":["University of Calgary"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Calgary","institution_ids":["https://openalex.org/I168635309"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007699622","display_name":"Wessam Hassanein","orcid":null},"institutions":[{"id":"https://openalex.org/I168635309","display_name":"University of Calgary","ror":"https://ror.org/03yjb2x39","country_code":"CA","type":"education","lineage":["https://openalex.org/I168635309"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Wessam M. Hassanein","raw_affiliation_strings":["University of Calgary"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Calgary","institution_ids":["https://openalex.org/I168635309"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5109911563","display_name":"Moustafa A. Hammad","orcid":null},"institutions":[{"id":"https://openalex.org/I168635309","display_name":"University of Calgary","ror":"https://ror.org/03yjb2x39","country_code":"CA","type":"education","lineage":["https://openalex.org/I168635309"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Moustafa A. Hammad","raw_affiliation_strings":["University of Calgary"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Calgary","institution_ids":["https://openalex.org/I168635309"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.7628,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.7656129,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"46","last_page":"53"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9991999864578247,"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.9991999864578247,"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.9988999962806702,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9983999729156494,"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.888157844543457},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.823432445526123},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.6158175468444824},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.6033912897109985},{"id":"https://openalex.org/keywords/xeon","display_name":"Xeon","score":0.4574874937534332},{"id":"https://openalex.org/keywords/pentium","display_name":"Pentium","score":0.43098676204681396},{"id":"https://openalex.org/keywords/shared-memory","display_name":"Shared memory","score":0.42254745960235596},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.3436585068702698},{"id":"https://openalex.org/keywords/computer-architecture","display_name":"Computer architecture","score":0.3299238681793213},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.12033870816230774}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.888157844543457},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.823432445526123},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.6158175468444824},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.6033912897109985},{"id":"https://openalex.org/C145108525","wikidata":"https://www.wikidata.org/wiki/Q656154","display_name":"Xeon","level":2,"score":0.4574874937534332},{"id":"https://openalex.org/C46268123","wikidata":"https://www.wikidata.org/wiki/Q214314","display_name":"Pentium","level":2,"score":0.43098676204681396},{"id":"https://openalex.org/C133875982","wikidata":"https://www.wikidata.org/wiki/Q764810","display_name":"Shared memory","level":2,"score":0.42254745960235596},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3436585068702698},{"id":"https://openalex.org/C118524514","wikidata":"https://www.wikidata.org/wiki/Q173212","display_name":"Computer architecture","level":1,"score":0.3299238681793213},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12033870816230774}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1509084.1509091","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1509084.1509091","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 9th workshop on MEmory performance: DEaling with Applications, systems and architecture","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","score":0.4099999964237213,"id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":27,"referenced_works":["https://openalex.org/W50914958","https://openalex.org/W204077658","https://openalex.org/W1517128672","https://openalex.org/W1558805549","https://openalex.org/W1560473542","https://openalex.org/W1568945110","https://openalex.org/W1602137482","https://openalex.org/W1645807896","https://openalex.org/W1888316275","https://openalex.org/W1971851724","https://openalex.org/W1984730786","https://openalex.org/W1992640817","https://openalex.org/W2002209075","https://openalex.org/W2007030756","https://openalex.org/W2010221388","https://openalex.org/W2016622853","https://openalex.org/W2077864660","https://openalex.org/W2082701182","https://openalex.org/W2116702178","https://openalex.org/W2120230074","https://openalex.org/W2124878400","https://openalex.org/W2132998471","https://openalex.org/W2155651153","https://openalex.org/W2165467455","https://openalex.org/W2185907055","https://openalex.org/W3142418650","https://openalex.org/W4285707308"],"related_works":["https://openalex.org/W1924331995","https://openalex.org/W2247986554","https://openalex.org/W2526922965","https://openalex.org/W1515350030","https://openalex.org/W15478189","https://openalex.org/W2140912892","https://openalex.org/W2170796499","https://openalex.org/W1988408216","https://openalex.org/W2043143850","https://openalex.org/W4252163020"],"abstract_inverted_index":{"As":[0],"database":[1,19,56,77],"management":[2],"systems":[3],"gain":[4],"importance":[5],"in":[6,27,84],"our":[7],"everyday":[8],"life,":[9],"it":[10],"is":[11,140],"essential":[12],"to":[13,54,111,121,131],"have":[14,37,51],"efficient":[15],"implementations":[16],"of":[17,43],"important":[18],"operations":[20],"such":[21],"as":[22],"the":[23,44,81,93,98,114,124],"hash":[24,70,133],"join.":[25,134],"Improvements":[26],"processor":[28],"architectures":[29,33],"including":[30],"simultaneous":[31],"multithreaded":[32,46],"and":[34,96,119],"Chip":[35],"Multiprocessors":[36],"opened":[38],"opportunities":[39],"for":[40,74,113],"taking":[41],"advantage":[42],"new":[45,68],"hardware.":[47],"Recently,":[48],"several":[49],"efforts":[50],"been":[52],"done":[53],"enhance":[55],"performance":[57,108],"through":[58],"architecture-aware":[59,69],"data":[60,82],"management.":[61],"In":[62],"this":[63],"paper,":[64],"we":[65],"present":[66],"a":[67,107],"join":[71],"(AA_HJ)":[72],"algorithm":[73],"main":[75],"memory":[76],"systems,":[78],"where":[79],"all":[80],"resides":[83],"memory.":[85],"AA_HJ":[86],"relies":[87],"on":[88,123],"sharing":[89],"critical":[90],"structures":[91],"at":[92],"cache":[94],"level,":[95],"distributing":[97],"load":[99,137],"evenly":[100],"between":[101],"threads.":[102],"Our":[103],"timing":[104],"results":[105],"show":[106],"improvement":[109],"up":[110,120,143],"2.9x":[112],"Intel\u00ae":[115,125],"Pentium\u00ae":[116],"4":[117],"HT":[118],"4.6x":[122],"Quad":[126],"Xeon\u00ae":[127],"Dual-Core":[128],"machine,":[129],"compared":[130],"single-threaded":[132],"The":[135],"L2":[136],"miss":[138],"rate":[139],"reduced":[141],"by":[142],"82%.":[144]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}