{"id":"https://openalex.org/W4411670550","doi":"https://doi.org/10.1007/s11704-025-41116-7","title":"Learning database optimization techniques: the state-of-the-art and prospects","display_name":"Learning database optimization techniques: the state-of-the-art and prospects","publication_year":2025,"publication_date":"2025-06-26","ids":{"openalex":"https://openalex.org/W4411670550","doi":"https://doi.org/10.1007/s11704-025-41116-7"},"language":"en","primary_location":{"id":"doi:10.1007/s11704-025-41116-7","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s11704-025-41116-7","pdf_url":"https://link.springer.com/content/pdf/10.1007/s11704-025-41116-7.pdf","source":{"id":"https://openalex.org/S4210231404","display_name":"Frontiers of Computer Science","issn_l":"2095-2228","issn":["2095-2228","2095-2236"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310311889","host_organization_name":"Higher Education Press","host_organization_lineage":["https://openalex.org/P4310311889"],"host_organization_lineage_names":["Higher Education Press"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers of Computer Science","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://link.springer.com/content/pdf/10.1007/s11704-025-41116-7.pdf","any_repository_has_fulltext":true},"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":"Shao-Jie Qiao","raw_affiliation_strings":["School of Software Engineering, Chengdu University of Information Technology, Chengdu, 610225, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Software Engineering, Chengdu University of Information Technology, Chengdu, 610225, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Han-Lin Fan","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":"Han-Lin Fan","raw_affiliation_strings":["Key Laboratory of Cyberspace Big Data Intelligent Security, Ministry of Education, Chongqing, 400065, China","School of Software Engineering, Chengdu University of Information Technology, Chengdu, 610225, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Key Laboratory of Cyberspace Big Data Intelligent Security, Ministry of Education, Chongqing, 400065, China","institution_ids":[]},{"raw_affiliation_string":"School of Software Engineering, Chengdu University of Information Technology, Chengdu, 610225, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103232473","display_name":"Nan Han","orcid":"https://orcid.org/0000-0002-6233-6322"},"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":true,"raw_author_name":"Nan Han","raw_affiliation_strings":["School of Management, Chengdu University of Information Technology, Chengdu, 610103, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Management, Chengdu University of Information Technology, Chengdu, 610103, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100716826","display_name":"Lan Du","orcid":"https://orcid.org/0000-0002-4503-0022"},"institutions":[{"id":"https://openalex.org/I56590836","display_name":"Monash University","ror":"https://ror.org/02bfwt286","country_code":"AU","type":"education","lineage":["https://openalex.org/I56590836"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Lan Du","raw_affiliation_strings":["Faculty of Information Technology, Monash University, Melbourne, 3800, Australia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Information Technology, Monash University, Melbourne, 3800, Australia","institution_ids":["https://openalex.org/I56590836"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084398329","display_name":"Yuhan Peng","orcid":"https://orcid.org/0000-0002-0120-668X"},"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":"Yu-Han Peng","raw_affiliation_strings":["School of Software Engineering, Chengdu University of Information Technology, Chengdu, 610225, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Software Engineering, Chengdu University of Information Technology, Chengdu, 610225, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Rong-Min Tang","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"]},{"id":"https://openalex.org/I4210142167","display_name":"DigitalSpace (United States)","ror":"https://ror.org/04h1th525","country_code":"US","type":"company","lineage":["https://openalex.org/I4210142167"]}],"countries":["CN","US"],"is_corresponding":false,"raw_author_name":"Rong-Min Tang","raw_affiliation_strings":["Key Laboratory of Cyberspace Security, Ministry of Education of China and Henan Key Laboratory of Cyberspace Situation Awareness, Zhengzhou, 450001, China","School of Software Engineering, Chengdu University of Information Technology, Chengdu, 610225, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Key Laboratory of Cyberspace Security, Ministry of Education of China and Henan Key Laboratory of Cyberspace Situation Awareness, Zhengzhou, 450001, China","institution_ids":["https://openalex.org/I4210142167"]},{"raw_affiliation_string":"School of Software Engineering, Chengdu University of Information Technology, Chengdu, 610225, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"last","author":{"id":null,"display_name":"Xiao Qin","orcid":null},"institutions":[{"id":"https://openalex.org/I4210151929","display_name":"Nanning Normal University","ror":"https://ror.org/04dx82x73","country_code":"CN","type":"education","lineage":["https://openalex.org/I4210151929"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Xiao Qin","raw_affiliation_strings":["Guangxi Key Lab of Human-machine Interaction and Intelligent Decision, Nanning Normal University, Nanning, 530100, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Guangxi Key Lab of Human-machine Interaction and Intelligent Decision, Nanning Normal University, Nanning, 530100, China","institution_ids":["https://openalex.org/I4210151929"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5103232473"],"corresponding_institution_ids":["https://openalex.org/I24201400","https://openalex.org/I4210151929"],"apc_list":{"value":2890,"currency":"USD","value_usd":2890},"apc_paid":{"value":2890,"currency":"USD","value_usd":2890},"fwci":2.5523,"has_fulltext":true,"cited_by_count":4,"citation_normalized_percentile":{"value":0.89814815,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":98,"max":99},"biblio":{"volume":"19","issue":"12","first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9962999820709229,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9962999820709229,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9932000041007996,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9930999875068665,"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/computer-science","display_name":"Computer science","score":0.8896589279174805},{"id":"https://openalex.org/keywords/state","display_name":"State (computer science)","score":0.4993016719818115},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.36351120471954346},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3230482041835785},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1888207197189331}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8896589279174805},{"id":"https://openalex.org/C48103436","wikidata":"https://www.wikidata.org/wiki/Q599031","display_name":"State (computer science)","level":2,"score":0.4993016719818115},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.36351120471954346},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3230482041835785},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1888207197189331}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1007/s11704-025-41116-7","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s11704-025-41116-7","pdf_url":"https://link.springer.com/content/pdf/10.1007/s11704-025-41116-7.pdf","source":{"id":"https://openalex.org/S4210231404","display_name":"Frontiers of Computer Science","issn_l":"2095-2228","issn":["2095-2228","2095-2236"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310311889","host_organization_name":"Higher Education Press","host_organization_lineage":["https://openalex.org/P4310311889"],"host_organization_lineage_names":["Higher Education Press"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers of Computer Science","raw_type":"journal-article"},{"id":"pmh:oai:monash.edu:publications/098645ed-f92e-454e-8dd1-ce1d97ce4d2f","is_oa":true,"landing_page_url":"https://research.monash.edu/en/publications/098645ed-f92e-454e-8dd1-ce1d97ce4d2f","pdf_url":null,"source":{"id":"https://openalex.org/S4306402625","display_name":"Monash University Research Portal (Monash University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I56590836","host_organization_name":"Monash University","host_organization_lineage":["https://openalex.org/I56590836"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Qiao, S-J, Fan, H-L, Han, N, Du, L, Peng, Y H, Tang, R M & Qin, X 2025, 'Learning database optimization techniques : the state-of-the-art and prospects', Frontiers of Computer Science, vol. 19, no. 12, 1912612. https://doi.org/10.1007/s11704-025-41116-7","raw_type":"info:eu-repo/semantics/review"}],"best_oa_location":{"id":"doi:10.1007/s11704-025-41116-7","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s11704-025-41116-7","pdf_url":"https://link.springer.com/content/pdf/10.1007/s11704-025-41116-7.pdf","source":{"id":"https://openalex.org/S4210231404","display_name":"Frontiers of Computer Science","issn_l":"2095-2228","issn":["2095-2228","2095-2236"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310311889","host_organization_name":"Higher Education Press","host_organization_lineage":["https://openalex.org/P4310311889"],"host_organization_lineage_names":["Higher Education Press"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers of Computer Science","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"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/F4320318398","display_name":"Ant Group","ror":null},{"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"},{"id":"https://openalex.org/F4320321135","display_name":"Chongqing University","ror":"https://ror.org/023rhb549"},{"id":"https://openalex.org/F4320322687","display_name":"Chongqing University of Posts and Telecommunications","ror":"https://ror.org/03dgaqz26"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4411670550.pdf","grobid_xml":"https://content.openalex.org/works/W4411670550.grobid-xml"},"referenced_works_count":109,"referenced_works":["https://openalex.org/W130646193","https://openalex.org/W188370263","https://openalex.org/W1501622334","https://openalex.org/W1508044906","https://openalex.org/W2066140355","https://openalex.org/W2075712468","https://openalex.org/W2131413649","https://openalex.org/W2144235399","https://openalex.org/W2163166770","https://openalex.org/W2247645225","https://openalex.org/W2396635388","https://openalex.org/W2509254371","https://openalex.org/W2526529994","https://openalex.org/W2602856279","https://openalex.org/W2740887992","https://openalex.org/W2755385361","https://openalex.org/W2890431379","https://openalex.org/W2890671347","https://openalex.org/W2906910993","https://openalex.org/W2911464154","https://openalex.org/W2911502905","https://openalex.org/W2911540814","https://openalex.org/W2912970030","https://openalex.org/W2913205451","https://openalex.org/W2915063781","https://openalex.org/W2945102109","https://openalex.org/W2955798121","https://openalex.org/W2970148517","https://openalex.org/W2970851599","https://openalex.org/W2975973447","https://openalex.org/W2998249308","https://openalex.org/W3013555795","https://openalex.org/W3025775630","https://openalex.org/W3032560301","https://openalex.org/W3037027022","https://openalex.org/W3099273181","https://openalex.org/W3100077023","https://openalex.org/W3105457604","https://openalex.org/W3105820654","https://openalex.org/W3111141572","https://openalex.org/W3119448165","https://openalex.org/W3129130011","https://openalex.org/W3160974509","https://openalex.org/W3167963175","https://openalex.org/W3173588310","https://openalex.org/W3173850788","https://openalex.org/W3175205084","https://openalex.org/W3176153696","https://openalex.org/W3176550827","https://openalex.org/W3187677057","https://openalex.org/W3192605935","https://openalex.org/W3196802051","https://openalex.org/W3196849431","https://openalex.org/W3197649928","https://openalex.org/W3199077625","https://openalex.org/W3203329898","https://openalex.org/W3205669526","https://openalex.org/W3214878531","https://openalex.org/W3217092890","https://openalex.org/W4206064074","https://openalex.org/W4206830372","https://openalex.org/W4210306204","https://openalex.org/W4210798430","https://openalex.org/W4214724203","https://openalex.org/W4220815684","https://openalex.org/W4224323400","https://openalex.org/W4226086155","https://openalex.org/W4226490385","https://openalex.org/W4233762723","https://openalex.org/W4238846128","https://openalex.org/W4239019441","https://openalex.org/W4240783461","https://openalex.org/W4249118033","https://openalex.org/W4283159195","https://openalex.org/W4283733706","https://openalex.org/W4285131076","https://openalex.org/W4285195848","https://openalex.org/W4285803058","https://openalex.org/W4287854385","https://openalex.org/W4289706945","https://openalex.org/W4290652751","https://openalex.org/W4290791576","https://openalex.org/W4316136118","https://openalex.org/W4319725120","https://openalex.org/W4327731261","https://openalex.org/W4353065055","https://openalex.org/W4365799947","https://openalex.org/W4372267129","https://openalex.org/W4380271786","https://openalex.org/W4380433194","https://openalex.org/W4385573058","https://openalex.org/W4385573280","https://openalex.org/W4385573339","https://openalex.org/W4385573402","https://openalex.org/W4385574340","https://openalex.org/W4385782585","https://openalex.org/W4385792271","https://openalex.org/W4386137790","https://openalex.org/W4386768683","https://openalex.org/W4389861172","https://openalex.org/W4389924473","https://openalex.org/W4391032878","https://openalex.org/W4392850219","https://openalex.org/W4393183913","https://openalex.org/W4400075081","https://openalex.org/W4400925671","https://openalex.org/W4400980763","https://openalex.org/W4407207335","https://openalex.org/W6603348255"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052"],"abstract_inverted_index":{"Abstract":[0],"Artificial":[1],"intelligence-enabled":[2],"database":[3,30],"technology,":[4],"known":[5],"as":[6],"AI4DB":[7],"(Artificial":[8],"Intelligence":[9],"for":[10,39],"Databases),":[11],"is":[12,61],"an":[13],"active":[14],"research":[15,122],"area":[16,123],"attracting":[17],"significant":[18],"attention":[19],"and":[20,56,65,107],"innovation.":[21],"This":[22],"survey":[23,115],"first":[24],"introduces":[25],"the":[26,78,92,105,129],"background":[27],"of":[28,83,95,110,133],"learning-based":[29,49,53],"techniques.":[31],"It":[32],"then":[33],"reviews":[34],"advanced":[35],"query":[36,85,100,112],"optimization":[37],"methods":[38,67],"learning":[40,70,99,111,134],"databases,":[41],"focusing":[42],"on":[43,69],"four":[44],"popular":[45],"directions:":[46],"cardinality/cost":[47],"estimation,":[48],"join":[50],"order":[51],"selection,":[52],"end-to-end":[54],"optimizers,":[55],"text-to-SQL":[57,118],"models.":[58],"Cardinality/cost":[59],"estimation":[60],"classified":[62],"into":[63],"supervised":[64],"unsupervised":[66],"based":[68],"models,":[71,119],"with":[72],"illustrative":[73],"examples":[74],"provided":[75],"to":[76,90],"explain":[77],"working":[79,93],"mechanisms.":[80],"Detailed":[81],"descriptions":[82],"various":[84],"optimizers":[86],"are":[87],"also":[88],"given":[89],"elucidate":[91],"mechanisms":[94],"each":[96],"component":[97],"in":[98],"optimizers.":[101,113],"Additionally,":[102],"we":[103,127],"discuss":[104],"challenges":[106],"development":[108,131],"opportunities":[109],"The":[114],"further":[116],"explores":[117],"a":[120],"new":[121],"within":[124],"AI4DB.":[125],"Finally,":[126],"consider":[128],"future":[130],"prospects":[132],"databases.":[135]},"counts_by_year":[{"year":2026,"cited_by_count":4}],"updated_date":"2026-07-25T09:21:30.201066","created_date":"2025-10-10T00:00:00"}