{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,9,11]],"date-time":"2025-09-11T20:31:15Z","timestamp":1757622675892,"version":"3.44.0"},"publisher-location":"Cham","reference-count":36,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783030865160"},{"type":"electronic","value":"9783030865177"}],"license":[{"start":{"date-parts":[[2021,1,1]],"date-time":"2021-01-01T00:00:00Z","timestamp":1609459200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2021,1,1]],"date-time":"2021-01-01T00:00:00Z","timestamp":1609459200000},"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":[[2021]]},"DOI":"10.1007\/978-3-030-86517-7_21","type":"book-chapter","created":{"date-parts":[[2021,9,9]],"date-time":"2021-09-09T10:08:05Z","timestamp":1631182085000},"page":"335-350","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":1,"title":["An Optimized NL2SQL System for Enterprise Data Mart"],"prefix":"10.1007","author":[{"ORCID":"https:\/\/orcid.org\/0000-0001-8244-9562","authenticated-orcid":false,"given":"Kaiwen","family":"Dong","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Kai","family":"Lu","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Xin","family":"Xia","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"David","family":"Cieslak","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-3932-5956","authenticated-orcid":false,"given":"Nitesh V.","family":"Chawla","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2021,9,10]]},"reference":[{"key":"21_CR1","unstructured":"Androutsopoulos, I., Ritchie, G.D., Thanisch, P.: Natural language interfaces to databases - an introduction. CoRR cmp-lg\/9503016 (1995). http:\/\/arxiv.org\/abs\/cmp-lg\/9503016"},{"key":"21_CR2","unstructured":"Aunalytics: Dayreak analytic database. https:\/\/www.aunalytics.com\/products\/daybreak\/"},{"key":"21_CR3","unstructured":"Devlin, J., Chang, M., Lee, K., Toutanova, K.: BERT: pre-training of deep bidirectional transformers for language understanding. CoRR abs\/1810.04805 (2018). http:\/\/arxiv.org\/abs\/1810.04805"},{"key":"21_CR4","doi-asserted-by":"publisher","unstructured":"Dhamdhere, K., McCurley, K.S., Nahmias, R., Sundararajan, M., Yan, Q.: Analyza: exploring data with conversation. In: Proceedings of the 22nd International Conference on Intelligent User Interfaces, pp. 493\u2013504. IUI 2017. Association for Computing Machinery, New York, NY, USA (2017). https:\/\/doi.org\/10.1145\/3025171.3025227, https:\/\/doi.org\/10.1145\/3025171.3025227","DOI":"10.1145\/3025171.3025227"},{"key":"21_CR5","doi-asserted-by":"publisher","unstructured":"Dong, L., Lapata, M.: Coarse-to-fine decoding for neural semantic parsing. In: Proceedings of the 56th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers), pp. 731\u2013742. Association for Computational Linguistics, Melbourne, Australia. July 2018. https:\/\/doi.org\/10.18653\/v1\/P18-1068, https:\/\/www.aclweb.org\/anthology\/P18-1068","DOI":"10.18653\/v1\/P18-1068"},{"key":"21_CR6","unstructured":"Elastic: Elasticsearch. https:\/\/www.elastic.co\/enterprise-search"},{"key":"21_CR7","unstructured":"Facebook: Duckling. https:\/\/duckling.wit.ai\/"},{"key":"21_CR8","unstructured":"Hwang, W., Yim, J., Park, S., Seo, M.: A comprehensive exploration on WikiSQL with table-aware word contextualization. CoRR abs\/1902.01069 (2019). http:\/\/arxiv.org\/abs\/1902.01069"},{"key":"21_CR9","unstructured":"Inmon, B.: Data mart does not equal data warehouse (1999)"},{"key":"21_CR10","doi-asserted-by":"publisher","unstructured":"Iyer, S., Konstas, I., Cheung, A., Krishnamurthy, J., Zettlemoyer, L.: Learning a neural semantic parser from user feedback. In: Proceedings of the 55th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers), pp. 963\u2013973. Association for Computational Linguistics, Vancouver, Canada, July 2017. https:\/\/doi.org\/10.18653\/v1\/P17-1089, https:\/\/www.aclweb.org\/anthology\/P17-1089","DOI":"10.18653\/v1\/P17-1089"},{"key":"21_CR11","doi-asserted-by":"publisher","unstructured":"Janai, J., G\u00fcney, F., Behl, A., Geiger, A.: Computer vision for autonomous vehicles: problems, datasets and state of the art. Foundations Trends\u00ae Comput. Graph. Vis. 12(1\u20133), 1\u2013308 (2020). https:\/\/doi.org\/10.1561\/0600000079, http:\/\/dx.doi.org\/10.1561\/0600000079","DOI":"10.1561\/0600000079"},{"key":"21_CR12","unstructured":"Kingma, D.P., Ba, J.: Adam: a method for stochastic optimization. In: Bengio, Y., LeCun, Y. (eds.) 3rd International Conference on Learning Representations, ICLR 2015, 7\u20139 May 2015, San Diego, CA, USA, Conference Track Proceedings (2015). http:\/\/arxiv.org\/abs\/1412.6980"},{"key":"21_CR13","doi-asserted-by":"publisher","unstructured":"Kurita, K., Vyas, N., Pareek, A., Black, A.W., Tsvetkov, Y.: Measuring bias in contextualized word representations. In: Proceedings of the First Workshop on Gender Bias in Natural Language Processing, pp. 166\u2013172. Association for Computational Linguistics, Florence, Italy, August 2019. https:\/\/doi.org\/10.18653\/v1\/W19-3823, https:\/\/www.aclweb.org\/anthology\/W19-3823","DOI":"10.18653\/v1\/W19-3823"},{"key":"21_CR14","unstructured":"Levenshtein, V.I.: Binary Codes Capable of Correcting Deletions. Insertions and Reversals. Soviet Physics Doklady 10, 707 (1966)"},{"key":"21_CR15","doi-asserted-by":"publisher","unstructured":"Li, F., Jagadish, H.V.: NaLIR: an interactive natural language interface for querying relational databases. In: Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data, pp. 709\u2013712. SIGMOD 2014. Association for Computing Machinery, New York, NY, USA (2014). https:\/\/doi.org\/10.1145\/2588555.2594519, https:\/\/doi.org\/10.1145\/2588555.2594519","DOI":"10.1145\/2588555.2594519"},{"key":"21_CR16","doi-asserted-by":"publisher","unstructured":"Lin, X.V., Socher, R., Xiong, C.: Bridging textual and tabular data for cross-domain text-to-SQL semantic parsing. In: Findings of the Association for Computational Linguistics: EMNLP 2020, pp. 4870\u20134888. Association for Computational Linguistics, Online, November 2020. https:\/\/doi.org\/10.18653\/v1\/2020.findings-emnlp.438, https:\/\/www.aclweb.org\/anthology\/2020.findings-emnlp.438","DOI":"10.18653\/v1\/2020.findings-emnlp.438"},{"key":"21_CR17","doi-asserted-by":"publisher","unstructured":"Manning, C., Surdeanu, M., Bauer, J., Finkel, J., Bethard, S., McClosky, D.: The stanford CoreNLP natural language processing toolkit. In: Proceedings of 52nd Annual Meeting of the Association for Computational Linguistics: System Demonstrations, pp. 55\u201360. Association for Computational Linguistics, Baltimore, Maryland, June 2014. https:\/\/doi.org\/10.3115\/v1\/P14-5010, https:\/\/www.aclweb.org\/anthology\/P14-5010","DOI":"10.3115\/v1\/P14-5010"},{"key":"21_CR18","doi-asserted-by":"publisher","unstructured":"Navarro, G.: A guided tour to approximate string matching. ACM Comput. Surv. 33(1), 31\u201388 (2001). https:\/\/doi.org\/10.1145\/375360.375365, https:\/\/doi.org\/10.1145\/375360.375365","DOI":"10.1145\/375360.375365"},{"key":"21_CR19","doi-asserted-by":"crossref","unstructured":"Pennington, J., Socher, R., Manning, C.D.: GloVe: global vectors for word representation. In: Empirical Methods in Natural Language Processing (EMNLP), pp. 1532\u20131543 (2014). http:\/\/www.aclweb.org\/anthology\/D14-1162","DOI":"10.3115\/v1\/D14-1162"},{"key":"21_CR20","unstructured":"Peterson, S.: Stars: A pattern language for query optimized schema (1994). http:\/\/c2.com\/ppr\/stars.html"},{"key":"21_CR21","doi-asserted-by":"publisher","unstructured":"Setlur, V., Battersby, S.E., Tory, M., Gossweiler, R., Chang, A.X.: Eviza: a natural language interface for visual analysis. In: Proceedings of the 29th Annual Symposium on User Interface Software and Technology, pp. 365\u2013377. UIST 2016. Association for Computing Machinery, New York, NY, USA (2016). https:\/\/doi.org\/10.1145\/2984511.2984588, https:\/\/doi.org\/10.1145\/2984511.2984588","DOI":"10.1145\/2984511.2984588"},{"key":"21_CR22","doi-asserted-by":"publisher","unstructured":"Setlur, V., Tory, M., Djalali, A.: Inferencing underspecified natural language utterances in visual analysis. In: Proceedings of the 24th International Conference on Intelligent User Interfaces, pp. 40\u201351. IUI 2019. Association for Computing Machinery, New York, NY, USA (2019). https:\/\/doi.org\/10.1145\/3301275.3302270, https:\/\/doi.org\/10.1145\/3301275.3302270","DOI":"10.1145\/3301275.3302270"},{"key":"21_CR23","doi-asserted-by":"publisher","unstructured":"Shen, D., Wu, G., Suk, H.I.: Deep learning in medical image analysis. Ann. Rev. Biomed. Eng. 19(1), 221\u2013248 (2017). https:\/\/doi.org\/10.1146\/annurev-bioeng-071516-044442, https:\/\/doi.org\/10.1146\/annurev-bioeng-071516-044442, pMID: 28301734","DOI":"10.1146\/annurev-bioeng-071516-044442"},{"key":"21_CR24","doi-asserted-by":"publisher","unstructured":"Sun, T., et al.: Mitigating gender bias in natural language processing: literature review. In: Proceedings of the 57th Annual Meeting of the Association for Computational Linguistics, pp. 1630\u20131640. Association for Computational Linguistics, Florence, Italy, July 2019. https:\/\/doi.org\/10.18653\/v1\/P19-1159, https:\/\/www.aclweb.org\/anthology\/P19-1159","DOI":"10.18653\/v1\/P19-1159"},{"key":"21_CR25","unstructured":"Vaswani, A., et al.: Attention is all you need. CoRR abs\/1706.03762 (2017). http:\/\/arxiv.org\/abs\/1706.03762"},{"key":"21_CR26","doi-asserted-by":"crossref","unstructured":"Wang, B., Shin, R., Liu, X., Polozov, O., Richardson, M.: RAT-SQL: relation-aware schema encoding and linking for text-to-sql parsers. CoRR abs\/1911.04942 (2019). http:\/\/arxiv.org\/abs\/1911.04942","DOI":"10.18653\/v1\/2020.acl-main.677"},{"key":"21_CR27","doi-asserted-by":"publisher","unstructured":"Wang, P., Shi, T., Reddy, C.K.: Text-to-SQL generation for question answering on electronic medical records. In: Huang, Y., King, I., Liu, T., van Steen, M. (eds.) WWW 2020: The Web Conference 2020, 20\u201324 April 2020, Taipei, Taiwan, pp. 350\u2013361. ACM\/IW3C2 (2020). https:\/\/doi.org\/10.1145\/3366423.3380120, https:\/\/doi.org\/10.1145\/3366423.3380120","DOI":"10.1145\/3366423.3380120"},{"key":"21_CR28","doi-asserted-by":"publisher","unstructured":"Weir, N., et al.: DBPal: a fully pluggable NL2SQL training pipeline. In: Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data, pp. 2347\u20132361. SIGMOD 2020, Association for Computing Machinery, New York, NY, USA (2020). https:\/\/doi.org\/10.1145\/3318464.3380589, https:\/\/doi.org\/10.1145\/3318464.3380589","DOI":"10.1145\/3318464.3380589"},{"issue":"2","key":"21_CR29","doi-asserted-by":"publisher","first-page":"270","DOI":"10.1162\/neco.1989.1.2.270","volume":"1","author":"RJ Williams","year":"1989","unstructured":"Williams, R.J., Zipser, D.: A learning algorithm for continually running fully recurrent neural networks. Neural Comput. 1(2), 270\u2013280 (1989). https:\/\/doi.org\/10.1162\/neco.1989.1.2.270","journal-title":"Neural Comput."},{"key":"21_CR30","unstructured":"Wolf, T., et al.: Huggingface\u2019s transformers: state-of-the-art natural language processing. CoRR abs\/1910.03771 (2019). http:\/\/arxiv.org\/abs\/1910.03771"},{"key":"21_CR31","unstructured":"Wu, Y., et al.: Google\u2019s neural machine translation system: bridging the gap between human and machine translation. CoRR abs\/1609.08144 (2016). http:\/\/arxiv.org\/abs\/1609.08144"},{"key":"21_CR32","unstructured":"Xu, X., Liu, C., Song, D.: SQLNet: generating structured queries from natural language without reinforcement learning. CoRR abs\/1711.04436 (2017). http:\/\/arxiv.org\/abs\/1711.04436"},{"key":"21_CR33","doi-asserted-by":"crossref","unstructured":"Yu, T., et al.: Spider: a large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-sql task. CoRR abs\/1809.08887 (2018). http:\/\/arxiv.org\/abs\/1809.08887","DOI":"10.18653\/v1\/D18-1425"},{"key":"21_CR34","doi-asserted-by":"publisher","unstructured":"Zeng, J., et al.: Photon: A robust cross-domain Text-to-SQL system. In: Proceedings of the 58th Annual Meeting of the Association for Computational Linguistics: System Demonstrations, pp. 204\u2013214. Association for Computational Linguistics, Online, July 2020. https:\/\/doi.org\/10.18653\/v1\/2020.acl-demos.24, https:\/\/www.aclweb.org\/anthology\/2020.acl-demos.24","DOI":"10.18653\/v1\/2020.acl-demos.24"},{"key":"21_CR35","doi-asserted-by":"crossref","unstructured":"Zhong, V., Lewis, M., Wang, S.I., Zettlemoyer, L.: Grounded adaptation for zero-shot executable semantic parsing (2021)","DOI":"10.18653\/v1\/2020.emnlp-main.558"},{"key":"21_CR36","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 Computer Science","Machine Learning and Knowledge Discovery in Databases. Applied Data Science Track"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-030-86517-7_21","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,8]],"date-time":"2025-09-08T22:03:53Z","timestamp":1757369033000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-030-86517-7_21"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2021]]},"ISBN":["9783030865160","9783030865177"],"references-count":36,"URL":"https:\/\/doi.org\/10.1007\/978-3-030-86517-7_21","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2021]]},"assertion":[{"value":"10 September 2021","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"ECML PKDD","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Joint European Conference on Machine Learning and Knowledge Discovery in Databases","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Bilbao","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Spain","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2021","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"13 September 2021","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"17 September 2021","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"21","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"ecml2021","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/2021.ecmlpkdd.org\/","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":"869","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":"210","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":"0","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-4","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":"3-9","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)"}},{"value":"The conference was held online due to the COVID-19 pandemic.","order":10,"name":"additional_info_on_review_process","label":"Additional Info on Review Process","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}}]}}