{"id":"https://openalex.org/W4408934030","doi":"https://doi.org/10.1007/s00778-025-00906-y","title":"Join optimization revisited: a novel DP algorithm for join&sort order selection","display_name":"Join optimization revisited: a novel DP algorithm for join&sort order selection","publication_year":2025,"publication_date":"2025-03-26","ids":{"openalex":"https://openalex.org/W4408934030","doi":"https://doi.org/10.1007/s00778-025-00906-y"},"language":"en","primary_location":{"id":"doi:10.1007/s00778-025-00906-y","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s00778-025-00906-y","pdf_url":null,"source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"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":"The VLDB Journal","raw_type":"journal-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/A5021251779","display_name":"Rui Li","orcid":"https://orcid.org/0000-0001-5167-2956"},"institutions":[{"id":"https://openalex.org/I177725633","display_name":"Chinese University of Hong Kong","ror":"https://ror.org/00t33hh48","country_code":"HK","type":"education","lineage":["https://openalex.org/I177725633"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Rui Li","raw_affiliation_strings":["The Chinese University of Hong Kong, Hong Kong, China"],"affiliations":[{"raw_affiliation_string":"The Chinese University of Hong Kong, Hong Kong, China","institution_ids":["https://openalex.org/I177725633"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111733992","display_name":"Zongyan He","orcid":null},"institutions":[{"id":"https://openalex.org/I177725633","display_name":"Chinese University of Hong Kong","ror":"https://ror.org/00t33hh48","country_code":"HK","type":"education","lineage":["https://openalex.org/I177725633"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Zongyan He","raw_affiliation_strings":["The Chinese University of Hong Kong, Hong Kong, China"],"affiliations":[{"raw_affiliation_string":"The Chinese University of Hong Kong, Hong Kong, China","institution_ids":["https://openalex.org/I177725633"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5075642293","display_name":"Jeffrey Xu Yu","orcid":"https://orcid.org/0000-0002-9738-827X"},"institutions":[{"id":"https://openalex.org/I177725633","display_name":"Chinese University of Hong Kong","ror":"https://ror.org/00t33hh48","country_code":"HK","type":"education","lineage":["https://openalex.org/I177725633"]}],"countries":["HK"],"is_corresponding":true,"raw_author_name":"Jeffrey Xu Yu","raw_affiliation_strings":["The Chinese University of Hong Kong, Hong Kong, China"],"affiliations":[{"raw_affiliation_string":"The Chinese University of Hong Kong, Hong Kong, China","institution_ids":["https://openalex.org/I177725633"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5075642293"],"corresponding_institution_ids":["https://openalex.org/I177725633"],"apc_list":{"value":2290,"currency":"EUR","value_usd":2890},"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.05665597,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"34","issue":"3","first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","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/T10317","display_name":"Advanced Database Systems and Queries","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/T11106","display_name":"Data Management and Algorithms","score":0.9991999864578247,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9969000220298767,"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","display_name":"Join (topology)","score":0.9139502644538879},{"id":"https://openalex.org/keywords/sort","display_name":"sort","score":0.6827298998832703},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6270073652267456},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.6203503012657166},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.5139645934104919},{"id":"https://openalex.org/keywords/order","display_name":"Order (exchange)","score":0.4526883363723755},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.44986745715141296},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.32760781049728394},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.32687026262283325},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.2861242890357971},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.17295372486114502},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1060037910938263},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.1047515869140625},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.10451307892799377},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.07556411623954773}],"concepts":[{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.9139502644538879},{"id":"https://openalex.org/C88548561","wikidata":"https://www.wikidata.org/wiki/Q347599","display_name":"sort","level":2,"score":0.6827298998832703},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6270073652267456},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6203503012657166},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.5139645934104919},{"id":"https://openalex.org/C182306322","wikidata":"https://www.wikidata.org/wiki/Q1779371","display_name":"Order (exchange)","level":2,"score":0.4526883363723755},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.44986745715141296},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.32760781049728394},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.32687026262283325},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2861242890357971},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.17295372486114502},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1060037910938263},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.1047515869140625},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.10451307892799377},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.07556411623954773},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/s00778-025-00906-y","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s00778-025-00906-y","pdf_url":null,"source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"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":"The VLDB Journal","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":42,"referenced_works":["https://openalex.org/W1505555748","https://openalex.org/W1523307303","https://openalex.org/W1550449994","https://openalex.org/W1556146035","https://openalex.org/W1569403765","https://openalex.org/W1589271613","https://openalex.org/W1968541019","https://openalex.org/W1991271936","https://openalex.org/W1992123139","https://openalex.org/W1998981580","https://openalex.org/W2014167660","https://openalex.org/W2015372451","https://openalex.org/W2026984353","https://openalex.org/W2030249095","https://openalex.org/W2030375115","https://openalex.org/W2035089573","https://openalex.org/W2035675039","https://openalex.org/W2051448621","https://openalex.org/W2059678295","https://openalex.org/W2062615214","https://openalex.org/W2066623874","https://openalex.org/W2098372784","https://openalex.org/W2104327580","https://openalex.org/W2116436709","https://openalex.org/W2147722789","https://openalex.org/W2154888102","https://openalex.org/W2158237121","https://openalex.org/W2159255345","https://openalex.org/W2164399715","https://openalex.org/W2167679350","https://openalex.org/W2293780340","https://openalex.org/W2293896416","https://openalex.org/W2396309311","https://openalex.org/W2440477515","https://openalex.org/W2755385361","https://openalex.org/W2798325362","https://openalex.org/W3031243969","https://openalex.org/W4206830372","https://openalex.org/W4232672600","https://openalex.org/W4246878928","https://openalex.org/W4248200652","https://openalex.org/W6630723731"],"related_works":["https://openalex.org/W2381211091","https://openalex.org/W2091359263","https://openalex.org/W4283362132","https://openalex.org/W2469706965","https://openalex.org/W1589496614","https://openalex.org/W4234452035","https://openalex.org/W2159860101","https://openalex.org/W3187487646","https://openalex.org/W4205996836","https://openalex.org/W1981952567"],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2026-02-09T05:59:30.833894","created_date":"2025-10-10T00:00:00"}