{"id":"https://openalex.org/W4414908661","doi":"https://doi.org/10.1109/tbdata.2025.3618478","title":"ACJoin: A Low-Latency Multi-Table Join Order Selection Model With Minimum Cost Using Asynchronous Advantage Actor-Critic","display_name":"ACJoin: A Low-Latency Multi-Table Join Order Selection Model With Minimum Cost Using Asynchronous Advantage Actor-Critic","publication_year":2025,"publication_date":"2025-10-07","ids":{"openalex":"https://openalex.org/W4414908661","doi":"https://doi.org/10.1109/tbdata.2025.3618478"},"language":"en","primary_location":{"id":"doi:10.1109/tbdata.2025.3618478","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tbdata.2025.3618478","pdf_url":null,"source":{"id":"https://openalex.org/S2491400915","display_name":"IEEE Transactions on Big Data","issn_l":"2332-7790","issn":["2332-7790","2372-2096"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Big Data","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/A5074090518","display_name":"Shaojie Qiao","orcid":"https://orcid.org/0000-0002-4703-780X"},"institutions":[{"id":"https://openalex.org/I24201400","display_name":"Chengdu University of Information Technology","ror":"https://ror.org/01yxwrh59","country_code":"CN","type":"education","lineage":["https://openalex.org/I24201400"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Shaojie Qiao","raw_affiliation_strings":["School of Software Engineering, Chengdu University of Information Technology, Chengdu, China"],"raw_orcid":"https://orcid.org/0000-0002-4703-780X","affiliations":[{"raw_affiliation_string":"School of Software Engineering, Chengdu University of Information Technology, Chengdu, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035535168","display_name":"Chenxu Liu","orcid":"https://orcid.org/0000-0003-2616-3126"},"institutions":[{"id":"https://openalex.org/I24201400","display_name":"Chengdu University of Information Technology","ror":"https://ror.org/01yxwrh59","country_code":"CN","type":"education","lineage":["https://openalex.org/I24201400"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chenxu Liu","raw_affiliation_strings":["School of Software Engineering, Chengdu University of Information Technology, Chengdu, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Software Engineering, Chengdu University of Information Technology, Chengdu, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5092761884","display_name":"Nan Han","orcid":"https://orcid.org/0000-0003-3188-2811"},"institutions":[{"id":"https://openalex.org/I24201400","display_name":"Chengdu University of Information Technology","ror":"https://ror.org/01yxwrh59","country_code":"CN","type":"education","lineage":["https://openalex.org/I24201400"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Nan Han","raw_affiliation_strings":["School of Management, Chengdu University of Information Technology, Chengdu, China"],"raw_orcid":"https://orcid.org/0000-0003-3188-2811","affiliations":[{"raw_affiliation_string":"School of Management, Chengdu University of Information Technology, Chengdu, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047756951","display_name":"Kai Xu","orcid":"https://orcid.org/0000-0003-4509-455X"},"institutions":[{"id":"https://openalex.org/I24201400","display_name":"Chengdu University of Information Technology","ror":"https://ror.org/01yxwrh59","country_code":"CN","type":"education","lineage":["https://openalex.org/I24201400"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Kanglei Xu","raw_affiliation_strings":["School of Software Engineering, Chengdu University of Information Technology, Chengdu, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Software Engineering, Chengdu University of Information Technology, Chengdu, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042157969","display_name":"Ruiwei Gao","orcid":null},"institutions":[{"id":"https://openalex.org/I24201400","display_name":"Chengdu University of Information Technology","ror":"https://ror.org/01yxwrh59","country_code":"CN","type":"education","lineage":["https://openalex.org/I24201400"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ruiwei Gao","raw_affiliation_strings":["School of Software Engineering, Chengdu University of Information Technology, Chengdu, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Software Engineering, Chengdu University of Information Technology, Chengdu, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5080738591","display_name":"Xindong Wu","orcid":"https://orcid.org/0000-0003-2396-1704"},"institutions":[{"id":"https://openalex.org/I16365422","display_name":"Hefei University of Technology","ror":"https://ror.org/02czkny70","country_code":"CN","type":"education","lineage":["https://openalex.org/I16365422"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xindong Wu","raw_affiliation_strings":["Key Laboratory of Knowledge Engineering with Big Data, Hefei University of Technology, Hefei, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Key Laboratory of Knowledge Engineering with Big Data, Hefei University of Technology, Hefei, China","institution_ids":["https://openalex.org/I16365422"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.34755887,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"12","issue":"2","first_page":"330","last_page":"345"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10551","display_name":"Scheduling and Optimization Algorithms","score":0.8539000153541565,"subfield":{"id":"https://openalex.org/subfields/2209","display_name":"Industrial and Manufacturing Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10551","display_name":"Scheduling and Optimization Algorithms","score":0.8539000153541565,"subfield":{"id":"https://openalex.org/subfields/2209","display_name":"Industrial and Manufacturing Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"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.7878999710083008,"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/T10100","display_name":"Metaheuristic Optimization Algorithms Research","score":0.7843999862670898,"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/join","display_name":"Join (topology)","score":0.7979000210762024},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.6500999927520752},{"id":"https://openalex.org/keywords/reinforcement-learning","display_name":"Reinforcement learning","score":0.6055999994277954},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6039999723434448},{"id":"https://openalex.org/keywords/encoding","display_name":"Encoding (memory)","score":0.5576000213623047},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.5295000076293945},{"id":"https://openalex.org/keywords/sort-merge-join","display_name":"Sort-merge join","score":0.436599999666214},{"id":"https://openalex.org/keywords/asynchronous-communication","display_name":"Asynchronous communication","score":0.43369999527931213}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8650000095367432},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.7979000210762024},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6500999927520752},{"id":"https://openalex.org/C97541855","wikidata":"https://www.wikidata.org/wiki/Q830687","display_name":"Reinforcement learning","level":2,"score":0.6055999994277954},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6039999723434448},{"id":"https://openalex.org/C125411270","wikidata":"https://www.wikidata.org/wiki/Q18653","display_name":"Encoding (memory)","level":2,"score":0.5576000213623047},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.5295000076293945},{"id":"https://openalex.org/C203570394","wikidata":"https://www.wikidata.org/wiki/Q4060688","display_name":"Sort-merge join","level":3,"score":0.436599999666214},{"id":"https://openalex.org/C151319957","wikidata":"https://www.wikidata.org/wiki/Q752739","display_name":"Asynchronous communication","level":2,"score":0.43369999527931213},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.40149998664855957},{"id":"https://openalex.org/C182306322","wikidata":"https://www.wikidata.org/wiki/Q1779371","display_name":"Order (exchange)","level":2,"score":0.38909998536109924},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3621000051498413},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.35929998755455017},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.35600000619888306},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.35409998893737793},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.33469998836517334},{"id":"https://openalex.org/C2775973920","wikidata":"https://www.wikidata.org/wiki/Q3252726","display_name":"Selection algorithm","level":3,"score":0.3262999951839447},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.32519999146461487},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.3172999918460846},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.28220000863075256},{"id":"https://openalex.org/C106278948","wikidata":"https://www.wikidata.org/wiki/Q1198051","display_name":"R-tree","level":4,"score":0.2630999982357025},{"id":"https://openalex.org/C163797641","wikidata":"https://www.wikidata.org/wiki/Q2067937","display_name":"Tree structure","level":3,"score":0.26190000772476196},{"id":"https://openalex.org/C3019257732","wikidata":"https://www.wikidata.org/wiki/Q567759","display_name":"Map reduce","level":3,"score":0.2506999969482422}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tbdata.2025.3618478","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tbdata.2025.3618478","pdf_url":null,"source":{"id":"https://openalex.org/S2491400915","display_name":"IEEE Transactions on Big Data","issn_l":"2332-7790","issn":["2332-7790","2372-2096"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Big Data","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1616809407","display_name":null,"funder_award_id":"CBDIS202404","funder_id":"https://openalex.org/F4320321106","funder_display_name":"Ministry of Education of the People's Republic of China"},{"id":"https://openalex.org/G3498767076","display_name":null,"funder_award_id":"62572078","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G4997149588","display_name":null,"funder_award_id":"62272066","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320321106","display_name":"Ministry of Education of the People's Republic of China","ror":"https://ror.org/01mv9t934"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W2106856755","https://openalex.org/W2116436709","https://openalex.org/W2282866165","https://openalex.org/W2396309311","https://openalex.org/W2639544096","https://openalex.org/W2790625403","https://openalex.org/W2792645523","https://openalex.org/W2798325362","https://openalex.org/W2809208194","https://openalex.org/W2889503624","https://openalex.org/W2970148517","https://openalex.org/W2974499277","https://openalex.org/W3025775630","https://openalex.org/W3141797743","https://openalex.org/W3176153696","https://openalex.org/W3188362739","https://openalex.org/W4213436600","https://openalex.org/W4214864119","https://openalex.org/W4221142004","https://openalex.org/W4286544107","https://openalex.org/W4296437227","https://openalex.org/W4312339268","https://openalex.org/W4386470315"],"related_works":[],"abstract_inverted_index":{"Join":[0,92],"order":[1,42,45,93,134,191],"selection":[2,43,135,192],"is":[3],"one":[4],"of":[5,60,106],"the":[6,57,61,103,107,132,138,143,148,159,174,178,188],"most":[7],"challenging":[8],"problems":[9],"in":[10,18,23,44,200],"query":[11,21,49,145,167],"optimization":[12],"and":[13,38,53,136,165,177,194,202],"plays":[14],"an":[15],"essential":[16],"role":[17],"providing":[19],"high":[20,48],"performance":[22],"Big":[24],"Data":[25],"management.":[26],"Currently,":[27],"researchers":[28],"have":[29],"applied":[30],"deep":[31],"reinforcement":[32],"learning":[33,83],"methods,":[34],"for":[35,71,90],"example,":[36],"Rejoin":[37,52],"DQ,":[39],"to":[40,46,67,101,130,141],"join":[41,62,108,133,190],"obtain":[47],"performance.":[50,168],"However,":[51],"DQ":[54],"cannot":[55],"capture":[56,102],"structural":[58,104],"characteristic":[59],"tree,":[63],"which":[64],"may":[65],"lead":[66],"similar":[68],"encoding":[69,99],"structure":[70],"different":[72,121],"execution":[73,122],"plans.":[74,123],"To":[75],"tackle":[76],"these":[77],"challenges,":[78],"we":[79],"propose":[80],"a":[81,97],"new":[82,98],"optimizer":[84],"called":[85],"ACJoin":[86,95,118,156,186],"(asynchronous":[87],"advantage":[88],"Actor-Critic":[89],"multi-table":[91],"selection).":[94],"employs":[96],"method":[100],"characteristics":[105],"tree":[109],"through":[110],"integrating":[111],"GRU":[112],"(Gated":[113],"Recurrent":[114],"Unit).":[115],"In":[116],"particular,":[117],"can":[119,157],"distinguish":[120],"It":[124],"uses":[125],"A3C":[126],"(Asynchronous":[127],"Advantage":[128],"Actor-Critic)":[129],"guide":[131],"reduce":[137],"time":[139],"taken":[140],"find":[142,158],"best":[144],"plan":[146],"with":[147,152,163],"minimum":[149],"cost.":[150],"Compared":[151],"existing":[153],"search":[154],"strategies,":[155],"globally":[160],"optimal":[161],"solution":[162],"efficient":[164],"stable":[166],"Extensive":[169],"experiments":[170],"are":[171],"conducted":[172],"on":[173],"real":[175],"JOB":[176],"synthetic":[179],"TPC-H":[180],"datasets.":[181],"The":[182],"results":[183],"show":[184],"that":[185],"outperforms":[187],"state-of-the-art":[189],"methods":[193,199],"DRL":[195],"Deep":[196],"Reinforcement":[197],"Learning)-based":[198],"cost":[201],"latency.":[203]},"counts_by_year":[],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}