{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,24]],"date-time":"2026-07-24T18:30:14Z","timestamp":1784917814123,"version":"3.55.0"},"reference-count":128,"publisher":"Springer Science and Business Media LLC","issue":"12","license":[{"start":{"date-parts":[[2025,6,26]],"date-time":"2025-06-26T00:00:00Z","timestamp":1750896000000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"},{"start":{"date-parts":[[2025,6,26]],"date-time":"2025-06-26T00:00:00Z","timestamp":1750896000000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Front. Comput. Sci."],"published-print":{"date-parts":[[2025,12]]},"abstract":"<jats:title>Abstract<\/jats:title>\n          <jats:p>Artificial intelligence-enabled database technology, known as AI4DB (Artificial Intelligence for Databases), is an active research area attracting significant attention and innovation. This survey first introduces the background of learning-based database techniques. It then reviews advanced query optimization methods for learning databases, focusing on four popular directions: cardinality\/cost estimation, learning-based join order selection, learning-based end-to-end optimizers, and text-to-SQL models. Cardinality\/cost estimation is classified into supervised and unsupervised methods based on learning models, with illustrative examples provided to explain the working mechanisms. Detailed descriptions of various query optimizers are also given to elucidate the working mechanisms of each component in learning query optimizers. Additionally, we discuss the challenges and development opportunities of learning query optimizers. The survey further explores text-to-SQL models, a new research area within AI4DB. Finally, we consider the future development prospects of learning databases.<\/jats:p>","DOI":"10.1007\/s11704-025-41116-7","type":"journal-article","created":{"date-parts":[[2025,6,26]],"date-time":"2025-06-26T09:51:00Z","timestamp":1750931460000},"update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":4,"title":["Learning database optimization techniques: the state-of-the-art and prospects"],"prefix":"10.1007","volume":"19","author":[{"given":"Shao-Jie","family":"Qiao","sequence":"first","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Han-Lin","family":"Fan","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Nan","family":"Han","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Lan","family":"Du","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Yu-Han","family":"Peng","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Rong-Min","family":"Tang","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Xiao","family":"Qin","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"297","published-online":{"date-parts":[[2025,6,26]]},"reference":[{"issue":"3","key":"41116_CR1","doi-asserted-by":"publisher","first-page":"1096","DOI":"10.1109\/TKDE.2020.2994641","volume":"34","author":"X Zhou","year":"2022","unstructured":"Zhou X, Chai C, Li G, Sun J. Database meets artificial intelligence: a survey. IEEE Transactions on Knowledge and Data Engineering, 2022, 34(3): 1096\u20131116","journal-title":"IEEE Transactions on Knowledge and Data Engineering"},{"key":"41116_CR2","first-page":"3901","volume-title":"Proceedings of the 39th IEEE International Conference on Data Engineering","author":"X Zhou","year":"2023","unstructured":"Zhou X, Chai C, Li G, Sun J. Database meets artificial intelligence: a survey (extended abstract). In: Proceedings of the 39th IEEE International Conference on Data Engineering. 2023, 3901\u20133902"},{"issue":"1","key":"41116_CR3","doi-asserted-by":"publisher","first-page":"181803","DOI":"10.1007\/s11704-022-2401-1","volume":"18","author":"X Li","year":"2024","unstructured":"Li X, Zhu Y, Xu R, Wang J, Zhang Y. Indexing dynamic encrypted database in cloud for efficient secure fc-nearest neighbor query. Frontiers of Computer Science, 2024, 18(1): 181803","journal-title":"Frontiers of Computer Science"},{"issue":"12","key":"41116_CR4","doi-asserted-by":"publisher","first-page":"3190","DOI":"10.14778\/3476311.3476405","volume":"14","author":"G Li","year":"2021","unstructured":"Li G, Zhou X, Cao L. Machine learning for databases. Proceedings of the VLDB Endowment, 2021, 14(12): 3190\u20133193","journal-title":"Proceedings of the VLDB Endowment"},{"key":"41116_CR5","first-page":"273","volume-title":"Proceedings of the 26th International Conference on Extending Database Technology (EDBT 2023)","author":"M M\u00fcller","year":"2023","unstructured":"M\u00fcller M, Woltmann L, Lehner W. Enhanced featurization of queries with mixed combinations of predicates for ML-based cardinality estimation. In: Proceedings of the 26th International Conference on Extending Database Technology (EDBT 2023). 2023, 273\u2013284"},{"key":"41116_CR6","doi-asserted-by":"publisher","first-page":"32954","DOI":"10.1109\/ACCESS.2022.3161574","volume":"10","author":"Y Wu","year":"2022","unstructured":"Wu Y, Hu Z, Wang Y, Min F. Rare potential poor household identification with a focus embedded logistic regression. IEEE Access, 2022, 10: 32954\u201332972","journal-title":"IEEE Access"},{"issue":"1","key":"41116_CR7","doi-asserted-by":"publisher","first-page":"207","DOI":"10.32604\/csse.2022.018301","volume":"40","author":"Z Yu","year":"2022","unstructured":"Yu Z, Zhang C, Xiong N, Chen F. A new random forest applied to heavy metal risk assessment. Computer Systems Science and Engineering, 2022, 40(1): 207\u2013221","journal-title":"Computer Systems Science and Engineering"},{"key":"41116_CR8","first-page":"1","volume-title":"Proceedings of 2022 International Joint Conference on Neural Networks","author":"W Zhou","year":"2022","unstructured":"Zhou W, Zhan S, Dai B, Guo L. SOAR: A learned join order selector with graph attention mechanism. In: Proceedings of 2022 International Joint Conference on Neural Networks. 2022, 1\u20138"},{"issue":"5","key":"41116_CR9","doi-asserted-by":"publisher","first-page":"1084","DOI":"10.1109\/TPDS.2021.3101155","volume":"33","author":"J Jiang","year":"2022","unstructured":"Jiang J, Wen Z, Wang Z, He B, Chen J. Parallel and distributed structured SVM training. IEEE Transactions on Parallel and Distributed Systems, 2022, 33(5): 1084\u20131096","journal-title":"IEEE Transactions on Parallel and Distributed Systems"},{"issue":"1","key":"41116_CR10","doi-asserted-by":"publisher","first-page":"389","DOI":"10.32604\/csse.2022.020256","volume":"41","author":"A Arunkumar","year":"2022","unstructured":"Arunkumar A, Surendran D. Autism spectrum disorder diagnosis using ensemble ML and max voting techniques. Computer Systems Science and Engineering, 2022, 41(1): 389\u2013404","journal-title":"Computer Systems Science and Engineering"},{"issue":"4","key":"41116_CR11","doi-asserted-by":"publisher","first-page":"184504","DOI":"10.1007\/s11704-023-1346-3","volume":"18","author":"Y Cui","year":"2024","unstructured":"Cui Y, Zhang D, Zhang J, Zhang T, Cao L, Chen L. Multi-user reinforcement learning based task migration in mobile edge computing. Frontiers of Computer Science, 2024, 18(4): 184504","journal-title":"Frontiers of Computer Science"},{"key":"41116_CR12","first-page":"885","volume-title":"Proceedings of the 38th IEEE International Conference on Data Engineering","author":"Y Li","year":"2022","unstructured":"Li Y, Wang L, Wang S, Sun Y, Peng Z. A resource-aware deep cost model for big data query processing. In: Proceedings of the 38th IEEE International Conference on Data Engineering. 2022, 885\u2013897"},{"issue":"3","key":"41116_CR13","doi-asserted-by":"publisher","first-page":"254","DOI":"10.2174\/1574893616666211130125206","volume":"17","author":"J Wu","year":"2022","unstructured":"Wu J, Qu L, Yang G, Han N. Diabetes induced factors prediction based on various improved machine learning methods. Current Bioinformatics, 2022, 17(3): 254\u2013262","journal-title":"Current Bioinformatics"},{"key":"41116_CR14","first-page":"546","volume-title":"Proceedings of the 22nd International Conference on Extending Database Technology","author":"E Gallinucci","year":"2019","unstructured":"Gallinucci E, Golfarelli M. SparkTune: Tuning spark SQL through query cost modeling. In: Proceedings of the 22nd International Conference on Extending Database Technology. 2019, 546\u2013549"},{"key":"41116_CR15","first-page":"4","volume-title":"Proceedings of the 2nd Workshop on Data Management for End-To-End Machine Learning","author":"J Ortiz","year":"2018","unstructured":"Ortiz J, Balazinska M, Gehrke J, Keerthi S S. Learning state representations for query optimization with deep reinforcement learning. In: Proceedings of the 2nd Workshop on Data Management for End-To-End Machine Learning. 2018, 4"},{"issue":"12","key":"41116_CR16","doi-asserted-by":"publisher","first-page":"2118","DOI":"10.14778\/3352063.3352129","volume":"12","author":"G Li","year":"2019","unstructured":"Li G, Zhou X, Li S, Gao B. QTune: A query-aware database tuning system with deep reinforcement learning. Proceedings of the VLDB Endowment, 2019, 12(12): 2118\u20132130","journal-title":"Proceedings of the VLDB Endowment"},{"issue":"12","key":"41116_CR17","doi-asserted-by":"publisher","first-page":"3028","DOI":"10.14778\/3476311.3476380","volume":"14","author":"G Li","year":"2021","unstructured":"Li G, Zhou X, Sun J, Yu X, Han Y, Jin L, Li W, Wang T, Li S. openGauss: An autonomous database system. Proceedings of the VLDB Endowment, 2021, 14(12): 3028\u20133041","journal-title":"Proceedings of the VLDB Endowment"},{"key":"41116_CR18","first-page":"13","volume-title":"Proceedings of the 35th IEEE International Conference on Data Engineering","author":"J Chen","year":"2019","unstructured":"Chen J, Chen Y, Chen Z, Ghazal A, Li G, Li S, Ou W, Sun Y, Zhang M, Zhou M. Data management at Huawei: Recent accomplishments and future challenges. In: Proceedings of the 35th IEEE International Conference on Data Engineering. 2019, 13\u201324"},{"issue":"9","key":"41116_CR19","doi-asserted-by":"publisher","first-page":"1416","DOI":"10.14778\/3397230.3397238","volume":"13","author":"X Zhou","year":"2020","unstructured":"Zhou X, Sun J, Li G, Feng J. Query performance prediction for concurrent queries using graph embedding. Proceedings of the VLDB Endowment, 2020, 13(9): 1416\u20131428","journal-title":"Proceedings of the VLDB Endowment"},{"key":"41116_CR20","doi-asserted-by":"publisher","first-page":"1871","DOI":"10.1145\/3485447.3511991","volume-title":"Proceedings of the ACM Web Conference 2022","author":"J Zhang","year":"2022","unstructured":"Zhang J, Wu S, Zhao J, Xie Z, Li F, Gao Y, Chen G. A sampling-based learning framework for big databases. In: Proceedings of the ACM Web Conference 2022. 2022, 1871\u20131881"},{"issue":"1","key":"41116_CR21","doi-asserted-by":"publisher","first-page":"86","DOI":"10.1007\/s41019-020-00149-7","volume":"6","author":"H Lan","year":"2021","unstructured":"Lan H, Bao Z, Peng Y. A survey on advancing the DBMS query optimizer: Cardinality estimation, cost model, and plan enumeration. Data Science and Engineering, 2021, 6(1): 86\u2013101","journal-title":"Data Science and Engineering"},{"issue":"4","key":"41116_CR22","doi-asserted-by":"publisher","first-page":"762","DOI":"10.1007\/s11390-021-1351-7","volume":"36","author":"S J Qiao","year":"2021","unstructured":"Qiao S J, Yang G P, Han N, Chen H, Huang F L, Yue K, Yi Y G, Yuan C A. Cardinality estimator: Processing SQL with a vertical scanning convolutional neural network. Journal of Computer Science and Technology, 2021, 36(4): 762\u2013777","journal-title":"Journal of Computer Science and Technology"},{"key":"41116_CR23","first-page":"1297","volume-title":"Proceedings of the 36th IEEE International Conference on Data Engineering","author":"X Yu","year":"2020","unstructured":"Yu X, Li G, Chai C, Tang N. Reinforcement learning with tree-LSTM for join order selection. In: Proceedings of the 36th IEEE International Conference on Data Engineering. 2020, 1297\u20131308"},{"issue":"11","key":"41116_CR24","doi-asserted-by":"publisher","first-page":"1705","DOI":"10.14778\/3342263.3342644","volume":"12","author":"R C Marcus","year":"2019","unstructured":"Marcus R C, Negi P, Mao H, Zhang C, Alizadeh M, Kraska T, Papaemmanouil O, Tatbul N. Neo: A learned query optimizer. Proceedings of the VLDB Endowment, 2019, 12(11): 1705\u20131718","journal-title":"Proceedings of the VLDB Endowment"},{"issue":"3","key":"41116_CR25","doi-asserted-by":"publisher","first-page":"210","DOI":"10.14778\/3291264.3291267","volume":"12","author":"C Wu","year":"2018","unstructured":"Wu C, Jindal A, Amizadeh S, Patel H, Le W, Qiao S, Rao S. Towards a learning optimizer for shared clouds. Proceedings of the VLDB Endowment, 2018, 12(3): 210\u2013222","journal-title":"Proceedings of the VLDB Endowment"},{"issue":"1","key":"41116_CR26","doi-asserted-by":"publisher","first-page":"208","DOI":"10.1186\/s12911-024-02583-3","volume":"24","author":"L Li","year":"2024","unstructured":"Li L, Guan J, Peng X, Zhou L, Zhang Z, Ding L, Zheng L, Wu L, Hu Z, Liu L, Yao Y. Machine learning for the prediction of 1-year mortality in patients with sepsis-associated acute kidney injury. BMC Medical Informatics and Decision Making, 2024, 24(1): 208","journal-title":"BMC Medical Informatics and Decision Making"},{"key":"41116_CR27","first-page":"340","volume-title":"Proceedings of 2017 Seventh International Conference on Affective Computing and Intelligent Interaction","author":"S Amiriparian","year":"2017","unstructured":"Amiriparian S, Pugachevskiy S, Cummins N, Hantke S, Pohjalainen J, Keren G, Schuller B W. CAST a database: Rapid targeted large-scale big data acquisition via small-world modelling of social media platforms. In: Proceedings of 2017 Seventh International Conference on Affective Computing and Intelligent Interaction. 2017, 340\u2013345"},{"key":"41116_CR28","first-page":"1","volume-title":"Proceedings of 2023 International Symposium on Networks, Computers and Communications","author":"Y Akbari","year":"2023","unstructured":"Akbari Y, Kunhoth J, Elharrouss O, Al-Maadeed S, Abualsaud K, Mohamed A, Khattab T. Indoor multi-lingual scene text database with different views. In: Proceedings of 2023 International Symposium on Networks, Computers and Communications. 2023, 1\u20136"},{"issue":"8","key":"41116_CR29","doi-asserted-by":"publisher","first-page":"5602","DOI":"10.1016\/j.jksuci.2021.05.013","volume":"34","author":"R Akhter","year":"2022","unstructured":"Akhter R, Sofi S A. Precision agriculture using IoT data analytics and machine learning. Journal of King Saud University-Computer and Information Sciences, 2022, 34(8): 5602\u20135618","journal-title":"Journal of King Saud University-Computer and Information Sciences"},{"issue":"2","key":"41116_CR30","doi-asserted-by":"publisher","first-page":"172205","DOI":"10.1007\/s11704-022-1357-5","volume":"17","author":"H Zhou","year":"2023","unstructured":"Zhou H, Qian W, Zhou X, Dong Q, Zhou A, Tan W. Scalable and adaptive log manager in distributed systems. Frontiers of Computer Science, 2023, 17(2): 172205","journal-title":"Frontiers of Computer Science"},{"key":"41116_CR31","doi-asserted-by":"publisher","first-page":"56","DOI":"10.1016\/j.neucom.2019.09.060","volume":"373","author":"X Xiong","year":"2020","unstructured":"Xiong X, Qiao S, Han N, Xiong F, Bu Z, Li R, Yue K, Yuan G. Where to go: An effective point-of-interest recommendation framework for heterogeneous social networks. Neurocomputing, 2020, 373: 56\u201369","journal-title":"Neurocomputing"},{"issue":"11","key":"41116_CR32","first-page":"2019","volume":"43","author":"G L Li","year":"2020","unstructured":"Li G L, Zhou X H, Sun J, Yu X, Yuan H-T, Liu J-B, Han Y. A survey of machine learning based database techniques. Chinese Journal of Computers, 2020, 43(11): 2019\u20132049","journal-title":"Chinese Journal of Computers"},{"key":"41116_CR33","doi-asserted-by":"publisher","first-page":"12262","DOI":"10.1109\/ACCESS.2022.3146008","volume":"10","author":"S Al-Azani","year":"2022","unstructured":"Al-Azani S, Sait S M, Al-Utaibi K A. A comprehensive literature review on children\u2019s databases for machine learning applications. IEEE Access, 2022, 10: 12262\u201312285","journal-title":"IEEE Access"},{"issue":"3","key":"41116_CR34","doi-asserted-by":"publisher","first-page":"95","DOI":"10.4018\/JDM.2021070105","volume":"32","author":"M Fantinato","year":"2021","unstructured":"Fantinato M, Peres S M, Kafeza E, Chiu D K W, Hung P C K. A review on the integration of deep learning and service-oriented architecture. Journal of Database Management, 2021, 32(3): 95\u2013119","journal-title":"Journal of Database Management"},{"issue":"1","key":"41116_CR35","doi-asserted-by":"publisher","first-page":"41","DOI":"10.1145\/3588721","volume":"1","author":"Z Wu","year":"2023","unstructured":"Wu Z, Negi P, Alizadeh M, Kraska T, Madden S. FactorJoin: A new cardinality estimation framework for join queries. Proceedings of the ACM on Management of Data, 2023, 1(1): 41","journal-title":"Proceedings of the ACM on Management of Data"},{"key":"41116_CR36","doi-asserted-by":"publisher","first-page":"1465","DOI":"10.1145\/3448016.3452821","volume-title":"Proceedings of 2021 International Conference on Management of Data","author":"Y Qiu","year":"2021","unstructured":"Qiu Y, Wang Y, Yi K, Li F, Wu B, Zhan C. Weighted distinct sampling: Cardinality estimation for SPJ queries. In: Proceedings of 2021 International Conference on Management of Data. 2021, 1465\u20131477"},{"key":"41116_CR37","first-page":"605","volume-title":"Proceedings of the 11th Annual European Symposium on Algorithms","author":"M Durand","year":"2003","unstructured":"Durand M, Flajolet P. Loglog counting of large cardinalities (Extended abstract). In: Proceedings of the 11th Annual European Symposium on Algorithms. 2003, 605\u2013617"},{"key":"41116_CR38","first-page":"19","volume-title":"Proceedings of the 29th International Conference on Very Large Data Bases","author":"Y E Ioannidis","year":"2003","unstructured":"Ioannidis Y E. The history of histograms (abridged). In: Proceedings of the 29th International Conference on Very Large Data Bases. 2003, 19\u201330"},{"issue":"4","key":"41116_CR39","doi-asserted-by":"publisher","first-page":"971","DOI":"10.1007\/s10115-021-01547-7","volume":"63","author":"M Zhang","year":"2021","unstructured":"Zhang M, Wang H. Selectivity estimation with density-model-based multidimensional histogram. Knowledge and Information Systems, 2021, 63(4): 971\u2013992","journal-title":"Knowledge and Information Systems"},{"issue":"17","key":"41116_CR40","doi-asserted-by":"publisher","first-page":"7364","DOI":"10.3390\/s23177364","volume":"23","author":"K Qi","year":"2023","unstructured":"Qi K, Yu J, He Z. A cardinality estimator in complex database systems based on TreeLSTM. Sensors, 2023, 23(17): 7364","journal-title":"Sensors"},{"key":"41116_CR41","doi-asserted-by":"publisher","first-page":"1017","DOI":"10.1145\/3318464.3389727","volume-title":"Proceedings of 2020 ACM SIGMOD International Conference on Management of Data","author":"Y Park","year":"2020","unstructured":"Park Y, Zhong S, Mozafari B. QuickSel: Quick selectivity learning with mixture models. In: Proceedings of 2020 ACM SIGMOD International Conference on Management of Data. 2020, 1017\u20131033"},{"issue":"9","key":"41116_CR42","doi-asserted-by":"publisher","first-page":"1044","DOI":"10.14778\/3329772.3329780","volume":"12","author":"A Dutt","year":"2019","unstructured":"Dutt A, Wang C, Nazi A, Kandula S, Narasayya V, Chaudhuri S. Selectivity estimation for range predicates using lightweight models. Proceedings of the VLDB Endowment, 2019, 12(9): 1044\u20131057","journal-title":"Proceedings of the VLDB Endowment"},{"key":"41116_CR43","first-page":"5","volume-title":"Proceedings of the 2nd International Workshop on Exploiting Artificial Intelligence Techniques for Data Management","author":"L Woltmann","year":"2019","unstructured":"Woltmann L, Hartmann C, Thiele M, Habich D, Lehner W. Cardinality estimation with local deep learning models. In: Proceedings of the 2nd International Workshop on Exploiting Artificial Intelligence Techniques for Data Management. 2019, 5"},{"key":"41116_CR44","volume-title":"Proceedings of the 9th Biennial Conference on Innovative Data Systems Research","author":"A Kipf","year":"2019","unstructured":"Kipf A, Kipf T, Radke B, Leis V, Boncz P A, Kemper A. Learned cardinalities: Estimating correlated joins with deep learning. In: Proceedings of the 9th Biennial Conference on Innovative Data Systems Research. 2019"},{"issue":"11","key":"41116_CR45","doi-asserted-by":"publisher","first-page":"852","DOI":"10.14778\/3402707.3402724","volume":"4","author":"K Tzoumas","year":"2011","unstructured":"Tzoumas K, Deshpande A, Jensen C S. Lightweight graphical models for selectivity estimation without independence assumptions. Proceedings of the VLDB Endowment, 2011, 4(11): 852\u2013863","journal-title":"Proceedings of the VLDB Endowment"},{"issue":"5","key":"41116_CR46","doi-asserted-by":"publisher","first-page":"185321","DOI":"10.1007\/s11704-023-2246-2","volume":"18","author":"R Sun","year":"2024","unstructured":"Sun R, Tao H, Chen Y, Liu Q. HACAN: A hierarchical answer-aware and context-aware network for question generation. Frontiers of Computer Science, 2024, 18(5): 185321","journal-title":"Frontiers of Computer Science"},{"issue":"11","key":"41116_CR47","doi-asserted-by":"publisher","first-page":"1733","DOI":"10.14778\/3342263.3342646","volume":"12","author":"R Marcus","year":"2019","unstructured":"Marcus R, Papaemmanouil O. Plan-structured deep neural network models for query performance prediction. Proceedings of the VLDB Endowment, 2019, 12(11): 1733\u20131746","journal-title":"Proceedings of the VLDB Endowment"},{"issue":"3","key":"41116_CR48","doi-asserted-by":"publisher","first-page":"307","DOI":"10.14778\/3368289.3368296","volume":"13","author":"J Sun","year":"2019","unstructured":"Sun J, Li G. An end-to-end learning-based cost estimator. Proceedings of the VLDB Endowment, 2019, 13(3): 307\u2013319","journal-title":"Proceedings of the VLDB Endowment"},{"issue":"2","key":"41116_CR49","doi-asserted-by":"publisher","first-page":"321","DOI":"10.14778\/3489496.3489512","volume":"15","author":"P Li","year":"2021","unstructured":"Li P, Hua Y, Jia J, Zuo P. FINEdex: A fine-grained learned index scheme for scalable and concurrent memory systems. Proceedings of the VLDB Endowment, 2021, 15(2): 321\u2013334","journal-title":"Proceedings of the VLDB Endowment"},{"key":"41116_CR50","doi-asserted-by":"publisher","first-page":"1477","DOI":"10.1145\/2723372.2749438","volume-title":"Proceedings of 2015 ACM SIGMOD International Conference on Management of Data","author":"M Heimel","year":"2015","unstructured":"Heimel M, Kiefer M, Markl V. Self-tuning, GPU-accelerated kernel density models for multidimensional selectivity estimation. In: Proceedings of 2015 ACM SIGMOD International Conference on Management of Data. 2015, 1477\u20131492"},{"issue":"9","key":"41116_CR51","doi-asserted-by":"publisher","first-page":"2249","DOI":"10.1007\/s11263-022-01644-2","volume":"130","author":"J Ma","year":"2022","unstructured":"Ma J, Fan A, Jiang X, Xiao G. Feature matching via motion-consistency driven probabilistic graphical model. International Journal of Computer Vision, 2022, 130(9): 2249\u20132264","journal-title":"International Journal of Computer Vision"},{"issue":"7","key":"41116_CR52","doi-asserted-by":"publisher","first-page":"992","DOI":"10.14778\/3384345.3384349","volume":"13","author":"B Hilprecht","year":"2020","unstructured":"Hilprecht B, Schmidt A, Kulessa M, Molina A, Kersting K, Binnig C. DeepDB: Learn from data, not from queries! Proceedings of the VLDB Endowment, 2020, 13(7): 992\u20131005","journal-title":"Proceedings of the VLDB Endowment"},{"issue":"3","key":"41116_CR53","doi-asserted-by":"publisher","first-page":"462","DOI":"10.1109\/TIT.1968.1054142","volume":"14","author":"C Chow","year":"1968","unstructured":"Chow C, Liu C. Approximating discrete probability distributions with dependence trees. IEEE Transactions on Information Theory, 1968, 14(3): 462\u2013467","journal-title":"IEEE Transactions on Information Theory"},{"issue":"6","key":"41116_CR54","doi-asserted-by":"publisher","first-page":"176350","DOI":"10.1007\/s11704-023-2740-6","volume":"17","author":"T Wu","year":"2023","unstructured":"Wu T, Qian H, Liu Z, Zhou J, Zhou A. Bi-objective evolutionary Bayesian network structure learning via skeleton constraint. Frontiers of Computer Science, 2023, 17(6): 176350","journal-title":"Frontiers of Computer Science"},{"issue":"9","key":"41116_CR55","doi-asserted-by":"publisher","first-page":"1489","DOI":"10.14778\/3461535.3461539","volume":"14","author":"R Zhu","year":"2021","unstructured":"Zhu R, Wu Z, Han Y, Zeng K, Pfadler A, Qian Z, Zhou J, Cui B. FLAT: Fast, lightweight and accurate method for cardinality estimation. Proceedings of the VLDB Endowment, 2021, 14(9): 1489\u20131502","journal-title":"Proceedings of the VLDB Endowment"},{"issue":"1","key":"41116_CR56","doi-asserted-by":"publisher","first-page":"72","DOI":"10.14778\/3485450.3485458","volume":"15","author":"J Wang","year":"2021","unstructured":"Wang J, Chai C, Liu J, Li G. FACE: A normalizing flow based cardinality estimator. Proceedings of the VLDB Endowment, 2021, 15(1): 72\u201384","journal-title":"Proceedings of the VLDB Endowment"},{"issue":"9","key":"41116_CR57","doi-asserted-by":"publisher","first-page":"1640","DOI":"10.14778\/3461535.3461552","volume":"14","author":"X Wang","year":"2021","unstructured":"Wang X, Qu C, Wu W, Wang J, Zhou Q. Are we ready for learned cardinality estimation? Proceedings of the VLDB Endowment, 2021, 14(9): 1640\u20131654","journal-title":"Proceedings of the VLDB Endowment"},{"issue":"1","key":"41116_CR58","doi-asserted-by":"publisher","first-page":"85","DOI":"10.14778\/3485450.3485459","volume":"15","author":"J Sun","year":"2021","unstructured":"Sun J, Zhang J, Sun Z, Li G, Tang N. Learned cardinality estimation: A design space exploration and A comparative evaluation. Proceedings of the VLDB Endowment, 2021, 15(1): 85\u201397","journal-title":"Proceedings of the VLDB Endowment"},{"key":"41116_CR59","first-page":"7760","volume-title":"Proceedings of the 57th Hawaii International Conference on System Sciences","author":"J Sandell","year":"2024","unstructured":"Sandell J, Asplund E, Ayele W Y, Duneld M. Performance comparison analysis of ArangoDB, MySQL, and Neo4j: An experimental study of querying connected data. In: Proceedings of the 57th Hawaii International Conference on System Sciences. 2024, 7760\u20137769"},{"issue":"12","key":"41116_CR60","doi-asserted-by":"publisher","first-page":"3910","DOI":"10.14778\/3611540.3611583","volume":"16","author":"D J Lew","year":"2023","unstructured":"Lew D J, Yoo K, Nam K W. DeepVQL: Deep video queries on PostgreSQL. Proceedings of the VLDB Endowment, 2023, 16(12): 3910\u20133913","journal-title":"Proceedings of the VLDB Endowment"},{"issue":"1","key":"41116_CR61","doi-asserted-by":"publisher","first-page":"19","DOI":"10.1145\/3639274","volume":"2","author":"Y Xu","year":"2024","unstructured":"Xu Y, Zhang D, Zhang S, Wu S, Feng Z, Chen G. Predictive and near-optimal sampling for view materialization in video databases. Proceedings of the ACM on Management of Data, 2024, 2(1): 19","journal-title":"Proceedings of the ACM on Management of Data"},{"key":"41116_CR62","first-page":"11","volume-title":"Proceedings of the 19th International Conference on Artificial Intelligence in Medicine","author":"J Wei","year":"2021","unstructured":"Wei J, Suriawinata A, Ren B, Liu X, Lisovsky M, Vaickus L, Brown C, Baker M, Tomita N, Torresani L, Wei J, Hassanpour S. A petri dish for histopathology image analysis. In: Proceedings of the 19th International Conference on Artificial Intelligence in Medicine. 2021, 11\u201324"},{"issue":"4","key":"41116_CR63","doi-asserted-by":"publisher","first-page":"752","DOI":"10.14778\/3503585.3503586","volume":"15","author":"Y Han","year":"2021","unstructured":"Han Y, Wu Z, Wu P, Zhu R, Yang J, Tan L W, Zeng K, Cong G, Qin Y, Pfadler A, Qian Z, Zhou J, Li J, Cui B. Cardinality estimation in DBMS: A comprehensive benchmark evaluation. Proceedings of the VLDB Endowment, 2021, 15(4): 752\u2013765","journal-title":"Proceedings of the VLDB Endowment"},{"key":"41116_CR64","first-page":"513","volume-title":"Proceedings of the 9th International Conference on Extending Database Technology on Advances in Database Technology","author":"Z He","year":"2004","unstructured":"He Z, Lee B S, Snapp R R. Self-tuning UDF cost modeling using the memory-limited quadtree. In: Proceedings of the 9th International Conference on Extending Database Technology on Advances in Database Technology. 2004, 513\u2013531"},{"issue":"3","key":"41116_CR65","doi-asserted-by":"publisher","first-page":"812","DOI":"10.1145\/1093382.1093387","volume":"30","author":"Z He","year":"2005","unstructured":"He Z, Lee B S, Snapp R. Self-tuning cost modeling of user-defined functions in an object-relational DBMS. ACM Transactions on Database Systems (TODS), 2005, 30(3): 812\u2013853","journal-title":"ACM Transactions on Database Systems (TODS)"},{"key":"41116_CR66","doi-asserted-by":"publisher","first-page":"153","DOI":"10.1145\/2806777.2806944","volume-title":"Proceedings of the 6th ACM Symposium on Cloud Computing","author":"F Liu","year":"2015","unstructured":"Liu F, Blanas S. Forecasting the cost of processing multi-join queries via hashing for main-memory databases. In: Proceedings of the 6th ACM Symposium on Cloud Computing. 2015, 153\u2013166"},{"issue":"5","key":"41116_CR67","doi-asserted-by":"publisher","first-page":"643","DOI":"10.1007\/s00778-017-0480-7","volume":"27","author":"V Leis","year":"2018","unstructured":"Leis V, Radke B, Gubichev A, Mirchev A, Boncz P, Kemper A, Neumann T. Query optimization through the looking glass, and what we found running the join order benchmark. The VLDB Journal, 2018, 27(5): 643\u2013668","journal-title":"The VLDB Journal"},{"key":"41116_CR68","doi-asserted-by":"publisher","first-page":"99","DOI":"10.1145\/3318464.3380584","volume-title":"Proceedings of 2020 ACM SIGMOD International Conference on Management of Data","author":"T Siddiqui","year":"2020","unstructured":"Siddiqui T, Jindal A, Qiao S, Patel H, Le W. Cost models for big data query processing: Learning, retrofitting, and our findings. In: Proceedings of 2020 ACM SIGMOD International Conference on Management of Data. 2020, 99\u2013113"},{"key":"41116_CR69","doi-asserted-by":"publisher","first-page":"168","DOI":"10.1145\/115790.115813","volume-title":"Proceedings of 1991 ACM SIGMOD International Conference on Management of Data","author":"Y E Ioannidis","year":"1991","unstructured":"Ioannidis Y E, Kang Y C. Left-Deep vs. Bushy Trees: An analysis of strategy spaces and its implications for query optimization. In: Proceedings of 1991 ACM SIGMOD International Conference on Management of Data. 1991, 168\u2013177"},{"key":"41116_CR70","first-page":"400","volume-title":"Proceedings of the 4th International Conference on Genetic Algorithms","author":"K Bennett","year":"1991","unstructured":"Bennett K, Ferris M C, Ioannidis Y E. A genetic algorithm for database query optimization. In: Proceedings of the 4th International Conference on Genetic Algorithms. 1991, 400\u2013407"},{"key":"41116_CR71","first-page":"19","volume-title":"Proceedings of the 27th International Conference on Very Large Data Bases","author":"M Stillger","year":"2001","unstructured":"Stillger M, Lohman G M, Markl V, Kandil M. LEO - DB2\u2019s LEarning optimizer. In: Proceedings of the 27th International Conference on Very Large Data Bases. 2001, 19\u201328"},{"key":"41116_CR72","first-page":"3","volume-title":"Proceedings of the First International Workshop on Exploiting Artificial Intelligence Techniques for Data Management","author":"R Marcus","year":"2018","unstructured":"Marcus R, Papaemmanouil O. Deep reinforcement learning for join order enumeration. In: Proceedings of the First International Workshop on Exploiting Artificial Intelligence Techniques for Data Management. 2018, 3"},{"issue":"3","key":"41116_CR73","doi-asserted-by":"publisher","first-page":"183343","DOI":"10.1007\/s11704-024-3803-z","volume":"18","author":"X Song","year":"2024","unstructured":"Song X, Huang H, Lian J, Jin H. XGCN: a library for large-scale graph neural network recommendations. Frontiers of Computer Science, 2024, 18(3): 183343","journal-title":"Frontiers of Computer Science"},{"key":"41116_CR74","volume-title":"Proceedings of the VLDB 2020 PhD Workshop","author":"J Zhang","year":"2020","unstructured":"Zhang J. AlphaJoin: Join order selection \u00e0 la AlphaGo. In: Proceedings of the VLDB 2020 PhD Workshop. 2020"},{"key":"41116_CR75","doi-asserted-by":"publisher","first-page":"261","DOI":"10.1145\/342009.335420","volume-title":"Proceedings of 2000 ACM SIGMOD International Conference on Management of Data","author":"R Avnur","year":"2000","unstructured":"Avnur R, Hellerstein J M. Eddies: Continuously adaptive query processing. In: Proceedings of 2000 ACM SIGMOD International Conference on Management of Data. 2000, 261\u2013272"},{"issue":"3","key":"41116_CR76","doi-asserted-by":"publisher","first-page":"9","DOI":"10.1145\/3464389","volume":"46","author":"I Trummer","year":"2021","unstructured":"Trummer I, Wang J, Wei Z, Maram D, Moseley S, Jo S, Antonakakis J, Rayabhari A. SkinnerDB: Regret-bounded query evaluation via reinforcement learning. ACM Transactions on Database Systems (TODS), 2021, 46(3): 9","journal-title":"ACM Transactions on Database Systems (TODS)"},{"key":"41116_CR77","unstructured":"Krishnan S, Yang Z, Goldberg K, Hellerstein J M, Stoica I. Learning to optimize join queries with deep reinforcement learning. 2018, arXiv preprint arXiv: 1808.03196"},{"issue":"1","key":"41116_CR78","doi-asserted-by":"publisher","first-page":"98","DOI":"10.1147\/sj.421.0098","volume":"42","author":"V Markl","year":"2003","unstructured":"Markl V, Lohman G M, Raman V. LEO: An autonomic query optimizer for DB2. IBM Systems Journal, 2003, 42(1): 98\u2013106","journal-title":"IBM Systems Journal"},{"key":"41116_CR79","doi-asserted-by":"publisher","first-page":"1275","DOI":"10.1145\/3448016.3452838","volume-title":"Proceedings of 2021 International Conference on Management of Data","author":"R Marcus","year":"2021","unstructured":"Marcus R, Negi P, Mao H, Tatbul N, Alizadeh M, Kraska T. Bao: Making learned query optimization practical. In: Proceedings of 2021 International Conference on Management of Data. 2021, 1275\u20131288"},{"key":"41116_CR80","doi-asserted-by":"publisher","first-page":"2557","DOI":"10.1145\/3448016.3457568","volume-title":"Proceedings of 2021 International Conference on Management of Data","author":"P Negi","year":"2021","unstructured":"Negi P, Interlandi M, Marcus R, Alizadeh M, Kraska T, Friedman M T, Jindal A. Steering query optimizers: A practical take on big data workloads. In: Proceedings of 2021 International Conference on Management of Data. 2021, 2557\u20132569"},{"issue":"2","key":"41116_CR81","doi-asserted-by":"publisher","first-page":"172202","DOI":"10.1007\/s11704-022-1056-2","volume":"17","author":"C Zhang","year":"2023","unstructured":"Zhang C, Li Y, Zhang R, Qian W, Zhou A. Scalable and quantitative contention generation for performance evaluation on OLTP databases. Frontiers of Computer Science, 2023, 17(2): 172202","journal-title":"Frontiers of Computer Science"},{"key":"41116_CR82","first-page":"4972","volume-title":"Proceedings of the 37th AAAI Conference on Artificial Intelligence","author":"S Zhou","year":"2023","unstructured":"Zhou S, Li J, Wang H, Shang S, Han P. GRLSTM: Trajectory similarity computation with graph-based residual LSTM. In: Proceedings of the 37th AAAI Conference on Artificial Intelligence. 2023, 4972\u20134980"},{"key":"41116_CR83","first-page":"1","volume-title":"Proceedings of 2023 IEEE Wireless Communications and Networking Conference","author":"Y Chen","year":"2023","unstructured":"Chen Y, Cao H, Zhou Y, Liu Z, Chen D, Zhao J, Shi J. A GCN-GRU based end-to-end LEO satellite network dynamic topology prediction method. In: Proceedings of 2023 IEEE Wireless Communications and Networking Conference. 2023, 1\u20136"},{"key":"41116_CR84","first-page":"7006","volume-title":"Proceedings of the Thirty-Seventh AAAI Conference on Artificial Intelligence","author":"M Chatzianastasis","year":"2023","unstructured":"Chatzianastasis M, Lutzeyer J F, Dasoulas G, Vazirgiannis M. Graph ordering attention networks. In: Proceedings of the Thirty-Seventh AAAI Conference on Artificial Intelligence. 2023, 7006\u20137014"},{"key":"41116_CR85","first-page":"3597","volume-title":"Proceedings of the 37th AAAI Conference on Artificial Intelligence","author":"W Zhao","year":"2023","unstructured":"Zhao W, Hu H, Zhou W, Shi J, Li H. BEST: BERT pre-training for sign language recognition with coupling tokenization. In: Proceedings of the 37th AAAI Conference on Artificial Intelligence. 2023, 3597\u20133605"},{"key":"41116_CR86","first-page":"1047","volume":"546","author":"L Chen","year":"2021","unstructured":"Chen L, Huang H, Chen D. Join cardinality estimation by combining operator-level deep neural networks. Inf. Sci., 2021, 546: 1047\u20131062","journal-title":"Sci."},{"key":"41116_CR87","first-page":"31","volume-title":"Proceedings of the 44th ACM\/IEEE International Conference on Software Engineering: New Ideas and Emerging Results","author":"S Dey","year":"2022","unstructured":"Dey S, Vinayakarao V, Gupta M, Dechu S. Evaluating commit message generation: To BLEU or not to BLEU? In: Proceedings of the 44th ACM\/IEEE International Conference on Software Engineering: New Ideas and Emerging Results. 2022, 31\u201335"},{"key":"41116_CR88","doi-asserted-by":"publisher","first-page":"1702","DOI":"10.18653\/v1\/D18-1197","volume-title":"Proceedings of 2018 Conference on Empirical Methods in Natural Language Processing","author":"S Yavuz","year":"2018","unstructured":"Yavuz S, G\u00fcr I, Su Y, Yan X. What it takes to achieve 100% condition accuracy on WikiSQL. In: Proceedings of 2018 Conference on Empirical Methods in Natural Language Processing. 2018, 1702\u20131711"},{"key":"41116_CR89","doi-asserted-by":"publisher","first-page":"3911","DOI":"10.18653\/v1\/D18-1425","volume-title":"Proceedings of 2018 Conference on Empirical Methods in Natural Language Processing","author":"T Yu","year":"2018","unstructured":"Yu T, Zhang R, Yang K, Yasunaga M, Wang D, Li Z, Ma J, Li I, Yao Q, Roman S, Zhang Z, Radev D. Spider: A large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-SQL task. In: Proceedings of 2018 Conference on Empirical Methods in Natural Language Processing. 2018, 3911\u20133921"},{"key":"41116_CR90","doi-asserted-by":"publisher","first-page":"154","DOI":"10.1145\/3511095.3531282","volume-title":"Proceedings of the 33rd ACM Conference on Hypertext and Social Media","author":"S Salimzadeh","year":"2022","unstructured":"Salimzadeh S, Gadiraju U, Hauff C, van Deursen A. Exploring the feasibility of crowd-powered decomposition of complex user questions in text-to-SQL tasks. In: Proceedings of the 33rd ACM Conference on Hypertext and Social Media. 2022, 154\u2013165"},{"key":"41116_CR91","doi-asserted-by":"publisher","first-page":"8926","DOI":"10.18653\/v1\/2021.emnlp-main.702","volume-title":"Proceedings of 2021 Conference on Empirical Methods in Natural Language Processing","author":"Y Gan","year":"2021","unstructured":"Gan Y, Chen X, Purver M. Exploring underexplored limitations of cross-domain text-to-SQL generalization. In: Proceedings of 2021 Conference on Empirical Methods in Natural Language Processing. 2021, 8926\u20138931"},{"key":"41116_CR92","first-page":"2505","volume-title":"Proceedings of the 59th Annual Meeting of the Association for Computational Linguistics and the 11th International Joint Conference on Natural Language Processing (Volume 1: Long Papers)","author":"Y Gan","year":"2021","unstructured":"Gan Y, Chen X, Huang Q, Purver M, Woodward J R, Xie J, Huang P. Towards robustness of text-to-SQL models against synonym substitution. In: Proceedings of the 59th Annual Meeting of the Association for Computational Linguistics and the 11th International Joint Conference on Natural Language Processing (Volume 1: Long Papers). 2021, 2505\u20132515"},{"key":"41116_CR93","first-page":"2261","volume-title":"Proceedings of the 59th Annual Meeting of the Association for Computational Linguistics and the 11th International Joint Conference on Natural Language Processing (Volume 1: Long Papers)","author":"C H Lee","year":"2021","unstructured":"Lee C H, Polozov O, Richardson M. KaggleDBQA: Realistic evaluation of text-to-SQL parsers. In: Proceedings of the 59th Annual Meeting of the Association for Computational Linguistics and the 11th International Joint Conference on Natural Language Processing (Volume 1: Long Papers). 2021, 2261\u20132273"},{"key":"41116_CR94","unstructured":"Xu X, Liu C, Song D. SQLNet: Generating structured queries from natural language without reinforcement learning. 2017, arXiv preprint arXiv: 1711.04436"},{"key":"41116_CR95","first-page":"3652","volume-title":"Proceedings of 2019 Conference on Empirical Methods in Natural Language Processing and the 9th International Joint Conference on Natural Language Processing (EMNLP-IJCNLP)","author":"Q Min","year":"2019","unstructured":"Min Q, Shi Y, Zhang Y. A pilot study for Chinese SQL semantic parsing. In: Proceedings of 2019 Conference on Empirical Methods in Natural Language Processing and the 9th International Joint Conference on Natural Language Processing (EMNLP-IJCNLP). 2019, 3652\u20133658"},{"key":"41116_CR96","first-page":"343","volume-title":"Proceedings of Machine Learning and Data Mining in Pattern Recognition: 15th International Conference on Machine Learning and Data Mining","author":"K Stower","year":"2019","unstructured":"Stower K, Krechel D. Seq2SQL - evaluating different deep learning architectures using word embeddings. In: Proceedings of Machine Learning and Data Mining in Pattern Recognition: 15th International Conference on Machine Learning and Data Mining. 2019, 343\u2013354"},{"key":"41116_CR97","doi-asserted-by":"publisher","first-page":"4524","DOI":"10.18653\/v1\/P19-1444","volume-title":"Proceedings of the 57th Annual Meeting of the Association for Computational Linguistics","author":"J Guo","year":"2019","unstructured":"Guo J, Zhan Z, Gao Y, Xiao Y, Lou J G, Liu T, Zhang D. Towards complex text-to-SQL in cross-domain database with intermediate representation. In: Proceedings of the 57th Annual Meeting of the Association for Computational Linguistics. 2019, 4524\u20134535"},{"key":"41116_CR98","doi-asserted-by":"publisher","first-page":"1235","DOI":"10.18653\/v1\/2022.findings-emnlp.89","volume-title":"Proceedings of Findings of the Association for Computational Linguistics: EMNLP 2022","author":"Z Cai","year":"2022","unstructured":"Cai Z, Li X, Hui B, Yang M, Li B, Li B, Cao Z, Li W, Huang F, Si L, Li Y. STAR: SQL guided pre-training for context-dependent text-to-SQL parsing. In: Proceedings of Findings of the Association for Computational Linguistics: EMNLP 2022. 2022, 1235\u20131247"},{"key":"41116_CR99","first-page":"1593","volume-title":"Proceedings of the 29th International Conference on Computational Linguistics","author":"O Popescu","year":"2022","unstructured":"Popescu O, Manotas I, Vo N P A, Yeo H, Khorashani E, Sheinin V. Addressing limitations of encoder-decoder based approach to text-to-SQL. In: Proceedings of the 29th International Conference on Computational Linguistics. 2022, 1593\u20131603"},{"issue":"2","key":"41116_CR100","doi-asserted-by":"publisher","first-page":"457","DOI":"10.1162\/dint_a_00194","volume":"5","author":"S Li","year":"2023","unstructured":"Li S, Zhou K, Zhuang Z, Wang H, Ma J. Towards text-to-SQL over aggregate tables. Data Intelligence, 2023, 5(2): 457\u2013474","journal-title":"Data Intelligence"},{"issue":"11","key":"41116_CR101","doi-asserted-by":"publisher","first-page":"15205","DOI":"10.1007\/s11042-022-12573-0","volume":"81","author":"C Wei","year":"2022","unstructured":"Wei C, Huang S, Li R. Enhance text-to-SQL model performance with information sharing and reweight loss. Multimedia Tools and Applications, 2022, 81(11): 15205\u201315217","journal-title":"Multimedia Tools and Applications"},{"key":"41116_CR102","doi-asserted-by":"publisher","first-page":"2528","DOI":"10.18653\/v1\/2022.findings-naacl.193","volume-title":"Proceedings of Findings of the Association for Computational Linguistics: NAACL 2022","author":"T Wolfson","year":"2022","unstructured":"Wolfson T, Deutch D, Berant J. Weakly supervised text-to-SQL parsing through question decomposition. In: Proceedings of Findings of the Association for Computational Linguistics: NAACL 2022. 2022, 2528\u20132542"},{"issue":"3","key":"41116_CR103","doi-asserted-by":"publisher","first-page":"513","DOI":"10.3390\/e25030513","volume":"25","author":"G Jeong","year":"2023","unstructured":"Jeong G, Han M, Kim S, Lee Y, Lee J, Park S, Kim H. Improving text-to-SQL with a hybrid decoding method. Entropy, 2023, 25(3): 513","journal-title":"Entropy"},{"key":"41116_CR104","doi-asserted-by":"publisher","first-page":"3215","DOI":"10.18653\/v1\/2022.emnlp-main.211","volume-title":"Proceedings of 2022 Conference on Empirical Methods in Natural Language Processing","author":"J Qi","year":"2022","unstructured":"Qi J, Tang J, He Z, Wan X, Cheng Y, Zhou C, Wang X, Zhang Q, Lin Z. RASAT: Integrating relational structures into pretrained Seq2Seq model for text-to-SQL. In: Proceedings of 2022 Conference on Empirical Methods in Natural Language Processing. 2022, 3215\u20133229"},{"key":"41116_CR105","doi-asserted-by":"publisher","first-page":"1845","DOI":"10.18653\/v1\/2022.findings-naacl.141","volume-title":"Proceedings of Findings of the Association for Computational Linguistics: NAACL 2022","author":"K Xu","year":"2022","unstructured":"Xu K, Wang Y, Wang Y, Wang Z, Wen Z, Dong Y. SeaD: End-to-end text-to-SQL generation with schema-aware denoising. In: Proceedings of Findings of the Association for Computational Linguistics: NAACL 2022. 2022, 1845\u20131853"},{"key":"41116_CR106","first-page":"5298","volume-title":"Proceedings of the 29th International Conference on Computational Linguistics","author":"B Qin","year":"2022","unstructured":"Qin B, Wang L, Hui B, Li B, Wei X, Li B, Huang F, Si L, Yang M, Li Y. SUN: Exploring intrinsic uncertainties in text-to-SQL parsers. In: Proceedings of the 29th International Conference on Computational Linguistics. 2022, 5298\u20135308"},{"key":"41116_CR107","doi-asserted-by":"publisher","first-page":"5248","DOI":"10.18653\/v1\/2022.findings-emnlp.384","volume-title":"Proceedings of Findings of the Association for Computational Linguistics: EMNLP 2022","author":"P Shi","year":"2022","unstructured":"Shi P, Zhang R, Bai H, Lin J. XRICL: Cross-lingual retrieval-augmented in-context learning for cross-lingual text-to-SQL semantic parsing. In: Proceedings of Findings of the Association for Computational Linguistics: EMNLP 2022. 2022, 5248\u20135259"},{"key":"41116_CR108","doi-asserted-by":"publisher","first-page":"2007","DOI":"10.18653\/v1\/2022.acl-long.142","volume-title":"Proceedings of the 60th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers)","author":"X Pi","year":"2022","unstructured":"Pi X, Wang B, Gao Y, Guo J, Li Z, Lou J G. Towards robustness of text-to-SQL models against natural and realistic adversarial table perturbation. In: Proceedings of the 60th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers). 2022, 2007\u20132022"},{"key":"41116_CR109","first-page":"1","volume-title":"Proceedings of 2022 International Joint Conference on Neural Networks","author":"S Han","year":"2022","unstructured":"Han S, Gao N, Guo X, Shan Y. RuleSQLova: Improving text-to-SQL with logic rules. In: Proceedings of 2022 International Joint Conference on Neural Networks. 2022, 1\u20138"},{"key":"41116_CR110","doi-asserted-by":"publisher","first-page":"2997","DOI":"10.18653\/v1\/2022.findings-acl.236","volume-title":"Proceedings of Findings of the Association for Computational Linguistics: ACL 2022","author":"Y Zheng","year":"2022","unstructured":"Zheng Y, Wang H, Dong B, Wang X, Li C. HIE-SQL: History information enhanced network for context-dependent text-to-SQL semantic parsing. In: Proceedings of Findings of the Association for Computational Linguistics: ACL 2022. 2022, 2997\u20133007"},{"key":"41116_CR111","doi-asserted-by":"publisher","first-page":"2055","DOI":"10.18653\/v1\/2022.findings-emnlp.150","volume-title":"Proceedings of Findings of the Association for Computational Linguistics: EMNLP 2022","author":"D Xiao","year":"2022","unstructured":"Xiao D, Chai L, Zhang Q W, Yan Z, Li Z, Cao Y. CQR-SQL: Conversational question reformulation enhanced context-dependent text-to-SQL parsers. In: Proceedings of Findings of the Association for Computational Linguistics: EMNLP 2022. 2022, 2055\u20132068"},{"key":"41116_CR112","doi-asserted-by":"publisher","first-page":"1889","DOI":"10.1145\/3534678.3539305","volume-title":"Proceedings of the 28th ACM SIGKDD Conference on Knowledge Discovery and Data Mining","author":"L Wang","year":"2022","unstructured":"Wang L, Qin B, Hui B, Li B, Yang M, Wang B, Li B, Sun J, Huang F, Si L, Li Y. Proton: Probing schema linking information from pre-trained language models for text-to-SQL parsing. In: Proceedings of the 28th ACM SIGKDD Conference on Knowledge Discovery and Data Mining. 2022, 1889\u20131898"},{"key":"41116_CR113","doi-asserted-by":"publisher","first-page":"11548","DOI":"10.18653\/v1\/2022.emnlp-main.794","volume-title":"Proceedings of 2022 Conference on Empirical Methods in Natural Language Processing","author":"A Awasthi","year":"2022","unstructured":"Awasthi A, Sathe A, Sarawagi S. Diverse parallel data synthesis for cross-database adaptation of text-to-SQL parsers. In: Proceedings of 2022 Conference on Empirical Methods in Natural Language Processing. 2022, 11548\u201311562"},{"key":"41116_CR114","doi-asserted-by":"publisher","first-page":"5568","DOI":"10.18653\/v1\/2022.acl-long.381","volume-title":"Proceedings of the 60th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers)","author":"C Zhao","year":"2022","unstructured":"Zhao C, Su Y, Pauls A, Platanios E A. Bridging the generalization gap in text-to-SQL parsing with schema expansion. In: Proceedings of the 60th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers). 2022, 5568\u20135578"},{"key":"41116_CR115","volume-title":"Proceedings of the 36th Conference on Neural Information Processing Systems (NeurIPS 2022)","author":"G Lee","year":"2022","unstructured":"Lee G, Hwang H, Bae S, Kwon Y, Shin W, Yang S, Seo M, Kim J P, Choi E. EHRSQL: A practical text-to-SQL benchmark for electronic health records. In: Proceedings of the 36th Conference on Neural Information Processing Systems (NeurIPS 2022). 2022"},{"issue":"1","key":"41116_CR116","doi-asserted-by":"publisher","first-page":"11","DOI":"10.1186\/s13173-021-00115-9","volume":"27","author":"F D B S Praciano","year":"2021","unstructured":"Praciano F D B S, Amora P R P, Abreu I C, Pereira F L F, Machado J C. Robust cardinality: a novel approach for cardinality prediction in SQL queries. Journal of the Brazilian Computer Society, 2021, 27(1): 11","journal-title":"Journal of the Brazilian Computer Society"},{"key":"41116_CR117","first-page":"437","volume-title":"Proceedings of the 7th International Joint Conference on Web and Big Data","author":"J Yang","year":"2023","unstructured":"Yang J, Zhang Y, Wang B, Yang X. BoundEst: Estimating join cardinalities with tight upper bounds. In: Proceedings of the 7th International Joint Conference on Web and Big Data. 2023, 437\u2013451"},{"key":"41116_CR118","first-page":"111","volume-title":"Proceedings of the 22nd International Conference on Web Information Systems Engineering","author":"W Zhou","year":"2021","unstructured":"Zhou W, Zhan S, Guo L, Dai B. CELA: An accurate learned cardinality estimator with strong generalization ability and dimensional adaptability. In: Proceedings of the 22nd International Conference on Web Information Systems Engineering. 2021, 111\u2013118"},{"key":"41116_CR119","first-page":"4925","volume-title":"Proceedings of the 40th IEEE International Conference on Data Engineering","author":"Z Liang","year":"2024","unstructured":"Liang Z, Chen X, Xia Y, Ye R, Chen H, Xie J, Zheng K. DACE: A database-agnostic cost estimator. In: Proceedings of the 40th IEEE International Conference on Data Engineering. 2024, 4925\u20134937"},{"issue":"2","key":"41116_CR120","doi-asserted-by":"publisher","first-page":"121102","DOI":"10.1007\/s11432-021-3578-6","volume":"66","author":"S Huang","year":"2023","unstructured":"Huang S, Qin Y, Zhang X, Tu Y, Li Z, Cui B. Survey on performance optimization for database systems. Science China Information Sciences, 2023, 66(2): 121102","journal-title":"Science China Information Sciences"},{"key":"41116_CR121","first-page":"388","volume-title":"Proceedings of 2023 IEEE International Conference on Data Mining","author":"Z Liang","year":"2023","unstructured":"Liang Z, Chen X, Zhao Y, Xie J, Zeng K, Zheng K. Efficient cardinality and cost estimation with bidirectional compressor-based ensemble learning. In: Proceedings of 2023 IEEE International Conference on Data Mining. 2023, 388\u2013397"},{"issue":"6","key":"41116_CR122","doi-asserted-by":"publisher","first-page":"186356","DOI":"10.1007\/s11704-024-40065-x","volume":"18","author":"W Guo","year":"2024","unstructured":"Guo W, Zhuang F, Zhang X, Tong Y, Dong J. A comprehensive survey of federated transfer learning: Challenges, methods and applications. Frontiers of Computer Science, 2024, 18(6): 186356","journal-title":"Frontiers of Computer Science"},{"issue":"7","key":"41116_CR123","doi-asserted-by":"publisher","first-page":"71","DOI":"10.3390\/bdcc8070071","volume":"8","author":"B Warnke","year":"2024","unstructured":"Warnke B, Martens K, Winker T, Groppe S, Groppe J, Adhiyaman P, Srinivasan S, Krishnakumar S. ReJOOSp: Reinforcement learning for join order optimization in SPARQL. Big Data and Cognitive Computing, 2024, 8(7): 71","journal-title":"Big Data and Cognitive Computing"},{"issue":"6","key":"41116_CR124","doi-asserted-by":"publisher","first-page":"1504","DOI":"10.3390\/electronics12061504","volume":"12","author":"L Ji","year":"2023","unstructured":"Ji L, Zhao R, Dang Y, Liu J, Zhang H. Query join order optimization method based on dynamic double deep Q-network. Electronics, 2023, 12(6): 1504","journal-title":"Electronics"},{"issue":"5","key":"41116_CR125","doi-asserted-by":"publisher","first-page":"3093","DOI":"10.1007\/s11280-023-01156-0","volume":"26","author":"R Gu","year":"2023","unstructured":"Gu R, Zhang Y, Yin L, Song L, Huang W, Yuan C, Wang Z, Zhu G, Huang Y. Coral: Federated query join order optimization based on deep reinforcement learning. World Wide Web, 2023, 26(5): 3093\u20133118","journal-title":"World Wide Web"},{"key":"41116_CR126","doi-asserted-by":"publisher","first-page":"2859","DOI":"10.1145\/3448016.3457542","volume-title":"Proceedings of 2021 International Conference on Management of Data","author":"G Li","year":"2021","unstructured":"Li G, Zhou X, Cao L. AI meets database: AI4DB and DB4AI. In: Proceedings of 2021 International Conference on Management of Data. 2021, 2859\u20132866"},{"issue":"1","key":"41116_CR127","doi-asserted-by":"publisher","first-page":"102","DOI":"10.1007\/s41019-023-00235-6","volume":"9","author":"X Zhou","year":"2024","unstructured":"Zhou X, Sun Z, Li G. DB-GPT: Large language model meets database. Data Science and Engineering, 2024, 9(1): 102\u2013111","journal-title":"Data Science and Engineering"},{"key":"41116_CR128","volume-title":"Proceedings of the 11th International Conference on Learning Representations","author":"S Chang","year":"2023","unstructured":"Chang S, Wang J, Dong M, Pan L, Zhu H, Li A H, Lan W, Zhang S, Jiang J, Lilien J, Ash S, Wang W Y, Wang Z, Castelli V, Ng P, Xiang B. Dr.Spider: A diagnostic evaluation benchmark towards text-to-SQL robustness. In: Proceedings of the 11th International Conference on Learning Representations. 2023"}],"container-title":["Frontiers of Computer Science"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s11704-025-41116-7.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s11704-025-41116-7\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s11704-025-41116-7.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,26]],"date-time":"2025-06-26T11:02:46Z","timestamp":1750935766000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s11704-025-41116-7"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,6,26]]},"references-count":128,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2025,12]]}},"alternative-id":["41116"],"URL":"https:\/\/doi.org\/10.1007\/s11704-025-41116-7","relation":{},"ISSN":["2095-2228","2095-2236"],"issn-type":[{"value":"2095-2228","type":"print"},{"value":"2095-2236","type":"electronic"}],"subject":[],"published":{"date-parts":[[2025,6,26]]},"assertion":[{"value":"2 November 2024","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"18 March 2025","order":2,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"26 June 2025","order":3,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"Competing interests The authors declare that they have no competing nterests or financial conflicts to disclose.","order":1,"name":"Ethics","group":{"name":"EthicsHeading","label":"Ethics"}}],"article-number":"1912612"}}