{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,11,26]],"date-time":"2025-11-26T21:31:01Z","timestamp":1764192661124,"version":"3.40.3"},"publisher-location":"Singapore","reference-count":57,"publisher":"Springer Nature Singapore","isbn-type":[{"type":"print","value":"9789819772377"},{"type":"electronic","value":"9789819772384"}],"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-981-97-7238-4_26","type":"book-chapter","created":{"date-parts":[[2024,8,27]],"date-time":"2024-08-27T16:02:47Z","timestamp":1724774567000},"page":"411-427","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":1,"title":["Gar $$\\scriptstyle ++$$: Natural Language to\u00a0SQL Translation with\u00a0Efficient Generate-and-Rank"],"prefix":"10.1007","author":[{"given":"Yuankai","family":"Fan","sequence":"first","affiliation":[]},{"given":"Can","family":"Huang","sequence":"additional","affiliation":[]},{"given":"Tonghui","family":"Ren","sequence":"additional","affiliation":[]},{"given":"Zhenying","family":"He","sequence":"additional","affiliation":[]},{"given":"X.Sean","family":"Wang","sequence":"additional","affiliation":[]},{"given":"Xianglian","family":"Wu","sequence":"additional","affiliation":[]},{"given":"Yue","family":"Wang","sequence":"additional","affiliation":[]},{"given":"Jiaming","family":"Li","sequence":"additional","affiliation":[]},{"given":"Yifan","family":"Yang","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2024,8,28]]},"reference":[{"key":"26_CR1","doi-asserted-by":"crossref","unstructured":"Fan, Y., et al.: GAR: a generate-and-rank approach for natural language to SQL translation. In: Proceedings of the 39th International Conference on Data Engineering, pp. 110\u2013122 (2023)","DOI":"10.1109\/ICDE55515.2023.00016"},{"key":"26_CR2","doi-asserted-by":"crossref","unstructured":"Fan, Y., Ren, T., He, Z., Wang, X., Zhang, Y., Li, X.: GenSQL: a generative natural language interface to database systems. In: Proceedings of the 39th International Conference on Data Engineering, pp. 3603\u20133606 (2023)","DOI":"10.1109\/ICDE55515.2023.00278"},{"key":"26_CR3","doi-asserted-by":"crossref","unstructured":"Bogin, B., Berant, J., Gardner, M.: Representing schema structure with graph neural networks for text-to-SQL parsing. In: Association for Computational Linguistics, pp. 4560\u20134565 (2019)","DOI":"10.18653\/v1\/P19-1448"},{"key":"26_CR4","doi-asserted-by":"crossref","unstructured":"Guo, J., et al.: Towards complex text-to-SQL in cross-domain database with intermediate representation. In: Association for Computational Linguistics, pp. 4524\u20134535 (2019)","DOI":"10.18653\/v1\/P19-1444"},{"key":"26_CR5","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. In: Association for Computational Linguistics, pp. 7567\u20137578 (2020)","DOI":"10.18653\/v1\/2020.acl-main.677"},{"key":"26_CR6","doi-asserted-by":"crossref","unstructured":"Lin, X.V., Socher, R., Xiong, C.: Bridging textual and tabular data for cross-domain text-to-SQL semantic parsing. In: Proceedings of the Conference on Empirical Methods Natural Language Process, pp. 4870\u20134888 (2020)","DOI":"10.18653\/v1\/2020.findings-emnlp.438"},{"key":"26_CR7","doi-asserted-by":"crossref","unstructured":"Rubin, O., Berant, J.: SmBoP: semi-autoregressive bottom-up semantic parsing. In: Proceedings of the Human Language Technology Annual Conference North American Chapter Association Computational Linguistics, pp. 311\u2013324 (2021)","DOI":"10.18653\/v1\/2021.naacl-main.29"},{"key":"26_CR8","doi-asserted-by":"crossref","unstructured":"Shi, P., et al.: Learning contextual representations for semantic parsing with generation-augmented pre-training. In: Proceedings of the AAAI Conference Artificial Intelligence, pp. 13806\u201313814 (2021)","DOI":"10.1609\/aaai.v35i15.17627"},{"key":"26_CR9","doi-asserted-by":"crossref","unstructured":"Scholak, T., Schucher, N., Bahdanau, D.: PICARD: parsing incrementally for constrained auto-regressive decoding from language models. In: Proceedings of the Conference on Empirical Methods Natural Language Process, pp. 9895\u20139901 (2021)","DOI":"10.18653\/v1\/2021.emnlp-main.779"},{"key":"26_CR10","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. In: Proceedings of the Conference on Empirical Methods Natural Language Process, pp. 3911\u20133921 (2018)","DOI":"10.18653\/v1\/D18-1425"},{"issue":"3","key":"26_CR11","doi-asserted-by":"publisher","first-page":"569","DOI":"10.14778\/3494124.3494139","volume":"15","author":"P Ma","year":"2021","unstructured":"Ma, P., Wang, S.: MT-Teql: evaluating and augmenting neural NLIDB on real-world linguistic and schema variations. Proc. VLDB Endowment 15(3), 569\u2013582 (2021)","journal-title":"Proc. VLDB Endowment"},{"key":"26_CR12","doi-asserted-by":"crossref","unstructured":"Suhr, A., Chang, M., Shaw, P., Lee, K.: Exploring unexplored generalization challenges for cross-database semantic parsing. In: Association for Computational Linguistics, pp. 8372\u20138388 (2020)","DOI":"10.18653\/v1\/2020.acl-main.742"},{"key":"26_CR13","unstructured":"Zelle, J.M., Mooney, R.J.: Learning to parse database queries using inductive logic programming. In: Proceedings of the AAAI Conference Artificial Intelligence, pp. 1050\u20131055 (1996)"},{"key":"26_CR14","doi-asserted-by":"crossref","unstructured":"Gan, Y., et al.: Towards robustness of text-to-SQL models against synonym substitution. In: Association for Computational Linguistics, pp. 2505\u20132515 (2021)","DOI":"10.18653\/v1\/2021.acl-long.195"},{"key":"26_CR15","doi-asserted-by":"crossref","unstructured":"Deng, X., Awadallah, A.H., Meek, C., Polozov, O., Sun, H., Richardson, M.: Structure-grounded pretraining for text-to-SQL. In: Proceedings of the Human Language Technology Annual Conference North America Chapter Association Computation Linguistics, pp. 1337\u20131350 (2021)","DOI":"10.18653\/v1\/2021.naacl-main.105"},{"key":"26_CR16","doi-asserted-by":"crossref","unstructured":"Gan,Y., Chen, X. Purver, M.: Exploring underexplored limitations of cross-domain text-to-SQL generalization. In: Proceedings of the Conference on Empirical Methods Natural Language Process, pp. 8926\u20138931 (2021)","DOI":"10.18653\/v1\/2021.emnlp-main.702"},{"key":"26_CR17","doi-asserted-by":"crossref","unstructured":"Koutrika, G., Simitsis, A., Ioannidis, Y.E.: Explaining structured queries in natural language. In: Proceedings of the 12st International Conference on Data Engineering, pp. 333\u2013344 (2010)","DOI":"10.1109\/ICDE.2010.5447824"},{"key":"26_CR18","doi-asserted-by":"crossref","unstructured":"Xu, K., Wu, L., Wang, Z., Feng, Y., Sheinin, V.: SQL-to-text generation with graph-to-sequence model. In: Proceedings of the Conference on Empirical Methods Natural Language Process, pp. 931\u2013936 (2018)","DOI":"10.18653\/v1\/D18-1112"},{"key":"26_CR19","doi-asserted-by":"crossref","unstructured":"Dai, Z., Callan, J.: Deeper text understanding for IR with contextual neural language modeling. In: Proceedings of the ACM SIGIR International Conference on Research and Development in Information Retrieval, pp. 985\u2013988 (2019)","DOI":"10.1145\/3331184.3331303"},{"key":"26_CR20","unstructured":"Han, S., Wang, X., Bendersky, M., Najork, M.: Learning-to-rank with BERT in TF-ranking. arXiv preprint arXiv:2004.08476 (2020)"},{"key":"26_CR21","unstructured":"Devlin, J., Chang, M., Lee, K., Toutanova, K.: BERT: pre-training of deep bidirectional transformers for language understanding. In: Proceedings of the Human Language Technology Annual Conference North America Chapter Association Computational Linguistics, pp. 4171\u20134186 (2019)"},{"key":"26_CR22","doi-asserted-by":"crossref","unstructured":"Schroff, F., Kalenichenko, D., Philbin, J.: FaceNet: a unified embedding for face recognition and clustering. In: Proceeding of the IEEE Conference on Computer Vision Pattern Recognition, pp. 815-823 (2015)-","DOI":"10.1109\/CVPR.2015.7298682"},{"key":"26_CR23","doi-asserted-by":"crossref","unstructured":"Reimers, N., Gurevych, I.: Sentence-BERT: sentence embeddings using siamese BERT-networks. In: Proceedings of the Conference on Empirical Methods Natural Language Process, pp. 3980\u20133990 (2019)","DOI":"10.18653\/v1\/D19-1410"},{"key":"26_CR24","doi-asserted-by":"crossref","unstructured":"Iyer, S., Konstas, I., Cheung, A., Krishnamurthy, J., Zettlemoyer, L.: Learning a neural semantic parser from user feedback. In: Association for Computational Linguistics, pp. 963\u2013973 (2017)","DOI":"10.18653\/v1\/P17-1089"},{"key":"26_CR25","unstructured":"Kingma, D.P., Ba, J.: Adam: a method for stochastic optimization. In: Proceedings of the International Conference on Learning Representations (2015)"},{"key":"26_CR26","unstructured":"Liu, Y., et al.: RoBERTa: a robustly optimized BERT pretraining approach. arXiv preprint arXiv:1907.11692 (2019)"},{"issue":"3","key":"26_CR27","doi-asserted-by":"publisher","first-page":"535","DOI":"10.1109\/TBDATA.2019.2921572","volume":"7","author":"J Johnson","year":"2021","unstructured":"Johnson, J., Douze, M., J\u00e9gou, H.: Billion-scale similarity search with GPUs. IEEE Trans. Big Data 7(3), 535\u2013547 (2021)","journal-title":"IEEE Trans. Big Data"},{"key":"26_CR28","unstructured":"Pobrotyn, P., Bialobrzeski, R.: NeuralNDCG: direct optimisation of a ranking metric via differentiable relaxation of sorting. arXiv preprint arXiv:2102.07831 (2021)"},{"key":"26_CR29","doi-asserted-by":"crossref","unstructured":"Hull, D.A.: Xerox TREC-8 question answering track report. In: TREC (1999)","DOI":"10.6028\/NIST.SP.500-246.qa-xerox"},{"key":"26_CR30","unstructured":"SQLNet. Generating structured queries from natural language without reinforcement learning. arXiv (2017)"},{"key":"26_CR31","unstructured":"From databases to natural language: the unusual direction. In: Proceedings of the International Conference on Application Natural Language Information System, pp. 12\u201316 (2008)"},{"key":"26_CR32","unstructured":"DBMSs should talk back too. In: Conference on Innovative Data System Research (2009)"},{"key":"26_CR33","doi-asserted-by":"crossref","unstructured":"Shu, C., Zhang, Y., Dong, X., Shi, P., Yu, T., Zhang, R.: Logic-consistency text generation from semantic parses. In: Association for Computational Linguistics, pp. 4414\u20134426 (2021)","DOI":"10.18653\/v1\/2021.findings-acl.388"},{"key":"26_CR34","doi-asserted-by":"crossref","unstructured":"Yang, L., et al.: Beyond factoid QA: effective methods for non-factoid answer sentence retrieval. In: Proceedings of the 38th European Conference on Information Retrieval, pp. 115\u2013128 (2016)","DOI":"10.1007\/978-3-319-30671-1_9"},{"key":"26_CR35","unstructured":"Duan, Y., Jiang, L., Qin, T., Zhou, M., Shum, H.: An empirical study on learning to rank of tweets. In: Proceeding of the International Conference on Computational Linguistics, pp. 295\u2013303 (2010)"},{"key":"26_CR36","doi-asserted-by":"crossref","unstructured":"Learning to Rank for Information Retrieval, pp. 1\u2013285. Springer (2011)","DOI":"10.1007\/978-3-031-02141-1_1"},{"key":"26_CR37","doi-asserted-by":"crossref","unstructured":"Iyer, S., Konstas, I., Cheung, A., Zettlemoyer, L.: Summarizing source code using a neural attention model. Association for Computational Linguistics (2016)","DOI":"10.18653\/v1\/P16-1195"},{"key":"26_CR38","doi-asserted-by":"crossref","unstructured":"Sun, X., Tang, H., Zhang, F., Cui, Y., Jin, B., Wang, Z.: TABLE: a task-adaptive BERT-based ListwisE ranking model for document retrieval. In: Proceedings of the ACM 29th International Conference on Information Knowledge Management, pp. 2233\u20132236 (2020)","DOI":"10.1145\/3340531.3412071"},{"key":"26_CR39","doi-asserted-by":"crossref","unstructured":"Cao, Z. , Qin, T., Liu, T., Tsai, M., Li, H.: Learning to rank: from pairwise approach to listwise approach. In: Proceedings International Conference on Machine Learning, pp. 129\u2013136 (2007)","DOI":"10.1145\/1273496.1273513"},{"issue":"4","key":"26_CR40","doi-asserted-by":"publisher","first-page":"422","DOI":"10.1145\/362686.362692","volume":"13","author":"BH Bloom","year":"1970","unstructured":"Bloom, B.H.: Space\/time trade-offs in hash coding with allowable errors. Commun. ACM 13(4), 422\u2013426 (1970)","journal-title":"Commun. ACM"},{"key":"26_CR41","unstructured":"Raffel, C., et al.: Exploring the limits of transfer learning with a unified text-to-text transformer. J. Mach. Learn. Res. 21, 140:1\u2013140:67 (2020)"},{"key":"26_CR42","unstructured":"Sun, R., et al.: SQL-PaLM: improved large language model adaptation for text-to-SQL. arXiv preprint arXiv:2306.00739 (2023)"},{"key":"26_CR43","doi-asserted-by":"crossref","unstructured":"Simitsis, A., Koutrika, G.: Comprehensible answers to pr\u00e9cis qeries. In: International Conference on Advanced Information System Engineering, pp. 142\u2013156 (2006)","DOI":"10.1007\/11767138_11"},{"key":"26_CR44","doi-asserted-by":"crossref","unstructured":"Simitsis, A., Koutrika, G., Alexandrakis, Y., Ioannidis, Y.E.: Synthesizing structured text from logical database subsets. In: International Conference Extended Database Technology, pp. 428\u2013439 (2008)","DOI":"10.1145\/1353343.1353396"},{"key":"26_CR45","doi-asserted-by":"crossref","unstructured":"Zhuang, H., et al.: RankT5: fine-tuning T5 for text ranking with ranking losses. arXiv preprint arXiv:2210.10634 (2022)","DOI":"10.1145\/3539618.3592047"},{"key":"26_CR46","doi-asserted-by":"crossref","unstructured":"Yates, A., Nogueira, R.F., Lin, J.: Pretrained transformers for text ranking: BERT and beyond. In: Proceedings of the ACM SIGIR International Conference on Research and Development in Information Retrieval, pp. 2666\u20132668 (2021)","DOI":"10.1145\/3404835.3462812"},{"key":"26_CR47","doi-asserted-by":"crossref","unstructured":"Lin, J., Nogueira, R.F., Yates, A.: Pretrained transformers for text ranking, BERT and beyond. arXiv preprint arXiv:2010.06467 (2020)","DOI":"10.2200\/S01123ED1V01Y202108HLT053"},{"key":"26_CR48","doi-asserted-by":"crossref","unstructured":"Nogueira, R.F., Jiang, Z., Pradeep, R., Lin, J.: Document ranking with a pretrained sequence-to-sequence model. In: Proceedings of the Conference on Empirical Methods Natural Language Process, pp. 708\u2013718 (2020)","DOI":"10.18653\/v1\/2020.findings-emnlp.63"},{"key":"26_CR49","doi-asserted-by":"crossref","unstructured":"Ju, J., Yang, J., Wang, C.: Text-to-text multi-view learning for passage re-ranking. In: Proceedings of the ACM SIGIR International Conference on Research and Development in Information Retrieval, pp. 1803\u20131807 (2021)","DOI":"10.1145\/3404835.3463048"},{"key":"26_CR50","doi-asserted-by":"crossref","unstructured":"Li, H., Zhang, J., Li, C., Chen, H.: Decoupling schema linking and skeleton parsing for text-to-SQL. In: Proceedings of the AAAI Conference on Artificial Intelligence, pp. 13067\u201313075 (2023)","DOI":"10.1609\/aaai.v37i11.26535"},{"key":"26_CR51","unstructured":"Brown, T.B., Mann, B., Ryder, N., et al.: Language models are few-shot learners. In: Proceedings of the Advances Neural Informational Processing System (2020)"},{"key":"26_CR52","doi-asserted-by":"crossref","unstructured":"Rajbhandari, S., Rasley, J., Ruwase, O., He, Y.: ZeRO: memory optimizations toward training trillion parameter models. In: International Conference on High Perfomence Computer Network Storage Analysis, vol. 20 (2020)","DOI":"10.1109\/SC41405.2020.00024"},{"key":"26_CR53","doi-asserted-by":"crossref","unstructured":"Fan, Y., et al.: MetaSQL: a generate-then-rank framework for natural language to SQL translation. arXiv preprint arXiv:2402.17144 (2024)","DOI":"10.1109\/ICDE60146.2024.00143"},{"key":"26_CR54","doi-asserted-by":"crossref","unstructured":"Ren, T., et al.: PURPLE: making a large language model a better SQL writer. arXiv preprint arXiv:2403.20014 (2024)","DOI":"10.1109\/ICDE60146.2024.00009"},{"key":"26_CR55","unstructured":"Pourreza, M., Rafiei, D.: DIN-SQL: decomposed in-context learning of text-to-SQL with self-correction. In: Proceedings of the Advances Neural Information Processing System (2023)"},{"key":"26_CR56","unstructured":"Wang, B., et al.: MAC-SQL: a multi-agent collaborative framework for text-to-SQL. arXiv preprint arXiv:2312.11242 (2023)"},{"key":"26_CR57","doi-asserted-by":"crossref","unstructured":"Li, H., et al.: CodeS: towards building open-source language models for text-to-SQL. arXiv preprint arXiv:2402.16347 (2024)","DOI":"10.1145\/3654930"}],"container-title":["Lecture Notes in Computer Science","Web and Big Data"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-981-97-7238-4_26","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,8,27]],"date-time":"2024-08-27T16:16:38Z","timestamp":1724775398000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-981-97-7238-4_26"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024]]},"ISBN":["9789819772377","9789819772384"],"references-count":57,"URL":"https:\/\/doi.org\/10.1007\/978-981-97-7238-4_26","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":"28 August 2024","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"APWeb-WAIM","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Asia-Pacific Web (APWeb) and Web-Age Information Management (WAIM) Joint International Conference on Web and Big Data","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Jinhua","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"China","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":"31 August 2024","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2 September 2024","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"8","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"apwebwaim2024","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/apweb2024.zjnu.edu.cn\/","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}