{"id":"https://openalex.org/W4389224840","doi":"https://doi.org/10.1145/3633512","title":"Parallel Acyclic Joins: Optimal Algorithms and Cyclicity Separation","display_name":"Parallel Acyclic Joins: Optimal Algorithms and Cyclicity Separation","publication_year":2023,"publication_date":"2023-12-01","ids":{"openalex":"https://openalex.org/W4389224840","doi":"https://doi.org/10.1145/3633512"},"language":"en","primary_location":{"id":"doi:10.1145/3633512","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3633512","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3633512","source":{"id":"https://openalex.org/S118992489","display_name":"Journal of the ACM","issn_l":"0004-5411","issn":["0004-5411","1557-735X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"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":"Journal of the ACM","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3633512","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5034417920","display_name":"Xiao Hu","orcid":null},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Xiao Hu","raw_affiliation_strings":["University of Waterloo, Waterloo, Canada"],"raw_orcid":"https://orcid.org/0000-0002-7890-665X","affiliations":[{"raw_affiliation_string":"University of Waterloo, Waterloo, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048609852","display_name":"Yufei Tao","orcid":"https://orcid.org/0000-0003-3883-5452"},"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":"Yufei Tao","raw_affiliation_strings":["Chinese University of Hong Kong, Hong Kong, China"],"raw_orcid":"https://orcid.org/0000-0003-3883-5452","affiliations":[{"raw_affiliation_string":"Chinese University of Hong Kong, Hong Kong, China","institution_ids":["https://openalex.org/I177725633"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5034417920"],"corresponding_institution_ids":["https://openalex.org/I151746483"],"apc_list":null,"apc_paid":null,"fwci":0.194,"has_fulltext":true,"cited_by_count":1,"citation_normalized_percentile":{"value":0.57995884,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":95},"biblio":{"volume":"71","issue":"1","first_page":"1","last_page":"44"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10720","display_name":"Complexity and Algorithms in Graphs","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/T10720","display_name":"Complexity and Algorithms in Graphs","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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.9998000264167786,"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"}},{"id":"https://openalex.org/T12288","display_name":"Optimization and Search Problems","score":0.9994999766349792,"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/joins","display_name":"Joins","score":0.8533646464347839},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.7410522699356079},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.6770030856132507},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.4951294958591461},{"id":"https://openalex.org/keywords/upper-and-lower-bounds","display_name":"Upper and lower bounds","score":0.4926066994667053},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.4830763638019562},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.4648496210575104},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.4552418887615204},{"id":"https://openalex.org/keywords/argument","display_name":"Argument (complex analysis)","score":0.43893152475357056},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.43062150478363037},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.4298282861709595},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.07838019728660583}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.8533646464347839},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.7410522699356079},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6770030856132507},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.4951294958591461},{"id":"https://openalex.org/C77553402","wikidata":"https://www.wikidata.org/wiki/Q13222579","display_name":"Upper and lower bounds","level":2,"score":0.4926066994667053},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.4830763638019562},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.4648496210575104},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.4552418887615204},{"id":"https://openalex.org/C98184364","wikidata":"https://www.wikidata.org/wiki/Q1780131","display_name":"Argument (complex analysis)","level":2,"score":0.43893152475357056},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.43062150478363037},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4298282861709595},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.07838019728660583},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3633512","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3633512","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3633512","source":{"id":"https://openalex.org/S118992489","display_name":"Journal of the ACM","issn_l":"0004-5411","issn":["0004-5411","1557-735X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"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":"Journal of the ACM","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1145/3633512","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3633512","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3633512","source":{"id":"https://openalex.org/S118992489","display_name":"Journal of the ACM","issn_l":"0004-5411","issn":["0004-5411","1557-735X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"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":"Journal of the ACM","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4389224840.pdf","grobid_xml":"https://content.openalex.org/works/W4389224840.grobid-xml"},"referenced_works_count":23,"referenced_works":["https://openalex.org/W1993892970","https://openalex.org/W2004485491","https://openalex.org/W2038142281","https://openalex.org/W2046167302","https://openalex.org/W2074935284","https://openalex.org/W2108023620","https://openalex.org/W2126624503","https://openalex.org/W2161956202","https://openalex.org/W2169998163","https://openalex.org/W2433238673","https://openalex.org/W2552956925","https://openalex.org/W2592257482","https://openalex.org/W2612777267","https://openalex.org/W2613113339","https://openalex.org/W2765269579","https://openalex.org/W2790840297","https://openalex.org/W2924926522","https://openalex.org/W2938070826","https://openalex.org/W2963066364","https://openalex.org/W3098289868","https://openalex.org/W3107626701","https://openalex.org/W3174468623","https://openalex.org/W3177245886"],"related_works":["https://openalex.org/W2393491644","https://openalex.org/W4206577045","https://openalex.org/W650102067","https://openalex.org/W3086237447","https://openalex.org/W2740404111","https://openalex.org/W1550806730","https://openalex.org/W1496672428","https://openalex.org/W2589740103","https://openalex.org/W2016456293","https://openalex.org/W1966967794"],"abstract_inverted_index":{"We":[0,79,185],"study":[1],"equi-join":[2],"computation":[3,8],"in":[4,42,59,83,99,148,156,163,189,217,234],"the":[5,43,54,60,66,75,81,84,87,93,104,134,143,170,190,240],"massively":[6],"parallel":[7],"(MPC)":[9],"model.":[10],"Currently,":[11],"a":[12,107,117,243],"main":[13],"open":[14],"question":[15,82,171,188],"under":[16],"this":[17,100,187],"topic":[18],"is":[19,22,53,65,74,138,166,179,209,227,232],"whether":[20,173],"it":[21],"possible":[23,181],"to":[24,125,239,267],"design":[25],"an":[26,264],"algorithm":[27,237],"that":[28,115,133,152,194,231],"can":[29,198],"process":[30],"any":[31,195],"join":[32,96,108,146,160,197],"with":[33,110,201],"load":[34,118,202],"O(N":[35,174,203],"polylog":[36,175],"N/p":[37,122,176],"1/\u03c1*":[38,177,206],")":[39,124,178],"\u2014":[40,50,247,253],"measured":[41],"number":[44,56,76],"of":[45,57,77,89,106,119,145,172,242,254],"words":[46],"communicated":[47],"per":[48],"machine":[49],"where":[51],"N":[52],"total":[55],"tuples":[58],"input":[61],"relations,":[62],"\u03c1":[63,111],"*":[64,112],"join\u2019s":[67],"fractional":[68],"edge":[69,251],"covering":[70],"number,":[71],"and":[72,224,262],"p":[73,205],"machines.":[78],"settle":[80],"negative":[85],"for":[86,141,182],"class":[88],"tuple-based":[90],"algorithms":[91,97],"(all":[92],"known":[94],"MPC":[95,149],"fall":[98],"class)":[101],"by":[102,192],"proving":[103],"existence":[105],"query":[109],"=":[113],"2":[114],"requires":[116],"\u03a9":[120],"(":[121],"1/3":[123],"evaluate.":[126],"Our":[127,236],"lower":[128],"bound":[129],"provides":[130],"solid":[131],"evidence":[132],"\u201cAGM":[135],"bound\u201d":[136],"alone":[137],"not":[139,154],"sufficient":[140],"characterizing":[142],"hardness":[144],"evaluation":[147],"(a":[150],"phenomenon":[151,230],"does":[153],"exist":[155],"RAM).":[157],"The":[158,220],"hard":[159],"instance":[161],"identified":[162],"our":[164,218],"argument":[165],"cyclic,":[167],"which":[168,208,257],"leaves":[169],"still":[180],"acyclic":[183,196,225,255],"joins.":[184],"answer":[186],"affirmative":[191],"showing":[193],"be":[199],"evaluated":[200],"/":[204],"),":[207],"asymptotically":[210],"optimal":[211],"(there":[212],"are":[213],"no":[214],"polylogarithmic":[215],"factors":[216],"bound).":[219],"separation":[221],"between":[222],"cyclic":[223],"joins":[226],"yet":[228],"another":[229],"absent":[233],"RAM.":[235],"owes":[238],"discovery":[241],"new":[244],"mathematical":[245],"structure":[246],"we":[248],"call":[249],"\u201ccanonical":[250],"cover\u201d":[252],"hypergraphs,":[256],"has":[258],"numerous":[259],"non-trivial":[260],"properties":[261],"makes":[263],"elegant":[265],"addition":[266],"database":[268],"theory.":[269]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}