{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,5,21]],"date-time":"2025-05-21T04:24:00Z","timestamp":1747801440656,"version":"3.41.0"},"publisher-location":"Cham","reference-count":31,"publisher":"Springer Nature Switzerland","isbn-type":[{"value":"9783031896200","type":"print"},{"value":"9783031896217","type":"electronic"}],"license":[{"start":{"date-parts":[[2025,1,1]],"date-time":"2025-01-01T00:00:00Z","timestamp":1735689600000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2025,1,1]],"date-time":"2025-01-01T00:00:00Z","timestamp":1735689600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2025]]},"DOI":"10.1007\/978-3-031-89621-7_8","type":"book-chapter","created":{"date-parts":[[2025,5,20]],"date-time":"2025-05-20T13:13:42Z","timestamp":1747746822000},"page":"151-167","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["On the\u00a0Construction of\u00a0Text-to-SQL Tools Based on\u00a0Large Language Models for\u00a0Real-World Relational Databases"],"prefix":"10.1007","author":[{"ORCID":"https:\/\/orcid.org\/0009-0005-3391-7813","authenticated-orcid":false,"given":"Eduardo","family":"Nascimento","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-2951-4972","authenticated-orcid":false,"given":"Gustavo","family":"Coelho","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0006-4763-8564","authenticated-orcid":false,"given":"Lucas","family":"Feij\u00f3","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-0971-8572","authenticated-orcid":false,"given":"Yenier","family":"Izquierdo","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-9713-300X","authenticated-orcid":false,"given":"Grettel","family":"Garc\u00eda","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0001-8970-0454","authenticated-orcid":false,"given":"Aiko","family":"Oliveira","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-0909-4432","authenticated-orcid":false,"given":"Jo\u00e3o","family":"Pinheiro","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0007-9459-8216","authenticated-orcid":false,"given":"Antony","family":"Seabra","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-3710-624X","authenticated-orcid":false,"given":"Antonio","family":"Furtado","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-6014-7256","authenticated-orcid":false,"given":"Luiz Paes","family":"Leme","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-1723-9897","authenticated-orcid":false,"given":"Melissa","family":"Lemos","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-0765-9636","authenticated-orcid":false,"given":"Marco","family":"Casanova","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2025,5,21]]},"reference":[{"issue":"5","key":"8_CR1","doi-asserted-by":"publisher","first-page":"793","DOI":"10.1007\/s00778-019-00567-8","volume":"28","author":"K Affolter","year":"2019","unstructured":"Affolter, K., Stockinger, K., Bernstein, A.: A comparative survey of recent natural language interfaces for databases. VLDB J. 28(5), 793\u2013819 (2019). https:\/\/doi.org\/10.1007\/s00778-019-00567-8","journal-title":"VLDB J."},{"key":"8_CR2","doi-asserted-by":"publisher","unstructured":"Askell, A., et al.: A general language assistant as a laboratory for alignment. arXiv (2021). https:\/\/doi.org\/10.48550\/arXiv.2112.00861","DOI":"10.48550\/arXiv.2112.00861"},{"key":"8_CR3","doi-asserted-by":"publisher","unstructured":"Caldarini, G., Jaf, S., McGarry, K.: A literature survey of recent advances in chatbots. Information 13(1) (2022). https:\/\/doi.org\/10.3390\/info13010041, https:\/\/www.mdpi.com\/2078-2489\/13\/1\/41","DOI":"10.3390\/info13010041"},{"key":"8_CR4","doi-asserted-by":"publisher","unstructured":"Coelho, G.M.C., et al.: Improving the Accuracy of Text-to-SQL Tools Based on Large Language Models for Real-World Relational Databases. In: Strauss, C., Amagasa, T., Manco, G., Kotsis, G., Tjoa, A.M., Khalil, I. (eds.) Database and Expert Systems Applications. DEXA 2024. Lecture Notes in Computer Science, vol. 14910, pp. 93\u2013107. Springer, Cham (2024). https:\/\/doi.org\/10.1007\/978-3-031-68309-1_8","DOI":"10.1007\/978-3-031-68309-1_8"},{"key":"8_CR5","unstructured":"Dettmers, T., Pagnoni, A., Holtzman, A., Zettlemoyer, L.: Qlora: Efficient finetuning of quantized LLMs. In: Advance in Neural Information Processing System, vol. 36, pp. 10088\u201310115 (2023)"},{"issue":"3","key":"8_CR6","doi-asserted-by":"publisher","first-page":"421","DOI":"10.3233\/SW-190343","volume":"11","author":"D Diefenbach","year":"2020","unstructured":"Diefenbach, D., Both, A., Singh, K., Maret, P.: Towards a question answering system over the semantic web. Semant. Web 11(3), 421\u2013439 (2020). https:\/\/doi.org\/10.3233\/SW-190343","journal-title":"Semant. Web"},{"key":"8_CR7","doi-asserted-by":"publisher","unstructured":"Gan, Y., et al.: Towards robustness of text-to-SQL models against synonym substitution. CoRR abs\/2106.01065 (2021). https:\/\/doi.org\/10.48550\/arXiv.2106.01065","DOI":"10.48550\/arXiv.2106.01065"},{"key":"8_CR8","doi-asserted-by":"publisher","unstructured":"Gan, Y., Chen, X., Purver, M.: Exploring underexplored limitations of cross-domain text-to-SQL generalization. In: Proceedings of the 2021 Conference on Empirical Methods in Natural Language Processing, pp. 8926\u20138931 (2021). https:\/\/doi.org\/10.18653\/v1\/2021.emnlp-main.702","DOI":"10.18653\/v1\/2021.emnlp-main.702"},{"key":"8_CR9","doi-asserted-by":"publisher","unstructured":"Gao, Y., et al.: Retrieval-augmented generation for large language models: a survey. arXiv preprint (2024). https:\/\/doi.org\/10.48550\/arXiv.2312.10997","DOI":"10.48550\/arXiv.2312.10997"},{"key":"8_CR10","doi-asserted-by":"publisher","unstructured":"Guo, C., et al.: Retrieval-augmented GPT-3.5-based text-to-SQL framework with sample-aware prompting and dynamic revision chain. arXiv preprint (2023). https:\/\/doi.org\/10.48550\/arXiv.2307.05074","DOI":"10.48550\/arXiv.2307.05074"},{"key":"8_CR11","doi-asserted-by":"publisher","unstructured":"Hu, E.J., et\u00a0al.: Lora: low-rank adaptation of large language models. arXiv (2021). https:\/\/doi.org\/10.48550\/arXiv.2106.09685","DOI":"10.48550\/arXiv.2106.09685"},{"key":"8_CR12","unstructured":"Jurafsky, D., Martin, J.H.: Speech and Language Processing: An Introduction to Natural Language Processing, Computational Linguistics, and Speech Recognition. Prentice Hall (2023). third Edition draft"},{"key":"8_CR13","unstructured":"Lewis, P., et\u00a0al.: Retrieval-augmented generation for knowledge-intensive NLP tasks. In: Larochelle, H., Ranzato, M., Hadsell, R., Balcan, M., Lin, H. (eds.) Advances in Neural Information Processing Systems, vol.\u00a033, pp. 9459\u20139474. Curran Associates, Inc. (2020). https:\/\/api.semanticscholar.org\/CorpusID:218869575"},{"key":"8_CR14","doi-asserted-by":"publisher","unstructured":"Li, J., et\u00a0al.: Can LLM already serve as a database interface? A big bench for large-scale database grounded text-to-SQLs. arXiv preprint (2023). https:\/\/doi.org\/10.48550\/arXiv.2305.03111","DOI":"10.48550\/arXiv.2305.03111"},{"key":"8_CR15","unstructured":"Liu, A., Hu, X., Wen, L., Yu, P.S.: A comprehensive evaluation of ChatGPT\u2019s zero-shot text-to-SQL capability. arXiv preprint (2023). arXiv:2303.13547"},{"issue":"2","key":"8_CR16","doi-asserted-by":"publisher","first-page":"127","DOI":"10.1162\/daed_a_01905","volume":"151","author":"CD Manning","year":"2022","unstructured":"Manning, C.D.: Human language understanding & reasoning. Daedalus 151(2), 127\u2013138 (2022). https:\/\/doi.org\/10.1162\/daed_a_01905","journal-title":"Daedalus"},{"issue":"5","key":"8_CR17","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/3527450","volume":"55","author":"Q Motger","year":"2022","unstructured":"Motger, Q., Franch, X., Marco, J.: Software-based dialogue systems: survey, taxonomy, and challenges. ACM Comput. Surv. 55(5), 1\u201342 (2022). https:\/\/doi.org\/10.1145\/3527450","journal-title":"ACM Comput. Surv."},{"key":"8_CR18","unstructured":"Nascimento, E.R.: Querying Databases with Natural Language: The use of Large Language Models for Text-to-SQL tasks. Master\u2019s thesis, Dissertation presented to the Graduate Program in Informatics, PUC-Rio (2024)"},{"key":"8_CR19","doi-asserted-by":"publisher","unstructured":"Nascimento, E.R., et al.: Text-to-SQL meets the real-world. In: Proceedings of the 26th International Conference on Enterprise Information Systems, vol. 1, pp. 61\u201372. ICEIS; SciTePress (2024). ISBN 978-989-758-692-7. https:\/\/doi.org\/10.5220\/0012555200003690","DOI":"10.5220\/0012555200003690"},{"key":"8_CR20","unstructured":"Nascimento, E.R., et al.: A family of natural language interfaces for databases based on ChatGPT and LangChain (short paper). In: Companion Proceedings of the 42nd International Conference on Conceptual Modeling: Posters and Demos co-located with ER 2023. Lisbon, 06\u201309 November 2023, CEUR Workshop Proceedings, vol.\u00a03618 (2023). https:\/\/ceur-ws.org\/Vol-3618\/pd_paper_1.pdf"},{"key":"8_CR21","doi-asserted-by":"publisher","unstructured":"Nascimento, E.R., et al.: My database user is a large language model. In: Proceedings of the 26th International Conference on Enterprise Information Systems, vol. 1, pp. 800\u2013806. ICEIS; SciTePress (2024). ISBN 978-989-758-692-7. https:\/\/doi.org\/10.5220\/0012697700003690","DOI":"10.5220\/0012697700003690"},{"key":"8_CR22","doi-asserted-by":"publisher","unstructured":"Ouyang, L., et\u00a0al.: Training language models to follow instructions with human feedback. In: Proceedings of the Advances in Neural Information Processing Systems, NeurIPS 2022, vol. 35 (2022). https:\/\/doi.org\/10.48550\/ARXIV.2203.02155, online: 25 May 2023","DOI":"10.48550\/ARXIV.2203.02155"},{"key":"8_CR23","doi-asserted-by":"publisher","unstructured":"Pal, A., Karkhanis, D., Dooley, S., Roberts, M., Naidu, S., White, C.: Smaug: fixing failure modes of preference optimisation with DPO-positive. arXiv preprint (2024). https:\/\/doi.org\/10.48550\/arXiv.2402.13228","DOI":"10.48550\/arXiv.2402.13228"},{"key":"8_CR24","unstructured":"Panda, S., Gozluklu, B.: Build a robust text-to-SQL solution generating complex queries, self-correcting, and querying diverse data sources. AWS Mach. Learn. Blog (2024)"},{"key":"8_CR25","unstructured":"Ping, W.J.: Open-sourcing sqleval: our framework for evaluating LLM-generated SQL (2023). https:\/\/defog.ai\/blog\/open-sourcing-sqleval\/"},{"key":"8_CR26","doi-asserted-by":"publisher","unstructured":"Pinheiro., J., et al.: On the construction of database interfaces based on large language models. In: Proceedings of the 19th International Conference on Web Information Systems and Technologies - WEBIST, pp. 373\u2013380. INSTICC, SciTePress (2023). https:\/\/doi.org\/10.5220\/0012204000003584","DOI":"10.5220\/0012204000003584"},{"key":"8_CR27","unstructured":"Tunstall, L., von Werra, L., Wolf, T.: Natural Language Processing with Transformers. Revised Inc, O\u2019Reilly Media (2022)"},{"key":"8_CR28","doi-asserted-by":"publisher","unstructured":"Vaswani, A., et\u00a0al.: Attention is all you need. In: Proceedings of the Advances in Neural Information Processing Systems (NIPS 2017), vol.\u00a030 (2017). https:\/\/doi.org\/10.48550\/arXiv.1706.03762","DOI":"10.48550\/arXiv.1706.03762"},{"key":"8_CR29","doi-asserted-by":"publisher","unstructured":"Wang, B., et al.: Mac-SQL: A multi-agent collaborative framework for text-to-SQL. arXiv preprint (2024). https:\/\/doi.org\/10.48550\/arXiv.2312.11242","DOI":"10.48550\/arXiv.2312.11242"},{"key":"8_CR30","doi-asserted-by":"publisher","unstructured":"Yu, T., et al.: Spider: a large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-SQL task. In: Proceedings of the 2018 Conference on Empirical Methods in Natural Language Processing, pp. 3911\u20133921 (2018). https:\/\/doi.org\/10.18653\/v1\/D18-1425","DOI":"10.18653\/v1\/D18-1425"},{"key":"8_CR31","unstructured":"Zhong, V., Xiong, C., Socher, R.: Seq2sql: generating structured queries from natural language using reinforcement learning. CoRR abs\/1709.00103 (2017). http:\/\/arxiv.org\/abs\/1709.00103"}],"container-title":["Lecture Notes in Business Information Processing","Web Information Systems and Technologies"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-031-89621-7_8","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,5,20]],"date-time":"2025-05-20T13:13:50Z","timestamp":1747746830000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-031-89621-7_8"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025]]},"ISBN":["9783031896200","9783031896217"],"references-count":31,"URL":"https:\/\/doi.org\/10.1007\/978-3-031-89621-7_8","relation":{},"ISSN":["1865-1348","1865-1356"],"issn-type":[{"value":"1865-1348","type":"print"},{"value":"1865-1356","type":"electronic"}],"subject":[],"published":{"date-parts":[[2025]]},"assertion":[{"value":"21 May 2025","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"WEBIST","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"International Conference on Web Information Systems and Technologies","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Rome","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Italy","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2023","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"15 November 2023","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"17 November 2023","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"19","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"webist2023","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/webist.scitevents.org\/Home.aspx?y=2023","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}