{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,10,25]],"date-time":"2026-10-25T00:00:34Z","timestamp":1792886434691,"version":"4.5.0"},"reference-count":91,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2025,8]]},"abstract":"<jats:p>With the proliferation of Large Language Models (LLMs) in Business Intelligence (BI), existing solutions face critical challenges in industrial deployments: functionality deficiencies from legacy systems failing to meet evolving LLM-era user demands, interaction limitations from single-round SQL generation paradigms inadequate for multi-round clarification, and cost for domain adaptation arising from cross-domain methods migration.<\/jats:p>\n          <jats:p>We present SiriusBI, a practical LLM-powered BI system addressing the challenges of industrial deployments through three key innovations: (a) An end-to-end architecture integrating multi-module coordination to overcome functionality gaps in legacy systems; (b) A multi-round dialogue with querying mechanism, consisting of semantic completion, knowledge-guided clarification, and proactive querying processes, to resolve interaction constraints in SQL generation; (c) A data-conditioned SQL generation method selection strategy that supports both an efficient one-step Fine-Tuning approach and a two-step method leveraging Semantic Intermediate Representation for low-cost cross-domain applications. Experiments on both real-world datasets and public benchmarks demonstrate the effectiveness of SiriusBI. User studies further confirm that SiriusBI enhances both productivity and user experience.<\/jats:p>\n          <jats:p>As an independent service on Tencent's data platform, SiriusBI is deployed across finance, advertising, and cloud sectors, serving dozens of enterprise clients. It achieves over 93% accuracy in SQL generation and reduces data analysts' query time from minutes to seconds in real-world applications.<\/jats:p>","DOI":"10.14778\/3750601.3750610","type":"journal-article","created":{"date-parts":[[2025,9,16]],"date-time":"2025-09-16T13:38:05Z","timestamp":1758029885000},"page":"4860-4873","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":9,"title":["SiriusBI: A Comprehensive LLM-Powered Solution for Data Analytics in Business Intelligence"],"prefix":"10.14778","volume":"18","author":[{"given":"Jie","family":"Jiang","sequence":"first","affiliation":[{"name":"Department of Data Platform, TEG, Tencent Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Haining","family":"Xie","sequence":"additional","affiliation":[{"name":"Department of Data Platform, TEG, Tencent Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Siqi","family":"Shen","sequence":"additional","affiliation":[{"name":"Center of Machine Learning Research, Peking University"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Yu","family":"Shen","sequence":"additional","affiliation":[{"name":"Department of Data Platform, TEG, Tencent Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Zihan","family":"Zhang","sequence":"additional","affiliation":[{"name":"Department of Data Platform, TEG, Tencent Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Meng","family":"Lei","sequence":"additional","affiliation":[{"name":"Department of Data Platform, TEG, Tencent Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Yifeng","family":"Zheng","sequence":"additional","affiliation":[{"name":"Department of Data Platform, TEG, Tencent Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Yang","family":"Li","sequence":"additional","affiliation":[{"name":"Department of Data Platform, TEG, Tencent Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Chunyou","family":"Li","sequence":"additional","affiliation":[{"name":"Department of Data Platform, TEG, Tencent Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Danqing","family":"Huang","sequence":"additional","affiliation":[{"name":"Department of Data Platform, TEG, Tencent Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Yinjun","family":"Wu","sequence":"additional","affiliation":[{"name":"School of Computer Science, Peking University"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Wentao","family":"Zhang","sequence":"additional","affiliation":[{"name":"Center of Machine Learning Research, Peking University"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Bin","family":"Cui","sequence":"additional","affiliation":[{"name":"School of Computer Science, Peking University"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Peng","family":"Chen","sequence":"additional","affiliation":[{"name":"Department of Data Platform, TEG, Tencent Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2025,9,16]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"A comparative survey of recent natural language interfaces for databases. The VLDB Journal","author":"Affolter Katrin","year":"2019","unstructured":"Katrin Affolter, Kurt Stockinger, and Abraham Bernstein. 2019. A comparative survey of recent natural language interfaces for databases. The VLDB Journal (2019)."},{"key":"e_1_2_1_2_1","volume-title":"11th USENIX Symposium on Networked Systems Design and Implementation (NSDI 14)","author":"Bhagwan Ranjita","year":"2014","unstructured":"Ranjita Bhagwan, Rahul Kumar, Ramachandran Ramjee, George Varghese, Surjyakanta Mohapatra, Hemanth Manoharan, and Piyush Shah. 2014. Adtributor: Revenue debugging in advertising systems. In 11th USENIX Symposium on Networked Systems Design and Implementation (NSDI 14)."},{"key":"e_1_2_1_3_1","volume-title":"Time series analysis: forecasting and control","author":"Box George EP","unstructured":"George EP Box, Gwilym M Jenkins, Gregory C Reinsel, and Greta M Ljung. 2015. Time series analysis: forecasting and control. John Wiley & Sons."},{"key":"e_1_2_1_4_1","unstructured":"John Brooke et al. 1996. SUS-A quick and dirty usability scale. Usability evaluation in industry (1996)."},{"key":"e_1_2_1_5_1","volume-title":"E-SQL: Direct Schema Linking via Question Enrichment in Text-to-SQL. arXiv preprint arXiv:2409.16751","author":"Cafero\u011flu Hasan Alp","year":"2024","unstructured":"Hasan Alp Cafero\u011flu and \u00d6zg\u00fcr Ulusoy. 2024. E-SQL: Direct Schema Linking via Question Enrichment in Text-to-SQL. arXiv preprint arXiv:2409.16751 (2024)."},{"key":"e_1_2_1_6_1","first-page":"7664","article-title":"Sadga: Structure-aware dual graph aggregation network for text-to-sql","volume":"34","author":"Cai Ruichu","year":"2021","unstructured":"Ruichu Cai, Jinjie Yuan, Boyan Xu, and Zhifeng Hao. 2021. Sadga: Structure-aware dual graph aggregation network for text-to-sql. Advances in Neural Information Processing Systems 34 (2021), 7664\u20137676.","journal-title":"Advances in Neural Information Processing Systems"},{"key":"e_1_2_1_7_1","volume-title":"Proceedings of the 59th Annual Meeting of the Association for Computational Linguistics and the 11th International Joint Conference on Natural Language Processing. 2541\u20132555","author":"Cao Ruisheng","year":"2021","unstructured":"Ruisheng Cao, Lu Chen, Zhi Chen, Yanbin Zhao, Su Zhu, and Kai Yu. 2021. LGESQL: Line Graph Enhanced Text-to-SQL Model with Mixed Local and Non-Local Relations. In Proceedings of the 59th Annual Meeting of the Association for Computational Linguistics and the 11th International Joint Conference on Natural Language Processing. 2541\u20132555."},{"key":"e_1_2_1_8_1","volume-title":"An overview of business intelligence technology. Commun. ACM","author":"Chaudhuri Surajit","year":"2011","unstructured":"Surajit Chaudhuri, Umeshwar Dayal, and Vivek Narasayya. 2011. An overview of business intelligence technology. Commun. ACM (2011)."},{"key":"e_1_2_1_9_1","volume-title":"Bge m3-embedding: Multi-lingual, multi-functionality, multi-granularity text embeddings through self-knowledge distillation. arXiv preprint arXiv:2402.03216","author":"Chen Jianlv","year":"2024","unstructured":"Jianlv Chen, Shitao Xiao, Peitian Zhang, Kun Luo, Defu Lian, and Zheng Liu. 2024. Bge m3-embedding: Multi-lingual, multi-functionality, multi-granularity text embeddings through self-knowledge distillation. arXiv preprint arXiv:2402.03216 (2024)."},{"key":"e_1_2_1_10_1","volume-title":"Bge m3-embedding: Multi-lingual, multi-functionality, multi-granularity text embeddings through self-knowledge distillation. arXiv preprint arXiv:2402.03216","author":"Chen Jianlv","year":"2024","unstructured":"Jianlv Chen, Shitao Xiao, Peitian Zhang, Kun Luo, Defu Lian, and Zheng Liu. 2024. Bge m3-embedding: Multi-lingual, multi-functionality, multi-granularity text embeddings through self-knowledge distillation. arXiv preprint arXiv:2402.03216 (2024)."},{"key":"e_1_2_1_11_1","volume-title":"Application of business intelligence under deep neural network in credit scoring of bank users. Journal of Computational Methods in Sciences and Engineering","author":"Chen Xiaoxin","year":"2024","unstructured":"Xiaoxin Chen, Meng Wu, and Mangning Wang. 2024. Application of business intelligence under deep neural network in credit scoring of bank users. Journal of Computational Methods in Sciences and Engineering (2024)."},{"key":"e_1_2_1_12_1","volume-title":"An ontology-based business intelligence application in a financial knowledge management system. Expert Systems with Applications","author":"Cheng Hilary","year":"2009","unstructured":"Hilary Cheng, Yi-Chuan Lu, and Calvin Sheu. 2009. An ontology-based business intelligence application in a financial knowledge management system. Expert Systems with Applications (2009)."},{"key":"e_1_2_1_13_1","first-page":"309","article-title":"Ryansql: Recursively applying sketch-based slot fillings for complex text-to-sql in cross-domain databases","volume":"47","author":"Choi DongHyun","year":"2021","unstructured":"DongHyun Choi, Myeong Cheol Shin, EungGyun Kim, and Dong Ryeol Shin. 2021. Ryansql: Recursively applying sketch-based slot fillings for complex text-to-sql in cross-domain databases. Computational Linguistics 47, 2 (2021), 309\u2013332.","journal-title":"Computational Linguistics"},{"key":"e_1_2_1_14_1","unstructured":"cohere.ai Team. 2024. The Cohere Platform. https:\/\/docs.cohere.com"},{"key":"e_1_2_1_15_1","volume-title":"Proceedings of the 2019 conference of the North American chapter of the association for computational linguistics: human language technologies","volume":"1","author":"Devlin Jacob","year":"2019","unstructured":"Jacob Devlin, Ming-Wei Chang, Kenton Lee, and Kristina Toutanova. 2019. Bert: Pre-training of deep bidirectional transformers for language understanding. In Proceedings of the 2019 conference of the North American chapter of the association for computational linguistics: human language technologies, volume 1 (long and short papers)."},{"key":"e_1_2_1_16_1","unstructured":"Qingxiu Dong Lei Li Damai Dai Ce Zheng Jingyuan Ma Rui Li Heming Xia Jingjing Xu Zhiyong Wu Tianyu Liu et al. 2022. A survey on in-context learning. arXiv preprint arXiv:2301.00234 (2022)."},{"key":"e_1_2_1_17_1","unstructured":"Xuemei Dong Chao Zhang Yuhang Ge Yuren Mao Yunjun Gao Jinshu Lin Dongfang Lou et al. 2023. C3: Zero-shot text-to-sql with chatgpt. arXiv preprint arXiv:2307.07306 (2023)."},{"key":"e_1_2_1_18_1","volume-title":"software], version 6, 1","author":"Elasticsearch BV","year":"2018","unstructured":"BV Elasticsearch. 2018. Elasticsearch. software], version 6, 1 (2018)."},{"key":"e_1_2_1_19_1","unstructured":"Avrilia Floratou Fotis Psallidas Fuheng Zhao Shaleen Deep Gunther Hagleither Wangda Tan Joyce Cahoon Rana Alotaibi Jordan Henkel Abhik Singla et al. 2024. NL2SQL is a solved problem... Not!. In CIDR."},{"key":"e_1_2_1_20_1","volume-title":"Natural SQL: Making SQL Easier to Infer from Natural Language Specifications. arXiv preprint arXiv:2109.05153","author":"Gan Yujian","year":"2021","unstructured":"Yujian Gan, Xinyun Chen, Jinxia Xie, Matthew Purver, John R Woodward, John Drake, and Qiaofu Zhang. 2021. Natural SQL: Making SQL Easier to Infer from Natural Language Specifications. arXiv preprint arXiv:2109.05153 (2021)."},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.patter.2023.100839"},{"key":"e_1_2_1_22_1","volume-title":"XiYan-SQL: A Multi-Generator Ensemble Framework for Text-to-SQL. arXiv preprint arXiv:2411.08599","author":"Gao Yingqi","year":"2024","unstructured":"Yingqi Gao, Yifu Liu, Xiaoxia Li, Xiaorong Shi, Yin Zhu, Yiming Wang, Shiqi Li, Wei Li, Yuntao Hong, Zhiling Luo, Jinyang Gao, Liyu Mou, and Yu Li. 2024. XiYan-SQL: A Multi-Generator Ensemble Framework for Text-to-SQL. arXiv preprint arXiv:2411.08599 (2024)."},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10439-023-03272-4"},{"key":"e_1_2_1_24_1","volume-title":"Advances in Production Management Systems. Production Management Systems for Volatile, Uncertain, Complex, and Ambiguous Environments - 43rd IFIP WG 5.7 International Conference","author":"Hegger Marco","unstructured":"Marco Hegger and Adriana Saraceni. 2024. Smart Port Sustainability: A Business Intelligence Framework for CO2 Reduction in Cargo Truck Operations. In Advances in Production Management Systems. Production Management Systems for Volatile, Uncertain, Complex, and Ambiguous Environments - 43rd IFIP WG 5.7 International Conference, Vol. 728. 309\u2013323."},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.5555\/1315451.1315524"},{"key":"e_1_2_1_26_1","volume-title":"Proceedings of 28th International Conference on Very Large Data Bases. 670\u2013681","author":"Hristidis Vagelis","year":"2002","unstructured":"Vagelis Hristidis and Yannis Papakonstantinou. 2002. DISCOVER: Keyword Search in Relational Databases. In Proceedings of 28th International Conference on Very Large Data Bases. 670\u2013681."},{"key":"e_1_2_1_27_1","unstructured":"Binyuan Hui Jian Yang Zeyu Cui Jiaxi Yang Dayiheng Liu Lei Zhang Tianyu Liu Jiajun Zhang Bowen Yu Kai Dang et al. 2024. Qwen2. 5-Coder Technical Report. arXiv preprint arXiv:2409.12186 (2024)."},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/3219819.3219845"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.compind.2015.12.001"},{"key":"e_1_2_1_30_1","volume-title":"Proceedings of the 55th Annual Meeting of the Association for Computational Linguistics. 963\u2013973","author":"Iyer Srinivasan","year":"2017","unstructured":"Srinivasan Iyer, Ioannis Konstas, Alvin Cheung, Jayant Krishnamurthy, and Luke Zettlemoyer. 2017. Learning a Neural Semantic Parser from User Feedback. In Proceedings of the 55th Annual Meeting of the Association for Computational Linguistics. 963\u2013973."},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.5555\/645526.657278"},{"key":"e_1_2_1_32_1","volume-title":"Proceedings of the 2020 Conference on Empirical Methods in Natural Language Processing.","author":"Karpukhin Vladimir","year":"2020","unstructured":"Vladimir Karpukhin, Barlas Oguz, Sewon Min, Patrick S. H. Lewis, Ledell Wu, Sergey Edunov, Danqi Chen, and Wen-tau Yih. 2020. Dense Passage Retrieval for Open-Domain Question Answering. In Proceedings of the 2020 Conference on Empirical Methods in Natural Language Processing."},{"key":"e_1_2_1_33_1","first-page":"29","article-title":"Case Studies on Improving User Interaction and Satisfaction using AI-Enabled Chatbots for Customer Service","volume":"6","author":"Kaur Jagbir","year":"2019","unstructured":"Jagbir Kaur, Ashok Choppadandi, Pradeep Kumar Chenchala, Varun Nakra, and Pandi Kirupa Gopalakrishna Pandian. 2019. Case Studies on Improving User Interaction and Satisfaction using AI-Enabled Chatbots for Customer Service. International Journal of Transcontinental Discoveries 6, 1 (2019), 29\u201334.","journal-title":"International Journal of Transcontinental Discoveries"},{"key":"e_1_2_1_34_1","volume-title":"Unveiling factuality and injecting knowledge for LLMs via reinforcement learning and data proportion. Science China Information Sciences","author":"Ke Wenjun","year":"2024","unstructured":"Wenjun Ke, Ziyu Shang, Zhizhao Luo, Peng Wang, Yikai Guo, Qi Liu, and Yuxuan Chen. 2024. Unveiling factuality and injecting knowledge for LLMs via reinforcement learning and data proportion. Science China Information Sciences (2024)."},{"key":"e_1_2_1_35_1","volume-title":"An LLM Compiler for Parallel Function Calling. In Forty-first International Conference on Machine Learning.","author":"Kim Sehoon","year":"2024","unstructured":"Sehoon Kim, Suhong Moon, Ryan Tabrizi, Nicholas Lee, Michael W Mahoney, Kurt Keutzer, and Amir Gholami. 2024. An LLM Compiler for Parallel Function Calling. In Forty-first International Conference on Machine Learning."},{"key":"e_1_2_1_36_1","unstructured":"David Pidsley Julian Sun Georgia O'Callaghan Christopher Long Kevin Quinn Fay Fei Edgar Macari Jamie O'Brien Kurt Schlegel Anirudh Ganeshan. 2023. Magic Quadrant for Analytics and Business Intelligence Platforms. https:\/\/www.gartner.com\/doc\/reprints?id=1-2HW1JC8Q&ct=240620"},{"key":"e_1_2_1_37_1","doi-asserted-by":"crossref","first-page":"1","DOI":"10.47654\/v26y2022i1p1-30","article-title":"Predictive analytics in business analytics: decision tree","volume":"26","author":"Lee Chee Sun","year":"2022","unstructured":"Chee Sun Lee, Peck Yeng Sharon Cheang, and Massoud Moslehpour. 2022. Predictive analytics in business analytics: decision tree. Advances in Decision Sciences 26, 1 (2022), 1\u201329.","journal-title":"Advances in Decision Sciences"},{"key":"e_1_2_1_38_1","first-page":"3318","article-title":"The Dawn of Natural Language to SQL: Are We Fully Ready? [Experiment, Analysis \\u0026 Benchmark]","volume":"17","author":"Li Boyan","year":"2024","unstructured":"Boyan Li, Yuyu Luo, Chengliang Chai, Guoliang Li, and Nan Tang. 2024. The Dawn of Natural Language to SQL: Are We Fully Ready? [Experiment, Analysis \\u0026 Benchmark]. Proceedings of the Very Large Data Bases Endowment 17, 11 (2024), 3318\u20133331.","journal-title":"Proceedings of the Very Large Data Bases Endowment"},{"key":"e_1_2_1_39_1","volume-title":"SEA-SQL: Semantic-Enhanced Text-to-SQL with Adaptive Refinement. arXiv preprint arXiv:2408.04919","author":"Li Chaofan","year":"2024","unstructured":"Chaofan Li, Yingxia Shao, and Zheng Liu. 2024. SEA-SQL: Semantic-Enhanced Text-to-SQL with Adaptive Refinement. arXiv preprint arXiv:2408.04919 (2024)."},{"key":"e_1_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.14778\/2735461.2735468"},{"key":"e_1_2_1_41_1","doi-asserted-by":"crossref","unstructured":"Guoliang Li Jiang Wang and Guo Chen. 2024. openGauss: An Enterprise-Grade Open-Source Database System. J. Comput. Sci. Technol. (2024).","DOI":"10.1007\/s11390-024-4302-2"},{"key":"e_1_2_1_42_1","doi-asserted-by":"publisher","DOI":"10.1145\/3654930"},{"key":"e_1_2_1_43_1","volume-title":"Advances in Neural Information Processing Systems 36: Annual Conference on Neural Information Processing Systems","author":"Li Jinyang","year":"2023","unstructured":"Jinyang Li, Binyuan Hui, Ge Qu, Jiaxi Yang, Binhua Li, Bowen Li, Bailin Wang, Bowen Qin, Ruiying Geng, Nan Huo, Xuanhe Zhou, Chenhao Ma, Guoliang Li, Kevin Chen-Chuan Chang, Fei Huang, Reynold Cheng, and Yongbin Li. 2023. Can LLM Already Serve as A Database Interface? A BIg Bench for Large-Scale Database Grounded Text-to-SQLs. In Advances in Neural Information Processing Systems 36: Annual Conference on Neural Information Processing Systems 2023."},{"key":"e_1_2_1_44_1","volume-title":"opengauss: An open-source database for the era of artificial intelligence. Journal of Computer Science and Technology","author":"Jian-Zhong Li.","year":"2024","unstructured":"Jian-Zhong Li. 2024. opengauss: An open-source database for the era of artificial intelligence. Journal of Computer Science and Technology (2024)."},{"key":"e_1_2_1_45_1","volume-title":"2019 IEEE 30th International Symposium on Software Reliability Engineering (ISSRE).","author":"Li Zeyan","year":"2019","unstructured":"Zeyan Li, Chengyang Luo, Yiwei Zhao, Yongqian Sun, Kaixin Sui, Xiping Wang, Dapeng Liu, Xing Jin, Qi Wang, and Dan Pei. 2019. Generic and robust localization of multi-dimensional root causes. In 2019 IEEE 30th International Symposium on Software Reliability Engineering (ISSRE)."},{"key":"e_1_2_1_46_1","volume-title":"ChatBI: Towards Natural Language to Complex Business Intelligence SQL. arXiv preprint arXiv:2405.00527","author":"Lian Jinqing","year":"2024","unstructured":"Jinqing Lian, Xinyi Liu, Yingxia Shao, Yang Dong, Ming Wang, Zhang Wei, Tianqi Wan, Ming Dong, and Hailin Yan. 2024. ChatBI: Towards Natural Language to Complex Business Intelligence SQL. arXiv preprint arXiv:2405.00527 (2024)."},{"key":"e_1_2_1_47_1","doi-asserted-by":"crossref","first-page":"225","DOI":"10.32996\/jcsts.2024.6.1.26","article-title":"Advancements and applications of generative artificial intelligence and large language models on business management: A comprehensive review","volume":"6","author":"Linkon Ahmed Ali","year":"2024","unstructured":"Ahmed Ali Linkon, Mujiba Shaima, Md Shohail Uddin Sarker, Norun Nabi, Md Nasir Uddin Rana, Sandip Kumar Ghosh, Mohammad Anisur Rahman, Hammed Esa, Faiaz Rahat Chowdhury, et al. 2024. Advancements and applications of generative artificial intelligence and large language models on business management: A comprehensive review. Journal of Computer Science and Technology Studies 6, 1 (2024), 225\u2013232.","journal-title":"Journal of Computer Science and Technology Studies"},{"key":"e_1_2_1_48_1","volume-title":"A Survey of NL2SQL with Large Language Models: Where are we, and where are we going? arXiv preprint arXiv:2408.05109","author":"Liu Xinyu","year":"2024","unstructured":"Xinyu Liu, Shuyu Shen, Boyan Li, Peixian Ma, Runzhi Jiang, Yuyu Luo, Yuxin Zhang, Ju Fan, Guoliang Li, and Nan Tang. 2024. A Survey of NL2SQL with Large Language Models: Where are we, and where are we going? arXiv preprint arXiv:2408.05109 (2024)."},{"key":"e_1_2_1_49_1","volume-title":"A unified approach to interpreting model predictions. Advances in neural information processing systems 30","author":"Lundberg Scott M","year":"2017","unstructured":"Scott M Lundberg and Su-In Lee. 2017. A unified approach to interpreting model predictions. Advances in neural information processing systems 30 (2017)."},{"key":"e_1_2_1_50_1","volume-title":"Proceedings of the International Conference on Management of Data. ACM, 115\u2013126","author":"Luo Yi","year":"2007","unstructured":"Yi Luo, Xuemin Lin, Wei Wang, and Xiaofang Zhou. 2007. Spark: top-k keyword query in relational databases. In Proceedings of the International Conference on Management of Data. ACM, 115\u2013126."},{"key":"e_1_2_1_51_1","volume-title":"Text-to-SQL in the Age of Well-Reasoned Language Models. In NeurIPS 2024 Third Table Representation Learning Workshop.","author":"Maamari Karime","year":"2024","unstructured":"Karime Maamari, Fadhil Abubaker, Daniel Jaroslawicz, and Amine Mhedhbi. 2024. The Death of Schema Linking? Text-to-SQL in the Age of Well-Reasoned Language Models. In NeurIPS 2024 Third Table Representation Learning Workshop."},{"key":"e_1_2_1_52_1","volume-title":"BI-REC: guided data analysis for conversational business intelligence. arXiv preprint arXiv:2105.00467","author":"Meduri Venkata Vamsikrishna","year":"2021","unstructured":"Venkata Vamsikrishna Meduri, Abdul Quamar, Chuan Lei, Vasilis Efthymiou, and Fatma Ozcan. 2021. BI-REC: guided data analysis for conversational business intelligence. arXiv preprint arXiv:2105.00467 (2021)."},{"key":"e_1_2_1_53_1","volume-title":"Pathways language model (palm): Scaling to 540 billion parameters for breakthrough performance. Google AI Blog","author":"Narang Sharan","year":"2022","unstructured":"Sharan Narang and Aakanksha Chowdhery. 2022. Pathways language model (palm): Scaling to 540 billion parameters for breakthrough performance. Google AI Blog (2022)."},{"key":"e_1_2_1_54_1","first-page":"177","article-title":"Business Intelligence","volume":"177","author":"Negash Solomon","year":"2004","unstructured":"Solomon Negash. 2004. Business Intelligence. Communications of the Association for Information Systems 177, 195 (2004), 177.","journal-title":"Communications of the Association for Information Systems"},{"key":"e_1_2_1_55_1","volume-title":"Designing business intelligence (BI) for production, distribution and customer services: a case study of a UAE-based organization. Business Process Management Journal","author":"Nuseir Mohammed T","year":"2021","unstructured":"Mohammed T Nuseir. 2021. Designing business intelligence (BI) for production, distribution and customer services: a case study of a UAE-based organization. Business Process Management Journal (2021)."},{"key":"e_1_2_1_56_1","doi-asserted-by":"publisher","DOI":"10.3115\/1220355.1220376"},{"key":"e_1_2_1_57_1","volume-title":"Yu Gan, Amin Saberi, Fatma Ozcan, and Sercan O Arik.","author":"Pourreza Mohammadreza","year":"2024","unstructured":"Mohammadreza Pourreza, Hailong Li, Ruoxi Sun, Yeounoh Chung, Shayan Talaei, Gaurav Tarlok Kakkar, Yu Gan, Amin Saberi, Fatma Ozcan, and Sercan O Arik. 2024. CHASE-SQL: Multi-Path Reasoning and Preference Optimized Candidate Selection in Text-to-SQL. arXiv preprint arXiv:2410.01943 (2024)."},{"key":"e_1_2_1_58_1","volume-title":"DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correction. In Advances in Neural Information Processing Systems 36: Annual Conference on Neural Information Processing Systems","author":"Pourreza Mohammadreza","year":"2023","unstructured":"Mohammadreza Pourreza and Davood Rafiei. 2023. DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correction. In Advances in Neural Information Processing Systems 36: Annual Conference on Neural Information Processing Systems 2023."},{"key":"e_1_2_1_59_1","volume-title":"DTS-SQL: Decomposed Text-to-SQL with Small Large Language Models. arXiv preprint arXiv:2402.01117","author":"Pourreza Mohammadreza","year":"2024","unstructured":"Mohammadreza Pourreza and Davood Rafiei. 2024. DTS-SQL: Decomposed Text-to-SQL with Small Large Language Models. arXiv preprint arXiv:2402.01117 (2024)."},{"key":"e_1_2_1_60_1","unstructured":"Xiaoru Qu Yifan Wang Zhao Li and Jun Gao. 2024. Graph-Enhanced Prompt Learning for Personalized Review Generation. Data Sci. Eng. (2024)."},{"key":"e_1_2_1_61_1","unstructured":"Alec Radford Jeffrey Wu Rewon Child David Luan Dario Amodei Ilya Sutskever et al. 2019. Language models are unsupervised multitask learners. OpenAI blog (2019)."},{"key":"e_1_2_1_62_1","volume-title":"Business Intelligence and Business Analytics With Artificial Intelligence and Machine Learning: Trends, Techniques, and Opportunities. Techniques, and Opportunities","author":"Rane Nitin","year":"2024","unstructured":"Nitin Rane, Mallikarjuna Paramesha, Saurabh Choudhary, and Jayesh Rane. 2024. Business Intelligence and Business Analytics With Artificial Intelligence and Machine Learning: Trends, Techniques, and Opportunities. Techniques, and Opportunities (2024)."},{"key":"e_1_2_1_63_1","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/D19-1410"},{"key":"e_1_2_1_64_1","doi-asserted-by":"crossref","unstructured":"Kevin Mej\u00eda Rivera. 2024. Developing a Media Watcher Through Business Intelligence Tools: An Approach for Emerging Media Industries. In Gaming Entertainment and Media Conference. 1\u20134.","DOI":"10.1109\/GEM61861.2024.10585486"},{"key":"e_1_2_1_65_1","volume-title":"Relevance Weighting of Search Terms. Journal of the American Society for Information Science","author":"Robertson SE","year":"1976","unstructured":"SE Robertson and K Sparck Jones. 1976. Relevance Weighting of Search Terms. Journal of the American Society for Information Science (1976)."},{"key":"e_1_2_1_66_1","unstructured":"Ruoxi Sun Sercan \u00d6 Arik Alex Muzio Lesly Miculicich Satya Gundabathula Pengcheng Yin Hanjun Dai Hootan Nakhost Rajarishi Sinha Zifeng Wang et al. 2023. SQL-PaLM: Improved Large Language Model Adaptation for Text-to-SQL (extended). arXiv preprint arXiv:2306.00739 (2023)."},{"key":"e_1_2_1_67_1","volume-title":"Ernie: Enhanced representation through knowledge integration. arXiv preprint arXiv:1904.09223","author":"Sun Yu","year":"2019","unstructured":"Yu Sun, Shuohuan Wang, Yukun Li, Shikun Feng, Xuyi Chen, Han Zhang, Xin Tian, Danxiang Zhu, Hao Tian, and Hua Wu. 2019. Ernie: Enhanced representation through knowledge integration. arXiv preprint arXiv:1904.09223 (2019)."},{"key":"e_1_2_1_68_1","volume-title":"CHESS: Contextual Harnessing for Efficient SQL Synthesis. arXiv preprint arXiv:2405.16755","author":"Talaei Shayan","year":"2024","unstructured":"Shayan Talaei, Mohammadreza Pourreza, Yu-Chen Chang, Azalia Mirhoseini, and Amin Saberi. 2024. CHESS: Contextual Harnessing for Efficient SQL Synthesis. arXiv preprint arXiv:2405.16755 (2024)."},{"key":"e_1_2_1_69_1","volume-title":"2021 2nd International Conference on Intelligent Engineering and Management. 63\u201368","author":"Tamang Minsang D","year":"2021","unstructured":"Minsang D Tamang, Vinod Kumar Shukla, Shaista Anwar, and Ritu Punhani. 2021. Improving business intelligence through machine learning algorithms. In 2021 2nd International Conference on Intelligent Engineering and Management. 63\u201368."},{"key":"e_1_2_1_70_1","unstructured":"Claude Team. 2024. Claude3. https:\/\/anthropic.com\/claude"},{"key":"e_1_2_1_71_1","unstructured":"Gemini Team Rohan Anil Sebastian Borgeaud Jean-Baptiste Alayrac Jiahui Yu Radu Soricut Johan Schalkwyk Andrew M Dai Anja Hauth Katie Millican et al. 2023. Gemini: a family of highly capable multimodal models. arXiv preprint arXiv:2312.11805 (2023)."},{"key":"e_1_2_1_72_1","unstructured":"OpenAI team. 2022. Introduction of OpenAI Text Generation APIs. https:\/\/platform.openai.com\/docs\/guides\/text-generation"},{"key":"e_1_2_1_73_1","unstructured":"OpenAI team. 2023. OpenAI CodeX. https:\/\/openai.com\/index\/openai-codex"},{"key":"e_1_2_1_74_1","unstructured":"StarRocks team. 2023. StarRocks. https:\/\/github.com\/StarRocks\/starrocks"},{"key":"e_1_2_1_75_1","volume-title":"MAC-SQL: A Multi-Agent Collaborative Framework for Text-to-SQL. arXiv preprint arXiv:2312.11242","author":"Wang Bing","year":"2023","unstructured":"Bing Wang, Changyu Ren, Jian Yang, Xinnian Liang, Jiaqi Bai, Qian-Wen Zhang, Zhao Yan, and Zhoujun Li. 2023. MAC-SQL: A Multi-Agent Collaborative Framework for Text-to-SQL. arXiv preprint arXiv:2312.11242 (2023)."},{"key":"e_1_2_1_76_1","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2020.acl-main.677"},{"key":"e_1_2_1_77_1","doi-asserted-by":"publisher","DOI":"10.1145\/3062341.3062365"},{"key":"e_1_2_1_78_1","volume-title":"Multilingual e5 text embeddings: A technical report. arXiv preprint arXiv:2402.05672","author":"Wang Liang","year":"2024","unstructured":"Liang Wang, Nan Yang, Xiaolong Huang, Linjun Yang, Rangan Majumder, and Furu Wei. 2024. Multilingual e5 text embeddings: A technical report. arXiv preprint arXiv:2402.05672 (2024)."},{"key":"e_1_2_1_79_1","volume-title":"Proceedings of the 61st Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers).","author":"Wang Yizhong","year":"2023","unstructured":"Yizhong Wang, Yeganeh Kordi, Swaroop Mishra, Alisa Liu, Noah A Smith, Daniel Khashabi, and Hannaneh Hajishirzi. 2023. Self-Instruct: Aligning Language Models with Self-Generated Instructions. In Proceedings of the 61st Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers)."},{"key":"e_1_2_1_80_1","volume-title":"Generalizing from a few examples: A survey on few-shot learning. ACM computing surveys (csur)","author":"Wang Yaqing","year":"2020","unstructured":"Yaqing Wang, Quanming Yao, James T Kwok, and Lionel M Ni. 2020. Generalizing from a few examples: A survey on few-shot learning. ACM computing surveys (csur) (2020)."},{"key":"e_1_2_1_81_1","doi-asserted-by":"publisher","DOI":"10.5555\/3600270.3602070"},{"key":"e_1_2_1_82_1","doi-asserted-by":"publisher","DOI":"10.1145\/3318464.3380589"},{"key":"e_1_2_1_83_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.procs.2015.08.599"},{"key":"e_1_2_1_84_1","volume-title":"Data augmentation with hierarchical SQL-to-question generation for cross-domain text-to-SQL parsing. arXiv preprint arXiv:2103.02227","author":"Wu Kun","year":"2021","unstructured":"Kun Wu, Lijie Wang, Zhenghua Li, Ao Zhang, Xinyan Xiao, Hua Wu, Min Zhang, and Haifeng Wang. 2021. Data augmentation with hierarchical SQL-to-question generation for cross-domain text-to-SQL parsing. arXiv preprint arXiv:2103.02227 (2021)."},{"key":"e_1_2_1_85_1","unstructured":"An Yang Baosong Yang Beichen Zhang Binyuan Hui Bo Zheng Bowen Yu Chengyuan Li Dayiheng Liu Fei Huang Haoran Wei et al. 2024. Qwen2. 5 technical report. arXiv preprint arXiv:2412.15115 (2024)."},{"key":"e_1_2_1_86_1","volume-title":"International Conference on Learning Representations (ICLR).","author":"Yao Shunyu","year":"2023","unstructured":"Shunyu Yao, Jeffrey Zhao, Dian Yu, Nan Du, Izhak Shafran, Karthik Narasimhan, and Yuan Cao. 2023. React: Synergizing reasoning and acting in language models. In International Conference on Learning Representations (ICLR)."},{"key":"e_1_2_1_87_1","volume-title":"Proceedings of the 19th International Conference on Extending Database Technology. 161\u2013172","author":"Zeng Zhong","year":"2016","unstructured":"Zhong Zeng, Mong-Li Lee, and Tok Wang Ling. 2016. Answering Keyword Queries involving Aggregates and GROUPBY on Relational Databases. In Proceedings of the 19th International Conference on Extending Database Technology. 161\u2013172."},{"key":"e_1_2_1_88_1","volume-title":"Proceedings of the 2023 Conference on Empirical Methods in Natural Language Processing: System Demonstrations.","author":"Zhang Baoli","year":"2023","unstructured":"Baoli Zhang, Haining Xie, Pengfan Du, Junhao Chen, Pengfei Cao, Yubo Chen, Shengping Liu, Kang Liu, and Jun Zhao. 2023. ZhuJiu: A Multi-dimensional, Multi-faceted Chinese Benchmark for Large Language Models. In Proceedings of the 2023 Conference on Empirical Methods in Natural Language Processing: System Demonstrations."},{"key":"e_1_2_1_89_1","volume-title":"SpikingMiniLM: energy-efficient spiking transformer for natural language understanding. Science China Information Sciences","author":"Zhang Jiayu","year":"2024","unstructured":"Jiayu Zhang, Jiangrong Shen, Zeke Wang, Qinghai Guo, Rui Yan, Gang Pan, and Huajin Tang. 2024. SpikingMiniLM: energy-efficient spiking transformer for natural language understanding. Science China Information Sciences (2024)."},{"key":"e_1_2_1_90_1","volume-title":"Sciencebenchmark: A complex real-world benchmark for evaluating natural language to sql systems. arXiv preprint arXiv:2306.04743","author":"Zhang Yi","year":"2023","unstructured":"Yi Zhang, Jan Deriu, George Katsogiannis-Meimarakis, Catherine Kosten, Georgia Koutrika, and Kurt Stockinger. 2023. Sciencebenchmark: A complex real-world benchmark for evaluating natural language to sql systems. arXiv preprint arXiv:2306.04743 (2023)."},{"key":"e_1_2_1_91_1","volume-title":"Db-gpt: Large language model meets database. Data Science and Engineering","author":"Zhou Xuanhe","year":"2024","unstructured":"Xuanhe Zhou, Zhaoyan Sun, and Guoliang Li. 2024. Db-gpt: Large language model meets database. Data Science and Engineering (2024)."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3750601.3750610","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,16]],"date-time":"2025-09-16T13:40:24Z","timestamp":1758030024000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3750601.3750610"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,8]]},"references-count":91,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2025,8]]}},"alternative-id":["10.14778\/3750601.3750610"],"URL":"https:\/\/doi.org\/10.14778\/3750601.3750610","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2025,8]]},"assertion":[{"value":"2025-09-16","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}