{"id":"https://openalex.org/W1568945110","doi":"https://doi.org/10.1109/icde.2004.1319989","title":"Improving hash join performance through prefetching","display_name":"Improving hash join performance through prefetching","publication_year":2004,"publication_date":"2004-09-28","ids":{"openalex":"https://openalex.org/W1568945110","doi":"https://doi.org/10.1109/icde.2004.1319989","mag":"1568945110"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2004.1319989","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2004.1319989","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings. 20th International Conference on Data Engineering","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://infoscience.epfl.ch/record/133207","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5080814038","display_name":"S. Chen","orcid":"https://orcid.org/0009-0004-1976-5748"},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"S. Chen","raw_affiliation_strings":["Carnegie Mellon University, USA","Carnegie-Mellon University, Pittsburgh, Pa., USA#TAB#"],"affiliations":[{"raw_affiliation_string":"Carnegie Mellon University, USA","institution_ids":["https://openalex.org/I74973139"]},{"raw_affiliation_string":"Carnegie-Mellon University, Pittsburgh, Pa., USA#TAB#","institution_ids":["https://openalex.org/I74973139"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5031319715","display_name":"Anastassia Ailamaki","orcid":null},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"A. Ailamaki","raw_affiliation_strings":["Carnegie Mellon University, USA","Carnegie-Mellon University, Pittsburgh, Pa., USA#TAB#"],"affiliations":[{"raw_affiliation_string":"Carnegie Mellon University, USA","institution_ids":["https://openalex.org/I74973139"]},{"raw_affiliation_string":"Carnegie-Mellon University, Pittsburgh, Pa., USA#TAB#","institution_ids":["https://openalex.org/I74973139"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5014824446","display_name":"Phillip B. Gibbons","orcid":"https://orcid.org/0000-0001-6967-2735"},"institutions":[{"id":"https://openalex.org/I1343180700","display_name":"Intel (United States)","ror":"https://ror.org/01ek73717","country_code":"US","type":"company","lineage":["https://openalex.org/I1343180700"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"P.B. Gibbons","raw_affiliation_strings":["Intel Research Pittsburgh, USA","[Intel Research, Pittsburgh, USA]"],"affiliations":[{"raw_affiliation_string":"Intel Research Pittsburgh, USA","institution_ids":["https://openalex.org/I1343180700"]},{"raw_affiliation_string":"[Intel Research, Pittsburgh, USA]","institution_ids":["https://openalex.org/I1343180700"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5076667915","display_name":"Todd C. Mowry","orcid":"https://orcid.org/0000-0003-4076-5684"},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"T.C. Mowry","raw_affiliation_strings":["Carnegie Mellon University, USA","Carnegie Mellon Univ (USA)"],"affiliations":[{"raw_affiliation_string":"Carnegie Mellon University, USA","institution_ids":["https://openalex.org/I74973139"]},{"raw_affiliation_string":"Carnegie Mellon Univ (USA)","institution_ids":["https://openalex.org/I74973139"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5080814038"],"corresponding_institution_ids":["https://openalex.org/I74973139"],"apc_list":null,"apc_paid":null,"fwci":7.223,"has_fulltext":false,"cited_by_count":89,"citation_normalized_percentile":{"value":0.97133329,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"116","last_page":"127"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11478","display_name":"Caching and Content Delivery","score":0.9995999932289124,"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.9995999932289124,"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.9993000030517578,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9993000030517578,"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.8539468050003052},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.7638833522796631},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.7322548627853394},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.5797947645187378},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.5435876250267029},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.5236749053001404},{"id":"https://openalex.org/keywords/cache-algorithms","display_name":"Cache algorithms","score":0.47698289155960083},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.46961838006973267},{"id":"https://openalex.org/keywords/cpu-cache","display_name":"CPU cache","score":0.39675456285476685},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.08656159043312073}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8539468050003052},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.7638833522796631},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.7322548627853394},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.5797947645187378},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.5435876250267029},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.5236749053001404},{"id":"https://openalex.org/C38556500","wikidata":"https://www.wikidata.org/wiki/Q13404475","display_name":"Cache algorithms","level":4,"score":0.47698289155960083},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.46961838006973267},{"id":"https://openalex.org/C189783530","wikidata":"https://www.wikidata.org/wiki/Q352090","display_name":"CPU cache","level":3,"score":0.39675456285476685},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.08656159043312073},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":10,"locations":[{"id":"doi:10.1109/icde.2004.1319989","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2004.1319989","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings. 20th International Conference on Data Engineering","raw_type":"proceedings-article"},{"id":"pmh:oai:repository.cmu.edu:compsci-2141","is_oa":false,"landing_page_url":"http://repository.cmu.edu/compsci/1131","pdf_url":null,"source":{"id":"https://openalex.org/S4306400668","display_name":"Research Showcase @ Carnegie Mellon University (Carnegie Mellon University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I74973139","host_organization_name":"Carnegie Mellon University","host_organization_lineage":["https://openalex.org/I74973139"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Computer Science Department","raw_type":"text"},{"id":"pmh:oai:repository.cmu.edu:compsci-3210","is_oa":false,"landing_page_url":"http://repository.cmu.edu/compsci/2211","pdf_url":null,"source":{"id":"https://openalex.org/S4306400668","display_name":"Research Showcase @ Carnegie Mellon University (Carnegie Mellon University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I74973139","host_organization_name":"Carnegie Mellon University","host_organization_lineage":["https://openalex.org/I74973139"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Computer Science Department","raw_type":"text"},{"id":"pmh:doi:10.1184/r1/6606389","is_oa":false,"landing_page_url":null,"pdf_url":null,"source":{"id":"https://openalex.org/S4406922384","display_name":"Open MIND","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Journal contribution"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.576.8465","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.576.8465","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.intel-research.net/Publications/Pittsburgh/101220041310_270.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.6.2218","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.6.2218","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://reports-archive.adm.cs.cmu.edu/anon/2003/CMU-CS-03-157.ps","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.72.6792","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.72.6792","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.cmu.edu/~tcm/tcm_papers/hashjoin_icde04.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.72.9361","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.72.9361","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.pdl.cmu.edu/PDL-FTP/Database/icde04.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.73.627","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.73.627","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://reports-archive.adm.cs.cmu.edu/anon/2003/CMU-CS-03-157.pdf","raw_type":"text"},{"id":"pmh:oai:infoscience.epfl.ch:133207","is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/133207","pdf_url":null,"source":{"id":"https://openalex.org/S4306400487","display_name":"Infoscience (Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Text"}],"best_oa_location":{"id":"pmh:oai:infoscience.epfl.ch:133207","is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/133207","pdf_url":null,"source":{"id":"https://openalex.org/S4306400487","display_name":"Infoscience (Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Text"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":48,"referenced_works":["https://openalex.org/W182451592","https://openalex.org/W1497748148","https://openalex.org/W1519538706","https://openalex.org/W1540926161","https://openalex.org/W1568945110","https://openalex.org/W1570477871","https://openalex.org/W1602137482","https://openalex.org/W1645807896","https://openalex.org/W1994085050","https://openalex.org/W2007030756","https://openalex.org/W2014515453","https://openalex.org/W2029131452","https://openalex.org/W2038057969","https://openalex.org/W2059807497","https://openalex.org/W2077790567","https://openalex.org/W2086779607","https://openalex.org/W2095679548","https://openalex.org/W2096668111","https://openalex.org/W2099706037","https://openalex.org/W2099958604","https://openalex.org/W2100297149","https://openalex.org/W2105220449","https://openalex.org/W2116702178","https://openalex.org/W2140573832","https://openalex.org/W2148954445","https://openalex.org/W2153806645","https://openalex.org/W2155350341","https://openalex.org/W2155651153","https://openalex.org/W2158237121","https://openalex.org/W2160404300","https://openalex.org/W2169486917","https://openalex.org/W2171006257","https://openalex.org/W2914512445","https://openalex.org/W3155063289","https://openalex.org/W3160240113","https://openalex.org/W4205806386","https://openalex.org/W4234767864","https://openalex.org/W4239580808","https://openalex.org/W4239949242","https://openalex.org/W4243587504","https://openalex.org/W6629717275","https://openalex.org/W6632546856","https://openalex.org/W6633976619","https://openalex.org/W6634065580","https://openalex.org/W6636014027","https://openalex.org/W6637090028","https://openalex.org/W6682822640","https://openalex.org/W6683066674"],"related_works":["https://openalex.org/W4380591969","https://openalex.org/W2148838171","https://openalex.org/W2572223517","https://openalex.org/W2069307110","https://openalex.org/W3046426830","https://openalex.org/W2947004196","https://openalex.org/W2126624503","https://openalex.org/W2140894225","https://openalex.org/W3214526314","https://openalex.org/W2043224356"],"abstract_inverted_index":{"Hash":[0],"join":[1,15,83],"algorithms":[2],"suffer":[3],"from":[4],"extensive":[5],"CPU":[6,30,124],"cache":[7,31,42,104,125],"stalls.":[8],"We":[9,63],"show":[10],"that":[11,72],"the":[12,35,52,82,89,106,123],"standard":[13],"hash":[14,47],"algorithm/or":[16],"disk-oriented":[17],"databases":[18],"(i.e.":[19,103],"GRACE)":[20],"spends":[21],"over":[22,92],"73%":[23],"of":[24,37,61,122],"its":[25,41],"user":[26],"time":[27],"stalled":[28],"on":[29,113],"misses,":[32],"and":[33,58,69,85,94,116],"explores":[34],"use":[36,121],"prefetching":[38,45,68,96],"to":[39,46,126],"improve":[40],"performance.":[43],"Applying":[44],"joins":[48],"is":[49],"complicated":[50],"by":[51],"data":[53],"dependencies,":[54],"multiple":[55],"code":[56],"paths,":[57],"inherent":[59],"randomness":[60],"hashing.":[62],"present":[64],"two":[65],"techniques,":[66],"group":[67],"software-pipelined":[70],"prefetching,":[71],"overcome":[73],"these":[74],"complications.":[75],"These":[76],"schemes":[77,107],"achieve":[78],"2.0-2.9X":[79],"speedups":[80,87],"for":[81,88],"phase":[84,91],"1.4-2.6X":[86],"partition":[90],"GRACE":[93],"simple":[95],"approaches.":[97],"Compared":[98],"with":[99],"previous":[100],"cache-aware":[101],"approaches":[102],"partitioning),":[105],"are":[108],"at":[109],"least":[110],"50%":[111],"faster":[112],"large":[114],"relations":[115],"do":[117],"not":[118],"require":[119],"exclusive":[120],"be":[127],"effective.":[128]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":6},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":5}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}