paper-with-me

Papers

SQLNet: Generating Structured Queries From Natural Language Without Reinforcement Learning

2017-11-13 · ICLR 2018 1 · Xiaojun Xu, Chang Liu, Dawn Song

Synthesizing SQL queries from natural language is a long-standing open problem and has been attracting considerable interest recently. Toward solving the problem, the de facto approach is to employ a sequence-to-sequence-style model. Such an approach will necessarily require the SQL queries to be serialized. Since the same SQL query may have multiple equivalent serializations, training a sequence-to-sequence-style model is sensitive to the choice from one of them. This phenomenon is documented as the "order-matters" problem. Existing state-of-the-art approaches rely on reinforcement learning to reward the decoder when it generates any of the equivalent serializations. However, we observe that the improvement from reinforcement learning is limited. In this paper, we propose a novel approach, i.e., SQLNet, to fundamentally solve this problem by avoiding the sequence-to-sequence structure when the order does not matter. In particular, we employ a sketch-based approach where the sketch contains a dependency graph so that one prediction can be done by taking into consideration only the previous predictions that it depends on. In addition, we propose a sequence-to-set model as well as the column attention mechanism to synthesize the query based on the sketch. By combining all these novel techniques, we show that SQLNet can outperform the prior art by 9% to 13% on the WikiSQL task.

📄 PDF Abstract BibTeX arXiv:1711.04436

Code (13)

Baidi96/text2sql pytorch
BroCoLySTyLe/SQLovaReview
CX000/sqlnet_inference_py36 pytorch
PriyankaDatar/NLP_Project_Modfications pytorch
PriyankaDatar/NLP_SQL_Bert pytorch
PriyankaDatar/NLP_SQL_Project pytorch
PriyankaDatar/NLP_project_BIDAF pytorch
abhishekchugh17/sql12 pytorch
llSourcell/SQL_Database_Optimization pytorch
racheljose21/chatbot pytorch
salesforce/WikiSQL
wronnyhuang/SQLNet_inference pytorch
xiaojunxu/SQLNet pytorch

Tasks

Decoderreinforcement-learningReinforcement LearningReinforcement Learning (RL)Text-To-SQL

Similar Papers 제목 키워드 기반

Graph Enhanced Cross-Domain Text-to-SQL Generation

2019-11-01 · WS 2019 11 · Siyu Huo, Tengfei Ma, Jie Chen, Maria Chang 외

Semantic parsing is a fundamental problem in natural language understanding, as it involves the mapping of natural language to structured forms such as executable queries or logic-like knowledge representations. Existing…

Natural Language UnderstandingSemantic ParsingSQL ParsingText to SQL+2

SyntaxSQLNet: Syntax Tree Networks for Complex and Cross-DomainText-to-SQL Task

2018-10-11 · Tao Yu, Michihiro Yasunaga, Kai Yang, Rui Zhang 외

Most existing studies in text-to-SQL tasks do not require generating complex SQL queries with multiple clauses or sub-queries, and generalizing to new, unseen databases. In this paper we propose SyntaxSQLNet, a syntax tr…

DecoderSemantic ParsingText to SQLText-To-SQL

SyntaxSQLNet: Syntax Tree Networks for Complex and Cross-Domain Text-to-SQL Task

2018-10-01 · EMNLP 2018 10 · Tao Yu, Michihiro Yasunaga, Kai Yang, Rui Zhang 외

Most existing studies in text-to-SQL tasks do not require generating complex SQL queries with multiple clauses or sub-queries, and generalizing to new, unseen databases. In this paper we propose SyntaxSQLNet, a syntax tr…

DecoderSemantic ParsingText to SQLText-To-SQL

Speech-to-SQL: Towards Speech-driven SQL Query Generation From Natural Language Question

2022-01-04 · Yuanfeng Song, Raymond Chi-Wing Wong, Xuefang Zhao, Di Jiang

Speech-based inputs have been gaining significant momentum with the popularity of smartphones and tablets in our daily lives, since voice is the most easiest and efficient way for human-computer interaction. This paper w…

Automatic Speech RecognitionAutomatic Speech Recognition (ASR)speech-recognitionSpeech Recognition+2

TUR2SQL: A Cross-Domain Turkish Dataset For Text-to-SQL

2023-10-24 · 8th International Conference on Computer Science and Engineering (UBMK) 2023 10 · Ali Buğra Kanburoğlu, F. Boray Tek

The field of converting natural language into corresponding SQL queries using deep learning techniques has attracted significant attention in recent years. While existing Text-to-SQL datasets primarily focus on English a…

Text to SQLText-To-SQL