{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,2,21]],"date-time":"2025-02-21T07:20:17Z","timestamp":1740122417284,"version":"3.37.3"},"reference-count":38,"publisher":"Springer Science and Business Media LLC","issue":"2","license":[{"start":{"date-parts":[[2022,9,6]],"date-time":"2022-09-06T00:00:00Z","timestamp":1662422400000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2022,9,6]],"date-time":"2022-09-06T00:00:00Z","timestamp":1662422400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"}],"funder":[{"DOI":"10.13039\/501100001809","name":"National Natural Science Foundation of China","doi-asserted-by":"publisher","award":["61772200"],"award-info":[{"award-number":["61772200"]}],"id":[{"id":"10.13039\/501100001809","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/100007219","name":"Natural Science Foundation of Shanghai","doi-asserted-by":"publisher","award":["21ZR1416300"],"award-info":[{"award-number":["21ZR1416300"]}],"id":[{"id":"10.13039\/100007219","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Autom Softw Eng"],"published-print":{"date-parts":[[2022,11]]},"DOI":"10.1007\/s10515-022-00359-5","type":"journal-article","created":{"date-parts":[[2022,9,6]],"date-time":"2022-09-06T13:02:41Z","timestamp":1662469361000},"update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":1,"title":["HQLgen: deep learning based HQL query generation from program context"],"prefix":"10.1007","volume":"29","author":[{"given":"Ziyi","family":"Zhou","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-1899-1135","authenticated-orcid":false,"given":"Huiqun","family":"Yu","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Guisheng","family":"Fan","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zijie","family":"Huang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Kang","family":"Yang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jiayin","family":"Zhang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2022,9,6]]},"reference":[{"issue":"1","key":"359_CR1","doi-asserted-by":"publisher","first-page":"29","DOI":"10.1017\/S135132490000005X","volume":"1","author":"I Androutsopoulos","year":"1995","unstructured":"Androutsopoulos, I., Ritchie, G.D., Thanisch, P.: Natural language interfaces to databases - an introduction. Nat. Lang. Eng. 1(1), 29\u201381 (1995)","journal-title":"Nat. Lang. Eng."},{"key":"359_CR2","unstructured":"Androutsopoulos, I., Ritchie, G., Thanisch, P.: Masque\/sql: An efficient and portable natural language query interface for relational databases. In: Proceedings of the 6th International Conference on Industrial and Engineering Applications of Artificial Intelligence and Expert Systems. IEA\/AIE\u201993, pp. 327\u2013330. Gordon amp; Breach Science Publishers (1993)"},{"key":"359_CR3","doi-asserted-by":"crossref","unstructured":"Bogin, B., Gardner, M., Berant, J.: Global reasoning over database structures for text-to-sql parsing. In: Inui, K., Jiang, J., Ng, V., Wan, X. (eds.) Proceedings of the 2019 Conference on Empirical Methods in Natural Language Processing and the 9th International Joint Conference on Natural Language Processing, EMNLP-IJCNLP 2019, Hong Kong, China, November 3\u20137, 2019, pp. 3657\u20133662. Association for Computational Linguistics (2019)","DOI":"10.18653\/v1\/D19-1378"},{"key":"359_CR4","doi-asserted-by":"crossref","unstructured":"Chen, T.-H., Shang, W., Hassan, A.E., Nasser, M.N., Flora, P.: Cacheoptimizer: helping developers configure caching frameworks for hibernate-based database-centric web applications. In: Proceedings of the 24th ACM SIGSOFT International Symposium on Foundations of Software Engineering (FSE), pp. 666\u2013677 (2016a)","DOI":"10.1145\/2950290.2950303"},{"key":"359_CR5","doi-asserted-by":"crossref","unstructured":"Chen, T.-H., Shang, W., Yang, J., Hassan, A.E., Godfrey, M.W., Nasser,M., Flora, P.: An empirical study on the practice of maintaining object-relational mapping code in Java systems. In: Proceedings of the 13th International Conference on Mining Software Repositories (MSR), pp. 165\u2013176 (2016b)","DOI":"10.1145\/2901739.2901758"},{"key":"359_CR6","doi-asserted-by":"crossref","unstructured":"Cho, K., van Merrienboer, B., Gu\u00a8l\u00b8cehre, C\u00b8., Bahdanau, D., Bougares, F., Schwenk, H., Bengio, Y.: Learning phrase representations using RNN encoder-decoder for statistical machine translation. In: Moschitti, A., Pang, B., Daelemans, W. (eds.) Proceedings of the 2014 Conference on Empirical Methods in Natural Language Processing, EMNLP 2014, October 25\u201329, 2014, Doha, Qatar, A Meeting of SIGDAT, a Special Interest Group of the ACL, pp. 1724\u20131734. ACL (2014)","DOI":"10.3115\/v1\/D14-1179"},{"key":"359_CR7","doi-asserted-by":"crossref","unstructured":"Cook, W.R., Greene, R., Linskey, P., Meijer, E., Rugg, K., Russell, C., Walker, B., Wittig, C.: Objects and databases: State of the union in 2006. In: Companion to the 21st ACM SIGPLAN Symposium on Object-Oriented Programming Systems, Languages, and Applications (OOPSLA), pp. 926\u2013928 (2006)","DOI":"10.1145\/1176617.1176746"},{"issue":"3","key":"359_CR8","doi-asserted-by":"publisher","first-page":"10","DOI":"10.1109\/MS.2005.71","volume":"22","author":"M Di Giacomo","year":"2005","unstructured":"Di Giacomo, M.: MySQL: lessons learned on a digital library. IEEE Softw. 22(3), 10\u201313 (2005)","journal-title":"IEEE Softw."},{"issue":"1","key":"359_CR9","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/2803171","volume":"25","author":"R Dyer","year":"2015","unstructured":"Dyer, R., Nguyen, H.A., Rajan, H., Nguyen, T.N.: Boa: ultra-large-scale software repository and source-code mining. ACM Trans. Softw. Eng. Methodol. 25(1), 1\u201334 (2015)","journal-title":"ACM Trans. Softw. Eng. Methodol."},{"key":"359_CR10","unstructured":"Glorot, X., Bengio, Y.: Understanding the difficulty of training deep feedforward neural networks. In: Teh, Y.W., Titterington, D.M. (eds.) Proceedings of the Thirteenth International Conference on Artificial Intelligence and Statistics, AISTATS 2010, Chia Laguna Resort, Sardinia, Italy, May 13\u201315, 2010. JMLR Proceedings, vol. 9, pp. 249\u2013256. JMLR.org (2010)"},{"issue":"8","key":"359_CR11","doi-asserted-by":"publisher","first-page":"1735","DOI":"10.1162\/neco.1997.9.8.1735","volume":"9","author":"S Hochreiter","year":"1997","unstructured":"Hochreiter, S., Schmidhuber, J.: Long short-term memory. Neural Comput. 9(8), 1735\u20131780 (1997)","journal-title":"Neural Comput."},{"key":"359_CR12","doi-asserted-by":"crossref","unstructured":"Iyer, S., Konstas, I., Cheung, A., Krishnamurthy, J., Zettlemoyer, L.: Learning a neural semantic parser from user feedback. In: Barzilay, R., Kan, M. (eds.) Proceedings of the 55th Annual Meeting of the Association for Computational Linguistics, ACL 2017, Vancouver, Canada, July 30\u2013August 4, vol. 1: Long Papers, pp. 963\u2013973. Association for Computational Linguistics (2017)","DOI":"10.18653\/v1\/P17-1089"},{"key":"359_CR13","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, San Diego, CA, USA, May 7\u20139, 2015, Conference Track Proceedings (2015)"},{"key":"359_CR14","doi-asserted-by":"crossref","unstructured":"Li, R., Liang, P., Soliman, M., Avgeriou, P.: Understanding architecture erosion: The practitioners\u2019 perceptive. In: Proceedings of the IEEE\/ACM 29th International Conference on Program Comprehension (ICPC), pp. 311\u2013322 (2021)","DOI":"10.1109\/ICPC52881.2021.00037"},{"issue":"1","key":"359_CR15","doi-asserted-by":"publisher","first-page":"73","DOI":"10.14778\/2735461.2735468","volume":"8","author":"F Li","year":"2014","unstructured":"Li, F., Jagadish, H.V.: Constructing an interactive natural language interface for relational databases. Proc. VLDB Endow. 8(1), 73\u201384 (2014)","journal-title":"Proc. VLDB Endow."},{"key":"359_CR16","doi-asserted-by":"crossref","unstructured":"Loli, S., Teixeira, L., Cartaxo, B.: A catalog of object-relational mapping code smells for Java. In: Proceedings of the 34th Brazilian Symposium on Software Engineering (SBES), pp. 82\u201391 (2020)","DOI":"10.1145\/3422392.3422432"},{"key":"359_CR17","doi-asserted-by":"crossref","unstructured":"Meurice, L., Nagy, C., Cleve, A.: Detecting and preventing program inconsistencies under database schema evolution. In: Proceedings of the IEEE 16th International Conference on Software Quality, Reliability and Security (QRS), pp. 262\u2013273 (2016)","DOI":"10.1109\/QRS.2016.38"},{"key":"359_CR18","doi-asserted-by":"crossref","unstructured":"Nagy, C., Cleve, A.: Mining stack overflow for discovering error patterns in SQL queries. In: Proceedings of the IEEE International Conference on Software Maintenance and Evolution (ICSME), pp. 516\u2013520 (2015)","DOI":"10.1109\/ICSM.2015.7332505"},{"key":"359_CR19","doi-asserted-by":"crossref","unstructured":"Nagy, C., Cleve, A.: A static code smell detector for SQL queries embedded in Java code. In: Proceedings of the IEEE 17th International Working Conference on Source Code Analysis and Manipulation (SCAM), pp. 147\u2013152 (2017)","DOI":"10.1109\/SCAM.2017.19"},{"key":"359_CR20","doi-asserted-by":"crossref","unstructured":"Nagy, C., Meurice, L., Cleve, A.: Where was this SQL query executed? A static concept location approach. In: Proceedings of the IEEE 22nd International Conference on Software Analysis, Evolution, and Reengineering (SANER), pp. 580\u2013584 (2015)","DOI":"10.1109\/SANER.2015.7081881"},{"key":"359_CR21","unstructured":"Nair, V., Hinton, G.E.: Rectified linear units improve restricted boltzmann machines. In: Fu\u00a8rnkranz, J., Joachims, T. (eds.) Proceedings of the 27th International Conference on Machine Learning (ICML-10), June 21\u201324, 2010, Haifa, Israel, pp. 807\u2013814. Omnipress (2010)"},{"key":"359_CR22","doi-asserted-by":"crossref","unstructured":"Nazario, M.F.C., Guerra, E., Bonifacio, R., Pinto, G.: Detecting and reporting object-relational mapping problems: an industrial report. In: Proceedings of ACM\/IEEE 13th International Symposium on Empirical Software Engineering and Measurement (ESEM), pp. 1\u20136 (2019)","DOI":"10.1109\/ESEM.2019.8870163"},{"key":"359_CR23","doi-asserted-by":"crossref","unstructured":"Popescu, A., Etzioni, O., Kautz, H.A.: Towards a theory of natural language interfaces to databases. In: Leake, D.B., Johnson, W.L., Andr\u00b4e, E. (eds.) Proceedings of the 8th International Conference on Intelligent User Interfaces, IUI 2003, Miami, FL, USA, January 12\u201315, 2003, pp. 149\u2013157. ACM (2003)","DOI":"10.1145\/604045.604120"},{"key":"359_CR24","doi-asserted-by":"crossref","unstructured":"Presler-Marshall, K., Heckman, S., Stolee, K.: SQLRepair: Identifying and repairing mistakes in student-authored SQL queries. In: Proceedings of the IEEE\/ACM 43rd International Conference on Software Engineering: Software Engineering Education and Training (ICSE-SEET), pp. 199\u2013210 (2021)","DOI":"10.1109\/ICSE-SEET52601.2021.00030"},{"key":"359_CR25","doi-asserted-by":"crossref","unstructured":"Procaccianti, G., Lago, P., Diesveld, W.: Energy efficiency of ORM approaches: an empirical evaluation. In: Proceedings of the 10th ACM\/IEEE International Symposium on Empirical Software Engineering and Measurement (ESEM), pp. 36\u201313610 (2016)","DOI":"10.1145\/2961111.2962586"},{"key":"359_CR26","doi-asserted-by":"crossref","unstructured":"Silva, T.M., Serey, D., de Figueiredo, J.C.A., Brunet, J.: Automated design tests to check hibernate design recommendations. In: Proceedings of the 33rd Brazilian Symposium on Software Engineering (SBES), pp. 94\u2013103 (2019)","DOI":"10.1145\/3350768.3351796"},{"key":"359_CR27","doi-asserted-by":"crossref","unstructured":"Singh, R., Bezemer, C., Shang, W., Hassan, A.E.: Optimizing the performance-related configurations of object-relational mapping frameworks using a multi-objective genetic algorithm. In: Proceedings of the 7th ACM\/SPEC International Conference on Performance Engineering (ICPE), pp. 309\u2013320 (2016)","DOI":"10.1145\/2851553.2851576"},{"key":"359_CR28","unstructured":"Sridhara, G., Hill, E., Muppaneni, D., Pollock, L.L., Vijay-Shanker, K.: Towards automatically generating summary comments for java methods. In: Pecheur, C., Andrews, J., Nitto, E.D. (eds.) ASE 2010, 25th IEEE\/ACM International Conference on Automated Software Engineering, Antwerp, Belgium, September 20\u201324, 2010, pp. 43\u201352. ACM (2010)"},{"key":"359_CR29","unstructured":"Sutskever, I., Vinyals, O., Le, Q.V.: Sequence to sequence learn- ing with neural networks. In: Ghahramani, Z., Welling, M., Cortes, C., Lawrence, N.D., Weinberger, K.Q. (eds.) Advances in Neural Information Processing Systems 27: Annual Conference on Neural Information Processing Systems 2014, December 8\u201313 2014, Montreal, Quebec, Canada, pp. 3104\u20133112 (2014)"},{"issue":"6","key":"359_CR30","doi-asserted-by":"publisher","first-page":"43","DOI":"10.1109\/MS.2018.227105428","volume":"36","author":"G Vial","year":"2019","unstructured":"Vial, G.: Lessons in persisting object data using object-relational mapping. IEEE Softw. 36(6), 43\u201352 (2019)","journal-title":"IEEE Softw."},{"key":"359_CR31","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: Jurafsky, D., Chai, J., Schluter, N., Tetreault, J.R. (eds.) Proceedings of the 58th Annual Meeting of the Association for Computational Linguistics, ACL 2020, Online, July 5\u201310, 2020, pp. 7567\u20137578. Association for Computational Linguistics (2020)","DOI":"10.18653\/v1\/2020.acl-main.677"},{"issue":"3\u20134","key":"359_CR32","first-page":"110","volume":"8","author":"DHD Warren","year":"1982","unstructured":"Warren, D.H.D., Pereira, F.C.N.: An efficient easily adaptable system for interpreting natural language queries. Am. J. Comput. Linguist. 8(3\u20134), 110\u2013122 (1982)","journal-title":"Am. J. Comput. Linguist."},{"key":"359_CR33","unstructured":"Xu, X., Liu, C., Song, D.: Sqlnet: Generating structured queries from natural language without reinforcement learning. CoRR https:\/\/arxiv.org\/abs\/1711.04436 (2017)"},{"issue":"OOPSLA","key":"359_CR34","doi-asserted-by":"publisher","first-page":"63","DOI":"10.1145\/3133887","volume":"1","author":"N Yaghmazadeh","year":"2017","unstructured":"Yaghmazadeh, N., Wang, Y., Dillig, I., Dillig, T.: Sqlizer: query synthesisfrom natural language. Proc. ACM Program. Lang. 1(OOPSLA), 63\u201316326 (2017)","journal-title":"Proc. ACM Program. Lang."},{"key":"359_CR35","doi-asserted-by":"crossref","unstructured":"Yu, T., Li, Z., Zhang, Z., Zhang, R., Radev, D.R.: Typesql: Knowledge-based type-aware neural text-to-sql generation. In: Walker, M.A., Ji, H., Stent, A. (eds.) Proceedings of the 2018 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies, NAACL-HLT, New Orleans, Louisiana, USA, June 1\u20136, 2018, vol. 2 (Short Papers), pp. 588\u2013594. Association for Computational Linguistics (2018a)","DOI":"10.18653\/v1\/N18-2093"},{"key":"359_CR36","doi-asserted-by":"crossref","unstructured":"Yu, T., Yasunaga, M., Yang, K., Zhang, R., Wang, D., Li, Z., Radev, D.R.: Syntaxsqlnet: Syntax tree networks for complex and cross-domain text-to-sql task. In: Riloff, E., Chiang, D., Hockenmaier, J., Tsujii, J. (eds.) Proceedings of the 2018 Conference on Empirical Methods in Natural Language Processing, Brussels, Belgium, October 31\u2013November 4, 2018, pp. 1653\u20131663. Association for Computational Linguistics (2018b)","DOI":"10.18653\/v1\/D18-1193"},{"key":"359_CR37","doi-asserted-by":"crossref","unstructured":"Yu, T., Zhang, R., Yang, K., Yasunaga, M., Wang, D., Li, Z., Ma, J., Li, I., Yao, Q., Roman, S., Zhang, Z., Radev, D.R.: Spider: A large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-sql task. In: Riloff, E., Chiang, D., Hockenmaier, J., Tsujii, J. (eds.) Proceedings of the 2018 Conference on Empirical Methods in Natural Language Processing, Brussels, Belgium, October 31 - November 4, 2018, pp. 3911\u20133921. Association for Computational Linguistics (2018c)","DOI":"10.18653\/v1\/D18-1425"},{"key":"359_CR38","unstructured":"Zhong, V., Xiong, C., Socher, R.: Seq2sql: Generating structured queries from natural language using reinforcement learning. CoRR abs\/1709.00103 (2017)"}],"container-title":["Automated Software Engineering"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10515-022-00359-5.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s10515-022-00359-5\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10515-022-00359-5.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,10,28]],"date-time":"2022-10-28T11:28:31Z","timestamp":1666956511000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s10515-022-00359-5"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,9,6]]},"references-count":38,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2022,11]]}},"alternative-id":["359"],"URL":"https:\/\/doi.org\/10.1007\/s10515-022-00359-5","relation":{},"ISSN":["0928-8910","1573-7535"],"issn-type":[{"type":"print","value":"0928-8910"},{"type":"electronic","value":"1573-7535"}],"subject":[],"published":{"date-parts":[[2022,9,6]]},"assertion":[{"value":"30 November 2021","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"10 August 2022","order":2,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"6 September 2022","order":3,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}},{"order":1,"name":"Ethics","group":{"name":"EthicsHeading","label":"Declarations"}},{"value":"The authors have no conflict of interests to declare.","order":2,"name":"Ethics","group":{"name":"EthicsHeading","label":"Conflict of interest"}}],"article-number":"55"}}