{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,11,26]],"date-time":"2025-11-26T21:30:24Z","timestamp":1764192624060,"version":"3.40.3"},"publisher-location":"Singapore","reference-count":40,"publisher":"Springer Nature Singapore","isbn-type":[{"type":"print","value":"9789819972531"},{"type":"electronic","value":"9789819972548"}],"license":[{"start":{"date-parts":[[2023,1,1]],"date-time":"2023-01-01T00:00:00Z","timestamp":1672531200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2023,1,1]],"date-time":"2023-01-01T00:00:00Z","timestamp":1672531200000},"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":[[2023]]},"DOI":"10.1007\/978-981-99-7254-8_50","type":"book-chapter","created":{"date-parts":[[2023,10,21]],"date-time":"2023-10-21T05:01:47Z","timestamp":1697864507000},"page":"643-658","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":3,"title":["An Integrated Interactive Framework for\u00a0Natural Language to\u00a0SQL Translation"],"prefix":"10.1007","author":[{"given":"Yuankai","family":"Fan","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Tonghui","family":"Ren","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Dianjun","family":"Guo","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zhigang","family":"Zhao","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zhenying","family":"He","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"X. Sean","family":"Wang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Yu","family":"Wang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Tao","family":"Sui","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2023,10,21]]},"reference":[{"issue":"1","key":"50_CR1","doi-asserted-by":"publisher","first-page":"29","DOI":"10.1017\/S135132490000005X","volume":"1","author":"I Androutsopoulos","year":"1995","unstructured":"Androutsopoulos, I., et al.: Natural language interfaces to databases - an introduction. Nat. Lang. Eng. 1(1), 29\u201381 (1995)","journal-title":"Nat. Lang. Eng."},{"key":"50_CR2","doi-asserted-by":"crossref","unstructured":"Baik, C., et al.: Bridging the semantic gap with SQL query logs in natural language interfaces to databases. In: ICDE (2019)","DOI":"10.1109\/ICDE.2019.00041"},{"key":"50_CR3","doi-asserted-by":"crossref","unstructured":"Bogin, B., et al.: Representing schema structure with graph neural networks for text-to-SQL parsing. In: ACL (2019)","DOI":"10.18653\/v1\/P19-1448"},{"key":"50_CR4","doi-asserted-by":"crossref","unstructured":"Cao, R., et al.: LGESQL: line graph enhanced text-to-SQL model with mixed local and non-local relations. In: ACL (2021)","DOI":"10.18653\/v1\/2021.acl-long.198"},{"key":"50_CR5","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"490","DOI":"10.1007\/978-3-030-19274-7_34","volume-title":"Web Engineering","author":"N Castaldo","year":"2019","unstructured":"Castaldo, N., Daniel, F., Matera, M., Zaccaria, V.: Conversational data exploration. In: Bakaev, M., Frasincar, F., Ko, I.-Y. (eds.) ICWE 2019. LNCS, vol. 11496, pp. 490\u2013497. Springer, Cham (2019). https:\/\/doi.org\/10.1007\/978-3-030-19274-7_34"},{"key":"50_CR6","unstructured":"Chaurasia, S., et al.: Dialog for language to code. In: IJCNLP, pp. 175\u2013180 (2017)"},{"key":"50_CR7","doi-asserted-by":"crossref","unstructured":"Desolda, G., et al.: Rapid prototyping of chatbots for data exploration. In: BCNC, pp. 5\u201310 (2021)","DOI":"10.1145\/3486949.3486962"},{"key":"50_CR8","doi-asserted-by":"crossref","unstructured":"Fan, Y., et al.: Gar: a generate-and-rank approach for natural language to SQL translation. In: ICDE (2023)","DOI":"10.1109\/ICDE55515.2023.00016"},{"issue":"2","key":"50_CR9","first-page":"73","volume":"1","author":"L Feng","year":"1998","unstructured":"Feng, L., Lu, H.: Integrating database and world wide web technologies. WWWJ 1(2), 73\u201386 (1998)","journal-title":"WWWJ"},{"key":"50_CR10","unstructured":"Gal, Y., Ghahramani, Z.: Dropout as a Bayesian approximation: representing model uncertainty in deep learning. In: ICML, vol. 48, pp. 1050\u20131059 (2016)"},{"key":"50_CR11","doi-asserted-by":"crossref","unstructured":"Goyal, K., et al.: Differentiable scheduled sampling for credit assignment. In: ACL, pp. 366\u2013371 (2017)","DOI":"10.18653\/v1\/P17-2058"},{"key":"50_CR12","unstructured":"Grave, E., et al.: Improving neural language models with a continuous cache. In: ICLR (2017)"},{"key":"50_CR13","doi-asserted-by":"crossref","unstructured":"Guo, J., et al.: Towards complex text-to-SQL in cross-domain database with intermediate representation. In: ACL (2019)","DOI":"10.18653\/v1\/P19-1444"},{"key":"50_CR14","doi-asserted-by":"crossref","unstructured":"Gur, I., et al.: DialSQL: dialogue based structured query generation. In: ACL (2018)","DOI":"10.18653\/v1\/P18-1124"},{"key":"50_CR15","first-page":"133","volume":"2","author":"H He","year":"2007","unstructured":"He, H., et al.: Towards deeper understanding of the search interfaces of the deep web. WWWJ 2, 133\u2013155 (2007)","journal-title":"WWWJ"},{"key":"50_CR16","doi-asserted-by":"crossref","unstructured":"He, L., et al.: Human-in-the-loop parsing. In: EMNLP, pp. 2337\u20132342 (2016)","DOI":"10.18653\/v1\/D16-1258"},{"key":"50_CR17","unstructured":"Hendrycks, D., Gimpel, K.: A baseline for detecting misclassified and out-of-distribution examples in neural networks. In: ICLR (2017)"},{"issue":"1","key":"50_CR18","first-page":"73","volume":"8","author":"F Li","year":"2014","unstructured":"Li, F., Jagadish, H.V.: Constructing an interactive natural language interface for relational databases. PVLDB 8(1), 73\u201384 (2014)","journal-title":"PVLDB"},{"key":"50_CR19","doi-asserted-by":"crossref","unstructured":"Li, J., et al.: Graphix-T5: mixing pre-trained transformers with graph-aware layers for text-to-SQL parsing. In: AAAI, pp. 13076\u201313084 (2023)","DOI":"10.1609\/aaai.v37i11.26536"},{"key":"50_CR20","doi-asserted-by":"crossref","unstructured":"Lin, X.V., et al.: Bridging textual and tabular data for cross-domain text-to-SQL semantic parsing. In: EMNLP (2020)","DOI":"10.18653\/v1\/2020.findings-emnlp.438"},{"key":"50_CR21","doi-asserted-by":"crossref","unstructured":"Nakatsuji, M., et al.: Knowledge-aware response selection with semantics underlying multi-turn open-domain conversations. In: World Wide Web, pp. 1\u201316 (2023)","DOI":"10.21203\/rs.3.rs-2171092\/v1"},{"key":"50_CR22","doi-asserted-by":"crossref","unstructured":"Niehues, J., et al.: Modeling confidence in sequence-to-sequence models. In: INLG, pp. 575\u2013583 (2019)","DOI":"10.18653\/v1\/W19-8671"},{"key":"50_CR23","unstructured":"OpenAI: GPT-4 technical report. CoRR (2023)"},{"key":"50_CR24","unstructured":"Pourreza, M., Rafiei, D.: DIN-SQL: decomposed in-context learning of text-to-SQL with self-correction. CoRR (2023)"},{"issue":"12","key":"50_CR25","first-page":"1209","volume":"9","author":"D Saha","year":"2016","unstructured":"Saha, D., et al.: ATHENA: an ontology-driven system for natural language querying over relational data stores. PVLDB 9(12), 1209\u20131220 (2016)","journal-title":"PVLDB"},{"key":"50_CR26","doi-asserted-by":"crossref","unstructured":"Scholak, T., et al.: PICARD: parsing incrementally for constrained auto-regressive decoding from language models. In: EMNLP (2021)","DOI":"10.18653\/v1\/2021.emnlp-main.779"},{"issue":"11","key":"50_CR27","first-page":"2747","volume":"13","author":"J Sen","year":"2020","unstructured":"Sen, J., et al.: ATHENA++: natural language querying for complex nested SQL queries. PVLDB 13(11), 2747\u20132759 (2020)","journal-title":"PVLDB"},{"key":"50_CR28","doi-asserted-by":"crossref","unstructured":"Shi, P., et al.: Learning contextual representations for semantic parsing with generation-augmented pre-training. In: AAAI (2021)","DOI":"10.1609\/aaai.v35i15.17627"},{"issue":"1","key":"50_CR29","first-page":"117","volume":"17","author":"A Simitsis","year":"2008","unstructured":"Simitsis, A., et al.: Pr\u00e9cis: from unstructured keywords as queries to structured databases as answers. PVLDB 17(1), 117\u2013149 (2008)","journal-title":"PVLDB"},{"key":"50_CR30","doi-asserted-by":"crossref","unstructured":"Su, Y., et al.: Natural language interfaces with fine-grained user interaction: a case study on web APIs. In: SIGIR, pp. 855\u2013864 (2018)","DOI":"10.1145\/3209978.3210013"},{"key":"50_CR31","unstructured":"Sukhbaatar, S., et al.: End-to-end memory networks. In: NeurIPS, pp. 2440\u20132448 (2015)"},{"key":"50_CR32","unstructured":"Touvron, H., et al.: LLaMA: open and efficient foundation language models. CoRR (2023)"},{"key":"50_CR33","doi-asserted-by":"crossref","unstructured":"Wang, B., et al.: RAT-SQL: relation-aware schema encoding and linking for text-to-SQL parsers. In: ACL (2020)","DOI":"10.18653\/v1\/2020.acl-main.677"},{"key":"50_CR34","unstructured":"Xu, X., et al.: SQLNet: generating structured queries from natural language without reinforcement learning. CoRR (2017)"},{"key":"50_CR35","doi-asserted-by":"crossref","unstructured":"Yao, Z., et al.: Interactive semantic parsing for if-then recipes via hierarchical reinforcement learning. In: AAAI, pp. 2547\u20132554 (2019)","DOI":"10.1609\/aaai.v33i01.33012547"},{"key":"50_CR36","doi-asserted-by":"crossref","unstructured":"Yao, Z., et al.: Model-based interactive semantic parsing: a unified framework and a text-to-SQL case study. In: EMNLP, pp. 5446\u20135457 (2019)","DOI":"10.18653\/v1\/D19-1547"},{"key":"50_CR37","doi-asserted-by":"crossref","unstructured":"Yu, T., et al.: TypeSQL: knowledge-based type-aware neural text-to-SQL generation. In: NAACL (2018)","DOI":"10.18653\/v1\/N18-2093"},{"key":"50_CR38","doi-asserted-by":"crossref","unstructured":"Yu, T., et al.: CoSQL: a conversational text-to-SQL challenge towards cross-domain natural language interfaces to databases. In: EMNLP (2019)","DOI":"10.18653\/v1\/D19-1204"},{"key":"50_CR39","unstructured":"Zettlemoyer, L.S., Collins, M.: Learning to map sentences to logical form: structured classification with probabilistic categorial grammars. In: UAI (2005)"},{"key":"50_CR40","doi-asserted-by":"crossref","unstructured":"Zhang, R., et al.: Editing-based SQL query generation for cross-domain context-dependent questions. In: EMNLP, pp. 5337\u20135348 (2019)","DOI":"10.18653\/v1\/D19-1537"}],"container-title":["Lecture Notes in Computer Science","Web Information Systems Engineering \u2013 WISE 2023"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-981-99-7254-8_50","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,10,21]],"date-time":"2023-10-21T05:10:31Z","timestamp":1697865031000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-981-99-7254-8_50"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023]]},"ISBN":["9789819972531","9789819972548"],"references-count":40,"URL":"https:\/\/doi.org\/10.1007\/978-981-99-7254-8_50","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2023]]},"assertion":[{"value":"21 October 2023","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"WISE","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"International Conference on Web Information Systems Engineering","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Melbourne, VIC","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Australia","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":"25 October 2023","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"27 October 2023","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"wise2023","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"http:\/\/www.wise-conferences.org\/2023\/","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Double-blind","order":1,"name":"type","label":"Type","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"Easychair","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"137","order":3,"name":"number_of_submissions_sent_for_review","label":"Number of Submissions Sent for Review","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"33","order":4,"name":"number_of_full_papers_accepted","label":"Number of Full Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"40","order":5,"name":"number_of_short_papers_accepted","label":"Number of Short Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"24% - The value is computed by the equation \"Number of Full Papers Accepted \/ Number of Submissions Sent for Review * 100\" and then rounded to a whole number.","order":6,"name":"acceptance_rate_of_full_papers","label":"Acceptance Rate of Full Papers","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"3","order":7,"name":"average_number_of_reviews_per_paper","label":"Average Number of Reviews per Paper","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"4","order":8,"name":"average_number_of_papers_per_reviewer","label":"Average Number of Papers per Reviewer","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"Yes","order":9,"name":"external_reviewers_involved","label":"External Reviewers Involved","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}}]}}