دورية أكاديمية

Improving Text-to-SQL with a Hybrid Decoding Method

التفاصيل البيبلوغرافية
العنوان: Improving Text-to-SQL with a Hybrid Decoding Method
المؤلفون: Geunyeong Jeong, Mirae Han, Seulgi Kim, Yejin Lee, Joosang Lee, Seongsik Park, Harksoo Kim
المصدر: Entropy, Vol 25, Iss 3, p 513 (2023)
بيانات النشر: MDPI AG, 2023.
سنة النشر: 2023
المجموعة: LCC:Science
LCC:Astrophysics
LCC:Physics
مصطلحات موضوعية: semantic parsing, text-to-SQL, pointer network, natural language processing, Science, Astrophysics, QB460-466, Physics, QC1-999
الوصف: Text-to-SQL is a task that converts natural language questions into SQL queries. Recent text-to-SQL models employ two decoding methods: sketch-based and generation-based, but each has its own shortcomings. The sketch-based method has limitations in performance as it does not reflect the relevance between SQL elements, while the generation-based method may increase inference time and cause syntactic errors. Therefore, we propose a novel decoding method, Hybrid decoder, which combines both methods. This reflects inter-SQL element information and defines elements that can be generated, enabling the generation of syntactically accurate SQL queries. Additionally, we introduce a Value prediction module for predicting values in the WHERE clause. It simplifies the decoding process and reduces the size of vocabulary by predicting values at once, regardless of the number of conditions. The results of evaluating the significance of Hybrid decoder indicate that it improves performance by effectively incorporating mutual information among SQL elements, compared to the sketch-based method. It also efficiently generates SQL queries by simplifying the decoding process in the generation-based method. In addition, we design a new evaluation measure to evaluate if it generates syntactically correct SQL queries. The result demonstrates that the proposed model generates syntactically accurate SQL queries.
نوع الوثيقة: article
وصف الملف: electronic resource
اللغة: English
تدمد: 1099-4300
Relation: https://www.mdpi.com/1099-4300/25/3/513; https://doaj.org/toc/1099-4300
DOI: 10.3390/e25030513
URL الوصول: https://doaj.org/article/903d3eaf14614024b9cde0b5cb8a924c
رقم الأكسشن: edsdoj.903d3eaf14614024b9cde0b5cb8a924c
قاعدة البيانات: Directory of Open Access Journals
الوصف
تدمد:10994300
DOI:10.3390/e25030513