Heuristics-Based SQL Query Generation Engine

Author(s):  
Chinthani Sugandhika ◽  
Supunmali Ahangama
Keyword(s):  
Author(s):  
Yu Zeng ◽  
Yan Gao ◽  
Jiaqi Guo ◽  
Bei Chen ◽  
Qian Liu ◽  
...  

Neural semantic parsers usually fail to parse long and complicated utterances into nested SQL queries, due to the large search space. In this paper, we propose a novel recursive semantic parsing framework called RECPARSER to generate the nested SQL query layer-by-layer. It decomposes the complicated nested SQL query generation problem into several progressive non-nested SQL query generation problems. Furthermore, we propose a novel Question Decomposer module to explicitly encourage RECPARSER to focus on different components of an utterance when predicting SQL queries of different layers. Experiments on the Spider dataset show that our approach is more effective compared to the previous works at predicting the nested SQL queries. In addition, we achieve an overall accuracy that is comparable with state-of-the-art approaches.


Author(s):  
Christoher E. Gillies ◽  
Nilesh Patel ◽  
Gautam B. Singh ◽  
Serge G. Kruk ◽  
Eddie Cheng ◽  
...  

Author(s):  
Kiran Raj R

Today, everyone has a personal device to access the web. Every user tries to access the knowledge that they require through internet. Most of the knowledge is within the sort of a database. A user with limited knowledge of database will have difficulty in accessing the data in the database. Hence, there’s a requirement for a system that permits the users to access the knowledge within the database. The proposed method is to develop a system where the input be a natural language and receive an SQL query which is used to access the database and retrieve the information with ease. Tokenization, parts-of-speech tagging, lemmatization, parsing and mapping are the steps involved in the process. The project proposed would give a view of using of Natural Language Processing (NLP) and mapping the query in accordance with regular expression in English language to SQL.


2019 ◽  
Author(s):  
Rui Zhang ◽  
Tao Yu ◽  
Heyang Er ◽  
Sungrok Shim ◽  
Eric Xue ◽  
...  

2020 ◽  
Author(s):  
Jianqiang Ma ◽  
Zeyu Yan ◽  
Shuai Pang ◽  
Yang Zhang ◽  
Jianping Shen
Keyword(s):  

2021 ◽  
Vol 1873 (1) ◽  
pp. 012065
Author(s):  
Huiran Zhang ◽  
Cheng Zhang ◽  
Rui Hu ◽  
Xi Liu ◽  
Dongbo Dai

Sign in / Sign up

Export Citation Format

Share Document