{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,1,1]],"date-time":"2026-01-01T10:12:01Z","timestamp":1767262321369,"version":"3.40.3"},"publisher-location":"Cham","reference-count":14,"publisher":"Springer Nature Switzerland","isbn-type":[{"type":"print","value":"9783031683084"},{"type":"electronic","value":"9783031683091"}],"license":[{"start":{"date-parts":[[2024,1,1]],"date-time":"2024-01-01T00:00:00Z","timestamp":1704067200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2024,1,1]],"date-time":"2024-01-01T00:00:00Z","timestamp":1704067200000},"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":[[2024]]},"DOI":"10.1007\/978-3-031-68309-1_8","type":"book-chapter","created":{"date-parts":[[2024,8,17]],"date-time":"2024-08-17T14:02:25Z","timestamp":1723903345000},"page":"93-107","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":6,"title":["Improving the\u00a0Accuracy of\u00a0Text-to-SQL Tools Based on\u00a0Large Language Models for\u00a0Real-World Relational Databases"],"prefix":"10.1007","author":[{"ORCID":"https:\/\/orcid.org\/0000-0003-2951-4972","authenticated-orcid":false,"given":"Gustavo M. C.","family":"Coelho","sequence":"first","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0009-0005-3391-7813","authenticated-orcid":false,"given":"Eduardo R. S.","family":"Nascimento","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0003-0971-8572","authenticated-orcid":false,"given":"Yenier T.","family":"Izquierdo","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0001-9713-300X","authenticated-orcid":false,"given":"Grettel M.","family":"Garc\u00eda","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0009-0006-4763-8564","authenticated-orcid":false,"given":"Lucas","family":"Feij\u00f3","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0003-1723-9897","authenticated-orcid":false,"given":"Melissa","family":"Lemos","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0002-0528-5151","authenticated-orcid":false,"given":"Robinson L. S.","family":"Garcia","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0009-0001-8970-0454","authenticated-orcid":false,"given":"Aiko R.","family":"de Oliveira","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0002-0909-4432","authenticated-orcid":false,"given":"Jo\u00e3o P.","family":"Pinheiro","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0003-0765-9636","authenticated-orcid":false,"given":"Marco A.","family":"Casanova","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2024,8,18]]},"reference":[{"key":"8_CR1","doi-asserted-by":"publisher","unstructured":"Affolter, K., Stockinger, K., Bernstein, A.: A comparative survey of recent natural language interfaces for databases. VLDB J. 28 (2019). https:\/\/doi.org\/10.1007\/s00778-019-00567-8","DOI":"10.1007\/s00778-019-00567-8"},{"key":"8_CR2","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_CR3","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, January 2021. https:\/\/doi.org\/10.18653\/v1\/2021.emnlp-main.702","DOI":"10.18653\/v1\/2021.emnlp-main.702"},{"key":"8_CR4","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_CR5","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"},{"issue":"4","key":"8_CR6","doi-asserted-by":"publisher","first-page":"905","DOI":"10.1007\/s00778-022-00776-8","volume":"32","author":"G Katsogiannis-Meimarakis","year":"2023","unstructured":"Katsogiannis-Meimarakis, G., Koutrika, G.: A survey on deep learning approaches for text-to-SQL. VLDB J. 32(4), 905\u2013936 (2023). https:\/\/doi.org\/10.1007\/s00778-022-00776-8","journal-title":"VLDB J."},{"key":"8_CR7","doi-asserted-by":"publisher","unstructured":"Kim, H., So, B.H., Han, W.S., Lee, H.: Natural language to SQL: where are we today? Proc. VLDB Endow. 13(10), 1737\u20131750 (2020). https:\/\/doi.org\/10.14778\/3401960.3401970","DOI":"10.14778\/3401960.3401970"},{"key":"8_CR8","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_CR9","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_CR10","doi-asserted-by":"publisher","unstructured":"Manning, C.D.: Human language understanding & reasoning. Daedalus 151(2), 127\u2013138 (2022). https:\/\/doi.org\/10.1162\/daed_a_01905","DOI":"10.1162\/daed_a_01905"},{"key":"8_CR11","doi-asserted-by":"publisher","unstructured":"Nascimento, E.R., et\u00a0al.: My database user is a large language model. In: Proceedings of the 26th International Conference on Enterprise Information Systems, vol. 1, pp. 800\u2013806 (2024). https:\/\/doi.org\/10.5220\/0012697700003690","DOI":"10.5220\/0012697700003690"},{"key":"8_CR12","doi-asserted-by":"publisher","unstructured":"Nascimento, E.R., et\u00a0al.: Text-to-SQL meets the real-world. In: Proceedings of the 26th International Conference on Enterprise Information Systems, vol. 1, pp. 61\u201372 (2024). https:\/\/doi.org\/10.5220\/0012555200003690","DOI":"10.5220\/0012555200003690"},{"key":"8_CR13","unstructured":"Panda, S., Gozluklu, B.: Build a robust text-to-sql solution generating complex queries, self-correcting, and querying diverse data sources. AWS Machine Learning Blog, 28 February 2024"},{"key":"8_CR14","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, Oct\u2013Nov 2018. https:\/\/doi.org\/10.18653\/v1\/D18-1425","DOI":"10.18653\/v1\/D18-1425"}],"container-title":["Lecture Notes in Computer Science","Database and Expert Systems Applications"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-031-68309-1_8","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,8,17]],"date-time":"2024-08-17T14:03:25Z","timestamp":1723903405000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-031-68309-1_8"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024]]},"ISBN":["9783031683084","9783031683091"],"references-count":14,"URL":"https:\/\/doi.org\/10.1007\/978-3-031-68309-1_8","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2024]]},"assertion":[{"value":"18 August 2024","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"DEXA","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"International Conference on Database and Expert Systems Applications","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Naples","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":"2024","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"26 August 2024","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"28 August 2024","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"35","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"dexa2024","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/www.dexa.org\/dexa2024\/","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}