Technical Research of Graph Neural Network for Text-to-SQL Parsing
The Text-to-SQL task in the field of semantic parsing is of great significance for realizing database-based automatic question and answer.At present, deep learning models, such as sequence generation model Seq2Seq, has achieved significant effects in single-table SQL queries.However, the problem of...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | zho |
| Published: |
Editorial office of Computer Science
2022-04-01
|
| Series: | Jisuanji kexue |
| Subjects: | |
| Online Access: | https://www.jsjkx.com/fileup/1002-137X/PDF/1002-137X-2022-49-4-110.pdf |
| _version_ | 1811244469313339392 |
|---|---|
| author | CAO He-xin, ZHAO Liang, LI Xue-feng |
| author_facet | CAO He-xin, ZHAO Liang, LI Xue-feng |
| author_sort | CAO He-xin, ZHAO Liang, LI Xue-feng |
| collection | DOAJ |
| description | The Text-to-SQL task in the field of semantic parsing is of great significance for realizing database-based automatic question and answer.At present, deep learning models, such as sequence generation model Seq2Seq, has achieved significant effects in single-table SQL queries.However, the problem of multi-table SQL queries remains to be solved.Graph neural network can effectively extract the associated information between databases, tables and questions, enrich the semantic information in the parsing process, and improve the accuracy of multi-table SQL queries.This paper proposes an adaptive graph construction method and graph encoding method.Question information is introduced into the existing Text-to-SQL model, and the graph network initialized weights are generated by convolution operation on the splicing word vector of the question sentence and the database.General training can be achieved for different databases of the same type.The IRNet framework and relational expansion are used to design the overall model, and it is verified on the open Text-to-SQL data set——Spider.Results show that the technology can effectively improve the matching accuracy of multi-table SQL statement generation, and the algorithm has an important reference value for the research of graph neural network in the text-to-SQL field. |
| first_indexed | 2024-04-12T14:25:35Z |
| format | Article |
| id | doaj.art-b198f659236847c8bf496450e7bae11e |
| institution | Directory Open Access Journal |
| issn | 1002-137X |
| language | zho |
| last_indexed | 2024-04-12T14:25:35Z |
| publishDate | 2022-04-01 |
| publisher | Editorial office of Computer Science |
| record_format | Article |
| series | Jisuanji kexue |
| spelling | doaj.art-b198f659236847c8bf496450e7bae11e2022-12-22T03:29:28ZzhoEditorial office of Computer ScienceJisuanji kexue1002-137X2022-04-0149411011510.11896/jsjkx.210200173Technical Research of Graph Neural Network for Text-to-SQL ParsingCAO He-xin, ZHAO Liang, LI Xue-feng01 College of Electronic and Information Engineering, Tongji University, Shanghai 201804, China;<br/>2 College of Information Science and Engineering, East China University of Science and Technology, Shanghai 200237, ChinaThe Text-to-SQL task in the field of semantic parsing is of great significance for realizing database-based automatic question and answer.At present, deep learning models, such as sequence generation model Seq2Seq, has achieved significant effects in single-table SQL queries.However, the problem of multi-table SQL queries remains to be solved.Graph neural network can effectively extract the associated information between databases, tables and questions, enrich the semantic information in the parsing process, and improve the accuracy of multi-table SQL queries.This paper proposes an adaptive graph construction method and graph encoding method.Question information is introduced into the existing Text-to-SQL model, and the graph network initialized weights are generated by convolution operation on the splicing word vector of the question sentence and the database.General training can be achieved for different databases of the same type.The IRNet framework and relational expansion are used to design the overall model, and it is verified on the open Text-to-SQL data set——Spider.Results show that the technology can effectively improve the matching accuracy of multi-table SQL statement generation, and the algorithm has an important reference value for the research of graph neural network in the text-to-SQL field.https://www.jsjkx.com/fileup/1002-137X/PDF/1002-137X-2022-49-4-110.pdftext-to-sql parsing|deep learning|graph construction|graph neural network|multi-table sql statement generation |
| spellingShingle | CAO He-xin, ZHAO Liang, LI Xue-feng Technical Research of Graph Neural Network for Text-to-SQL Parsing Jisuanji kexue text-to-sql parsing|deep learning|graph construction|graph neural network|multi-table sql statement generation |
| title | Technical Research of Graph Neural Network for Text-to-SQL Parsing |
| title_full | Technical Research of Graph Neural Network for Text-to-SQL Parsing |
| title_fullStr | Technical Research of Graph Neural Network for Text-to-SQL Parsing |
| title_full_unstemmed | Technical Research of Graph Neural Network for Text-to-SQL Parsing |
| title_short | Technical Research of Graph Neural Network for Text-to-SQL Parsing |
| title_sort | technical research of graph neural network for text to sql parsing |
| topic | text-to-sql parsing|deep learning|graph construction|graph neural network|multi-table sql statement generation |
| url | https://www.jsjkx.com/fileup/1002-137X/PDF/1002-137X-2022-49-4-110.pdf |
| work_keys_str_mv | AT caohexinzhaolianglixuefeng technicalresearchofgraphneuralnetworkfortexttosqlparsing |