{"id":"https://openalex.org/W2803861595","doi":"https://doi.org/10.1007/s10619-018-7226-4","title":"Main-memory foreign key joins on advanced processors: design and re-evaluations for OLAP workloads","display_name":"Main-memory foreign key joins on advanced processors: design and re-evaluations for OLAP workloads","publication_year":2018,"publication_date":"2018-05-23","ids":{"openalex":"https://openalex.org/W2803861595","doi":"https://doi.org/10.1007/s10619-018-7226-4","mag":"2803861595"},"language":"en","primary_location":{"id":"doi:10.1007/s10619-018-7226-4","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s10619-018-7226-4","pdf_url":null,"source":{"id":"https://openalex.org/S35927321","display_name":"Distributed and Parallel Databases","issn_l":"0926-8782","issn":["0926-8782","1573-7578"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Distributed and Parallel Databases","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://hdl.handle.net/10138/322497","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5100644855","display_name":"Yansong Zhang","orcid":"https://orcid.org/0000-0003-2198-0987"},"institutions":[{"id":"https://openalex.org/I141301092","display_name":"China Meteorological Administration","ror":"https://ror.org/00bx3rb98","country_code":"CN","type":"government","lineage":["https://openalex.org/I141301092"]},{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Yansong Zhang","raw_affiliation_strings":["MOE Key Laboratory of DEKE, Renmin University of China, Beijing, China","National Satellite Meteorological Center of China, Beijing, China","School of Information, Renmin University of China, Beijing, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MOE Key Laboratory of DEKE, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"National Satellite Meteorological Center of China, Beijing, China","institution_ids":["https://openalex.org/I141301092"]},{"raw_affiliation_string":"School of Information, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100433777","display_name":"Yu Zhang","orcid":"https://orcid.org/0009-0005-8048-9612"},"institutions":[{"id":"https://openalex.org/I141301092","display_name":"China Meteorological Administration","ror":"https://ror.org/00bx3rb98","country_code":"CN","type":"government","lineage":["https://openalex.org/I141301092"]},{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yansong Zhang","raw_affiliation_strings":["MOE Key Laboratory of DEKE, Renmin University of China, Beijing, China","National Satellite Meteorological Center of China, Beijing, China","School of Information, Renmin University of China, Beijing, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MOE Key Laboratory of DEKE, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"National Satellite Meteorological Center of China, Beijing, China","institution_ids":["https://openalex.org/I141301092"]},{"raw_affiliation_string":"School of Information, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5143779541","display_name":"Yu Zhang","orcid":null},"institutions":[{"id":"https://openalex.org/I141301092","display_name":"China Meteorological Administration","ror":"https://ror.org/00bx3rb98","country_code":"CN","type":"government","lineage":["https://openalex.org/I141301092"]},{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]},{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yu Zhang","raw_affiliation_strings":["MOE Key Laboratory of DEKE, Renmin University of China, Beijing, China","National Satellite Meteorological Center of China, Beijing, China","School of Information, Renmin University of China, Beijing, China","School of Data Science and Engineering, East China Normal University, Shanghai, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MOE Key Laboratory of DEKE, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"National Satellite Meteorological Center of China, Beijing, China","institution_ids":["https://openalex.org/I141301092"]},{"raw_affiliation_string":"School of Information, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"School of Data Science and Engineering, East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100433777","display_name":"Yu Zhang","orcid":"https://orcid.org/0009-0005-8048-9612"},"institutions":[{"id":"https://openalex.org/I133731052","display_name":"University of Helsinki","ror":"https://ror.org/040af2s02","country_code":"FI","type":"education","lineage":["https://openalex.org/I133731052"]},{"id":"https://openalex.org/I141301092","display_name":"China Meteorological Administration","ror":"https://ror.org/00bx3rb98","country_code":"CN","type":"government","lineage":["https://openalex.org/I141301092"]},{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN","FI"],"is_corresponding":true,"raw_author_name":"Yu Zhang","raw_affiliation_strings":["MOE Key Laboratory of DEKE, Renmin University of China, Beijing, China","National Satellite Meteorological Center of China, Beijing, China","School of Information, Renmin University of China, Beijing, China","Department of Computer Science, University of Helsinki, Helsinki, Finland"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MOE Key Laboratory of DEKE, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"National Satellite Meteorological Center of China, Beijing, China","institution_ids":["https://openalex.org/I141301092"]},{"raw_affiliation_string":"School of Information, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"Department of Computer Science, University of Helsinki, Helsinki, Finland","institution_ids":["https://openalex.org/I133731052"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101789720","display_name":"Xuan Zhou","orcid":"https://orcid.org/0000-0003-2044-1818"},"institutions":[{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xuan Zhou","raw_affiliation_strings":["School of Data Science and Engineering, East China Normal University, Shanghai, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Data Science and Engineering, East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5018627557","display_name":"Jiaheng Lu","orcid":"https://orcid.org/0000-0003-2067-454X"},"institutions":[{"id":"https://openalex.org/I133731052","display_name":"University of Helsinki","ror":"https://ror.org/040af2s02","country_code":"FI","type":"education","lineage":["https://openalex.org/I133731052"]}],"countries":["FI"],"is_corresponding":false,"raw_author_name":"Jiaheng Lu","raw_affiliation_strings":["Department of Computer Science, University of Helsinki, Helsinki, Finland"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Helsinki, Helsinki, Finland","institution_ids":["https://openalex.org/I133731052"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5100433777","https://openalex.org/A5100644855"],"corresponding_institution_ids":["https://openalex.org/I133731052","https://openalex.org/I141301092","https://openalex.org/I78988378"],"apc_list":{"value":2990,"currency":"USD","value_usd":2990},"apc_paid":null,"fwci":0.4845,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.73703579,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"37","issue":"4","first_page":"469","last_page":"506"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9975000023841858,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9975000023841858,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.9948999881744385,"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/T11478","display_name":"Caching and Content Delivery","score":0.98580002784729,"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.8810420632362366},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.8100243806838989},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.7655134201049805},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.6344776153564453},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.4817776381969452},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.4768008887767792},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.4533904194831848},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.442484050989151},{"id":"https://openalex.org/keywords/hash-table","display_name":"Hash table","score":0.42229896783828735},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.41788333654403687},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.4154055118560791},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.36565089225769043},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.36438077688217163},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.36262375116348267},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.33054760098457336},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.33029627799987793},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.14276185631752014},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.08458301424980164}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8810420632362366},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.8100243806838989},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.7655134201049805},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.6344776153564453},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.4817776381969452},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.4768008887767792},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.4533904194831848},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.442484050989151},{"id":"https://openalex.org/C67388219","wikidata":"https://www.wikidata.org/wiki/Q207440","display_name":"Hash table","level":3,"score":0.42229896783828735},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.41788333654403687},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.4154055118560791},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.36565089225769043},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.36438077688217163},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.36262375116348267},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.33054760098457336},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.33029627799987793},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.14276185631752014},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.08458301424980164},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"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/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1007/s10619-018-7226-4","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s10619-018-7226-4","pdf_url":null,"source":{"id":"https://openalex.org/S35927321","display_name":"Distributed and Parallel Databases","issn_l":"0926-8782","issn":["0926-8782","1573-7578"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Distributed and Parallel Databases","raw_type":"journal-article"},{"id":"pmh:oai:helda.helsinki.fi:10138/322497","is_oa":true,"landing_page_url":"http://hdl.handle.net/10138/322497","pdf_url":null,"source":{"id":"https://openalex.org/S4210213322","display_name":"Ty\u00f6v\u00e4entutkimus Vuosikirja","issn_l":"0784-1272","issn":["0784-1272","1459-7780"],"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":"journal"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Article"}],"best_oa_location":{"id":"pmh:oai:helda.helsinki.fi:10138/322497","is_oa":true,"landing_page_url":"http://hdl.handle.net/10138/322497","pdf_url":null,"source":{"id":"https://openalex.org/S4210213322","display_name":"Ty\u00f6v\u00e4entutkimus Vuosikirja","issn_l":"0784-1272","issn":["0784-1272","1459-7780"],"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":"journal"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W1194153933","https://openalex.org/W1987238352","https://openalex.org/W2004772832","https://openalex.org/W2005112390","https://openalex.org/W2005684205","https://openalex.org/W2066860750","https://openalex.org/W2072541977","https://openalex.org/W2086977914","https://openalex.org/W2097880677","https://openalex.org/W2102639991","https://openalex.org/W2102729946","https://openalex.org/W2106911865","https://openalex.org/W2110975861","https://openalex.org/W2124851765","https://openalex.org/W2283004062","https://openalex.org/W2292693431","https://openalex.org/W2295615355","https://openalex.org/W2296150852","https://openalex.org/W2340076492","https://openalex.org/W2406955896","https://openalex.org/W2440477515","https://openalex.org/W2612094043","https://openalex.org/W2768191021"],"related_works":["https://openalex.org/W1525815534","https://openalex.org/W2391561131","https://openalex.org/W4380591969","https://openalex.org/W2148838171","https://openalex.org/W2572223517","https://openalex.org/W1846982616","https://openalex.org/W2069307110","https://openalex.org/W3046426830","https://openalex.org/W2152845022","https://openalex.org/W2947004196"],"abstract_inverted_index":null,"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":1}],"updated_date":"2026-07-31T08:31:51.225901","created_date":"2025-10-10T00:00:00"}