{"id":"https://openalex.org/W2074890970","doi":"https://doi.org/10.1145/190627.190633","title":"A new join algorithm","display_name":"A new join algorithm","alternate_titles":[],"publication_year":1994,"publication_date":"1994-12-01","ids":{"openalex":"https://openalex.org/W2074890970","doi":"https://doi.org/10.1145/190627.190633","mag":"2074890970"},"language":"en","primary_location":{"id":"doi:10.1145/190627.190633","doi":"https://doi.org/10.1145/190627.190633","is_oa":false,"landing_page_url":"https://doi.org/10.1145/190627.190633","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMOD Record","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2074890970"],"child_works_count":0,"type":"article","is_traditional":true,"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/A5077282915","display_name":"Dong Keun Shin","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4405259277","display_name":"Samsung Electronics (South Korea)","ror":"https://ror.org/020m7t761","country_code":"KR","type":"company","lineage":["https://openalex.org/I2250650973","https://openalex.org/I4405259277"]}],"countries":["KR"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Dong Keun Shin","raw_affiliation_strings":["Samsung Electronics Co., Ltd., Communication Systems R&D Center, SongPa P.O.Box 117, Seoul, Korea"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Samsung Electronics Co., Ltd., Communication Systems R&D Center, SongPa P.O.Box 117, Seoul, Korea","institution_ids":["https://openalex.org/I4405259277"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5076299718","display_name":"Arnold C. Meltzer","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I193531525","display_name":"George Washington University","ror":"https://ror.org/00y4zzh67","country_code":"US","type":"education","lineage":["https://openalex.org/I193531525"]}],"countries":["US"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Arnold Charles Meltzer","raw_affiliation_strings":["Department of Electrical Engineering and Computer Science, The School of Engineering and Applied Science, The George Washington University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Electrical Engineering and Computer Science, The School of Engineering and Applied Science, The George Washington University","institution_ids":["https://openalex.org/I193531525"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.5356,"has_fulltext":false,"cited_by_count":13,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.83767014,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":86,"max":94},"biblio":{"volume":"23","issue":"4","first_page":"13","last_page":"20"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9970999956130981,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9970999956130981,"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/T11269","display_name":"Algorithms and Data Compression","score":0.0010000000474974513,"subfield":{"id":"https://openalex.org/subfields/2614","display_name":"Theoretical Computer Science"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.000699999975040555,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/join-algorithms","display_name":"join algorithms","score":0.9200000166893005},{"id":"https://openalex.org/keywords/relational-database-operations","display_name":"relational database operations","score":0.5910000205039978},{"id":"https://openalex.org/keywords/divide-and-conquer","display_name":"divide-and-conquer","score":0.9070000052452087},{"id":"https://openalex.org/keywords/nested-loop-join","display_name":"nested loop join","score":0.9829999804496765},{"id":"https://openalex.org/keywords/sort-merge-join","display_name":"sort-merge join","score":0.996999979019165},{"id":"https://openalex.org/keywords/hash-join","display_name":"hash join","score":0.9409999847412109},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.42500001192092896}],"concepts":[{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.9178643226623535},{"id":"https://openalex.org/C203570394","wikidata":"https://www.wikidata.org/wiki/Q4060688","display_name":"Sort-merge join","level":3,"score":0.9162130355834961},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.8634562492370605},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.821422815322876},{"id":"https://openalex.org/C1306188","wikidata":"https://www.wikidata.org/wiki/Q4060687","display_name":"Nested loop join","level":2,"score":0.6428744196891785},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.6007081866264343},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.5962097644805908},{"id":"https://openalex.org/C197129107","wikidata":"https://www.wikidata.org/wiki/Q1921621","display_name":"Merge (version control)","level":2,"score":0.4843117296695709},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.4749365448951721},{"id":"https://openalex.org/C140086265","wikidata":"https://www.wikidata.org/wiki/Q11341754","display_name":"Merge algorithm","level":4,"score":0.47023719549179077},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.34951043128967285},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3297921121120453},{"id":"https://openalex.org/C108094655","wikidata":"https://www.wikidata.org/wiki/Q181593","display_name":"Sorting algorithm","level":3,"score":0.32511135935783386},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.23721081018447876},{"id":"https://openalex.org/C111696304","wikidata":"https://www.wikidata.org/wiki/Q2303697","display_name":"Sorting","level":2,"score":0.19399622082710266},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.1902572512626648},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.11661505699157715},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.09536343812942505},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/190627.190633","doi":"https://doi.org/10.1145/190627.190633","is_oa":false,"landing_page_url":"https://doi.org/10.1145/190627.190633","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMOD Record","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W172224151","https://openalex.org/W187405143","https://openalex.org/W583541193","https://openalex.org/W1499217199","https://openalex.org/W1588933040","https://openalex.org/W1964111545","https://openalex.org/W1970196737","https://openalex.org/W2012802704","https://openalex.org/W2031494708","https://openalex.org/W2044521103","https://openalex.org/W2051244613","https://openalex.org/W2068088848","https://openalex.org/W2078528123","https://openalex.org/W2124170481","https://openalex.org/W2132692154","https://openalex.org/W2133384222","https://openalex.org/W2163192219","https://openalex.org/W2165467455","https://openalex.org/W2169486917","https://openalex.org/W2185907055","https://openalex.org/W2488976896","https://openalex.org/W4231307671","https://openalex.org/W4238594802","https://openalex.org/W7010276953"],"related_works":["https://openalex.org/W2388708043","https://openalex.org/W2372167678","https://openalex.org/W2161956202","https://openalex.org/W1989002177","https://openalex.org/W2404915542","https://openalex.org/W2095891890","https://openalex.org/W2046429440","https://openalex.org/W7095720061","https://openalex.org/W2005272677"],"abstract_inverted_index":{"This":[0],"paper":[1],"introduces":[2],"a":[3,18],"new":[4,29,93],"efficient":[5],"join":[6,14,30,45,54,67,70,81,85,89,94],"algorithm":[7,31],"to":[8,62],"increase":[9],"the":[10,13,28,42,58,63,79,83,87,92],"speed":[11],"of":[12,41,49,66],"relational":[15],"operation.":[16],"Using":[17],"divide":[19],"and":[20,74,91],"conquer":[21],"strategy,":[22],"stack":[23],"oriented":[24],"filter":[25],"technique":[26],"in":[27,76],"filters":[32],"unwanted":[33],"tuples":[34,60],"as":[35,37],"early":[36],"possible":[38],"while":[39],"none":[40],"currently":[43],"existing":[44],"algorithms":[46,55,71],"takes":[47],"advantage":[48],"any":[50],"filtering":[51],"concept.":[52],"Other":[53],"may":[56],"carry":[57],"unnecessary":[59],"up":[61],"last":[64],"moment":[65],"attribute":[68],"comparisons.Four":[69],"are":[72],"described":[73],"discussed":[75],"this":[77],"paper:":[78],"nested-loop":[80],"algorithm,":[82,86,90],"sort-merge":[84],"hash":[88],"algorithm.":[95]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2074890970","counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
