{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,8]],"date-time":"2026-03-08T20:20:22Z","timestamp":1773001222943,"version":"3.50.1"},"reference-count":40,"publisher":"Wiley","issue":"1","license":[{"start":{"date-parts":[[2025,3,26]],"date-time":"2025-03-26T00:00:00Z","timestamp":1742947200000},"content-version":"vor","delay-in-days":84,"URL":"http:\/\/creativecommons.org\/licenses\/by\/4.0\/"},{"start":{"date-parts":[[2025,1,1]],"date-time":"2025-01-01T00:00:00Z","timestamp":1735689600000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/doi.wiley.com\/10.1002\/tdm_license_1.1"}],"funder":[{"DOI":"10.13039\/501100007957","name":"Chongqing Municipal Education Commission","doi-asserted-by":"publisher","award":["KJZD-M202300703"],"award-info":[{"award-number":["KJZD-M202300703"]}],"id":[{"id":"10.13039\/501100007957","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/501100007957","name":"Chongqing Municipal Education Commission","doi-asserted-by":"publisher","award":["KJQN202200720"],"award-info":[{"award-number":["KJQN202200720"]}],"id":[{"id":"10.13039\/501100007957","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/501100005230","name":"Natural Science Foundation of Chongqing Municipality","doi-asserted-by":"publisher","award":["CSTB2023NSCQ-MSX0145"],"award-info":[{"award-number":["CSTB2023NSCQ-MSX0145"]}],"id":[{"id":"10.13039\/501100005230","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/501100012459","name":"Chongqing Graduate Student Research Innovation Project","doi-asserted-by":"publisher","award":["CYS240499"],"award-info":[{"award-number":["CYS240499"]}],"id":[{"id":"10.13039\/501100012459","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["onlinelibrary.wiley.com"],"crossmark-restriction":true},"short-container-title":["International Journal of Intelligent Systems"],"published-print":{"date-parts":[[2025,1]]},"abstract":"<jats:p>Intelligent question answering over industrial databases is a challenging task due to the multicolumn context and complex questions. The existing methods need to be improved in terms of SQL generation accuracy. In this paper, we propose a question\u2010aware few\u2010shot Text\u2010to\u2010SQL approach based on the SDCUP pretrained model. Specifically, an attention\u2010based filtering approach is proposed to reduce the redundant information from multiple columns in the industrial database scenario. We further propose an operator semantics enhancement method to improve the ability of identifying complex conditions in queries. Experimental results on the industrial benchmarks in the fields of electric energy and structural inspection show that the proposed model outperforms the baseline models across all few\u2010shot settings.<\/jats:p>","DOI":"10.1155\/int\/8124797","type":"journal-article","created":{"date-parts":[[2025,3,29]],"date-time":"2025-03-29T15:29:09Z","timestamp":1743262149000},"update-policy":"https:\/\/doi.org\/10.1002\/crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["A Question\u2010Aware Few\u2010Shot Text\u2010to\u2010SQL Neural Model for Industrial Databases"],"prefix":"10.1155","volume":"2025","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-7681-484X","authenticated-orcid":false,"given":"Ren","family":"Li","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0004-6927-3952","authenticated-orcid":false,"given":"Yu","family":"Chen","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0006-8210-0620","authenticated-orcid":false,"given":"Hongyi","family":"Zhang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-2801-583X","authenticated-orcid":false,"given":"Jianxi","family":"Yang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-9554-7954","authenticated-orcid":false,"given":"Qiao","family":"Xiao","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-5168-6597","authenticated-orcid":false,"given":"Shixin","family":"Jiang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"311","published-online":{"date-parts":[[2025,3,26]]},"reference":[{"key":"e_1_2_10_1_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.aei.2022.101629"},{"key":"e_1_2_10_2_2","doi-asserted-by":"publisher","DOI":"10.1002\/int.22955"},{"key":"e_1_2_10_3_2","doi-asserted-by":"publisher","DOI":"10.1609\/aaai.v35i5.16519"},{"key":"e_1_2_10_4_2","doi-asserted-by":"publisher","DOI":"10.1109\/tii.2020.2967561"},{"key":"e_1_2_10_5_2","doi-asserted-by":"publisher","DOI":"10.1109\/tii.2021.3079521"},{"key":"e_1_2_10_6_2","doi-asserted-by":"publisher","DOI":"10.1109\/tii.2021.3097183"},{"key":"e_1_2_10_7_2","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-022-00776-8"},{"key":"e_1_2_10_8_2","doi-asserted-by":"crossref","unstructured":"XuS. SemnaniS. J. CampagnaG. LamM. S. andAutoQA From Databases to QA Semantic Parsers with Only Synthetic Training Data Proceedings of the 2020 Conference on Empirical Methods in Natural Language Processing (EMNLP) June 2020 422\u2013434.","DOI":"10.18653\/v1\/2020.emnlp-main.31"},{"key":"e_1_2_10_9_2","doi-asserted-by":"crossref","unstructured":"DengX. AwadallahA. H. MeekC. PolozovS. H. andRichardsonM. Structure-Grounded Pretraining for Text-To-SQL Proceedings of the 2021 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies April 2021 1337\u20131350.","DOI":"10.18653\/v1\/2021.naacl-main.105"},{"key":"e_1_2_10_10_2","unstructured":"ChatGPT 2022."},{"key":"e_1_2_10_11_2","article-title":"Llama: Open and Efficient Foundation Language Models","author":"Touvron H.","year":"2023","journal-title":"CoRR"},{"key":"e_1_2_10_12_2","article-title":"Baichuan 2: Open Large-Scale Language Models","author":"Yang A.","year":"2023","journal-title":"arXiv preprint arXiv:2309.10305"},{"key":"e_1_2_10_13_2","unstructured":"ZhaoW. X. ZhouK. LiJ.et al. A Survey of Large Language Models 2023."},{"key":"e_1_2_10_14_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.aei.2023.102333"},{"key":"e_1_2_10_15_2","article-title":"Seq2sql: Generating Structured Queries from Natural Language Using Reinforcement Learning","author":"Zhong V.","year":"2017","journal-title":"arXiv preprint arXiv:1709.00103"},{"key":"e_1_2_10_16_2","article-title":"Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-To-Sql Task","author":"Yu T.","year":"2018","journal-title":"arXiv preprint arXiv:1809.08887"},{"key":"e_1_2_10_17_2","article-title":"Sparc: Cross-Domain Semantic Parsing in Context","author":"Yu T.","year":"2019","journal-title":"arXiv preprint arXiv:1906.02285"},{"key":"e_1_2_10_18_2","doi-asserted-by":"publisher","DOI":"10.1109\/tii.2019.2952929"},{"key":"e_1_2_10_19_2","doi-asserted-by":"publisher","DOI":"10.1002\/int.22508"},{"key":"e_1_2_10_20_2","volume-title":"Improving Text-To-SQL with Schema Dependency Learning","author":"Hui B.","year":"2021"},{"key":"e_1_2_10_21_2","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2020.findings-emnlp.438"},{"key":"e_1_2_10_22_2","doi-asserted-by":"publisher","DOI":"10.1007\/s11042-022-12573-0"},{"key":"e_1_2_10_23_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.aei.2022.101704"},{"key":"e_1_2_10_24_2","volume-title":"Enhancing Text-To-SQL Capabilities of Large Language Models: A Study on Prompt Design Strategies","author":"Nan L.","year":"2023"},{"key":"e_1_2_10_25_2","volume-title":"SQLPrompt: In-Context Text-To-SQL with Minimal Labeled Data","author":"Sun R.","year":"2023"},{"key":"e_1_2_10_26_2","volume-title":"SEQZERO: Few-Shot Compositional Semantic Parsing with Sequential Prompts and Zero-Shot Models","author":"Yang J.","year":"2022"},{"key":"e_1_2_10_27_2","doi-asserted-by":"publisher","DOI":"10.1145\/3589292"},{"key":"e_1_2_10_28_2","doi-asserted-by":"crossref","unstructured":"ShinR. LinC. ThomsonS.et al. Constrained Language Models Yield Few-Shot Semantic Parsers Proceedings of the 2021 Conference on Empirical Methods in Natural Language Processing August 2021 7699\u20137715.","DOI":"10.18653\/v1\/2021.emnlp-main.608"},{"key":"e_1_2_10_29_2","doi-asserted-by":"crossref","unstructured":"SchucherN. ReddyS. andde VriesH. The Power of Prompt Tuning for Low-Resource Semantic Parsing Proceedings of the 60th Annual Meeting of the Association for Computational Linguistics (Volume 2: Short Papers) September 2022 148\u2013156.","DOI":"10.18653\/v1\/2022.acl-short.17"},{"key":"e_1_2_10_30_2","doi-asserted-by":"publisher","DOI":"10.1609\/aaai.v34i05.6246"},{"key":"e_1_2_10_31_2","doi-asserted-by":"crossref","unstructured":"ZhongV. LewisM. WangS. I. andZettlemoyerL. Grounded Adaptation for Zero-Shot Executable Semantic Parsing[C] Proceedings of the 2020 Conference on Empirical Methods in Natural Language Processing (EMNLP) May 2020 6869\u20136882.","DOI":"10.18653\/v1\/2020.emnlp-main.558"},{"key":"e_1_2_10_32_2","article-title":"A Comprehensive Exploration on Wikisql with Table-Aware Word Contextualization","author":"Hwang W.","year":"2019","journal-title":"arXiv preprint arXiv:1902.01069"},{"key":"e_1_2_10_33_2","doi-asserted-by":"publisher","DOI":"10.1609\/aaai.v37i11.26492"},{"key":"e_1_2_10_34_2","first-page":"4150","article-title":"Improving Few-Shot Text-To-SQL with Meta Self-Training via Column Specificity[C]","author":"Guo X.","year":"2022","journal-title":"IJCAI"},{"key":"e_1_2_10_35_2","article-title":"Hybrid Ranking Network for Text-To-Sql","author":"Lyu Q.","year":"2020","journal-title":"arXiv preprint arXiv:2008.04759"},{"key":"e_1_2_10_36_2","article-title":"SQLfuse: Enhancing Text-To-SQL Performance through Comprehensive LLM Synergy","author":"Zhang T.","year":"2024","journal-title":"arXiv preprint arXiv:2407.14568"},{"key":"e_1_2_10_37_2","article-title":"XiYan-SQL: A Multi-Generator Ensemble Framework for Text-To-SQL","author":"Gao Y.","year":"2024","journal-title":"arXiv preprint arXiv:2411.08599"},{"key":"e_1_2_10_38_2","first-page":"2996","article-title":"Chinese Text-To-SQL Model for Industrial Production","volume":"42","author":"Lyu J.","year":"2022","journal-title":"Journal of Computer Applications"},{"key":"e_1_2_10_39_2","volume-title":"Vicuna: An Open-Source Chatbot Impressing Gpt-4","author":"Chiang W. L.","year":"2023"},{"key":"e_1_2_10_40_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.knosys.2023.110264"}],"container-title":["International Journal of Intelligent Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/pdf\/10.1155\/int\/8124797","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/full-xml\/10.1155\/int\/8124797","content-type":"application\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/pdf\/10.1155\/int\/8124797","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,3,8]],"date-time":"2026-03-08T17:55:59Z","timestamp":1772992559000},"score":1,"resource":{"primary":{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/10.1155\/int\/8124797"}},"subtitle":[],"editor":[{"given":"Alexander","family":"Ho\u0161ovsk\u00fd","sequence":"additional","affiliation":[],"role":[{"role":"editor","vocabulary":"crossref"}]}],"short-title":[],"issued":{"date-parts":[[2025,1]]},"references-count":40,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2025,1]]}},"alternative-id":["10.1155\/int\/8124797"],"URL":"https:\/\/doi.org\/10.1155\/int\/8124797","archive":["Portico"],"relation":{},"ISSN":["0884-8173","1098-111X"],"issn-type":[{"value":"0884-8173","type":"print"},{"value":"1098-111X","type":"electronic"}],"subject":[],"published":{"date-parts":[[2025,1]]},"assertion":[{"value":"2024-04-12","order":0,"name":"received","label":"Received","group":{"name":"publication_history","label":"Publication History"}},{"value":"2025-03-08","order":2,"name":"accepted","label":"Accepted","group":{"name":"publication_history","label":"Publication History"}},{"value":"2025-03-26","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}],"article-number":"8124797"}}