arrow
返回

F-SQL: Fuse Table Schema and Table Content for Single-Table Text2SQL Generation

delete2020-01-01
delete5
delete
OA
AI
X
Xiaoyu Zhang
F
Fengjing Yin *
G
Guojie Ma
B
Bin Ge
W
Weidong Xiao
DOI:10.1109/ACCESS.2020.3011747delete
delete原文链接
delete分享
delete收藏
查看原文
摘要

摘要

En 中文
Automatically parsing SQL queries from natural languages can help non-professionals access databases and improve the efficiency of information utilization. It is a long-term research issue and has recently received attention from the relevant communities. Although previous researches have provided some workable solutions, most of them only consider table schemas and natural language questions when parsing SQL queries, and do not use table contents. We observe that table contents can provide more helpful information for some user questions. In this paper, we propose a novel neural network approach, F-SQL, to focus on solving the problem of table content utilization. In particular, we employ the gate mechanism to fuse table schemas and table contents and get the more different representation about table schemas. We test this idea on the WikiSQL and TableQA datasets. Experimental results show that F-SQL achieves new state-of-the-art results on WikiSQL and TableQA.
Keyword:
Structured Query Language
Natural languages
Task analysis
Semantics
Databases
Syntactics
Neural networks
Text2SQL
BERT
table schema
table content
AI总结

AI总结

对已上传原文的论文进行重点信息的提取,主要内容包括:简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。

期刊

IEEE Access 封面图
IEEE Access
IF:
3.6
论文数:
9.8W
被引数:
29.4W

机构

E
east china normal university
学者数:
3.1W
论文数: 2.1W
被引数: 25
N
national university of defense technology - china
学者数:
1.8W
论文数: 1.4W
被引数: 9
引用论文

引用论文

Collective List-Only Entity Linking: A Graph-Based Approach
err2018-01-01
err8
errOAAI
errZeng, Weixin; Zhao, Xiang; Tang, Jiuyang; Shang, Haichuan
err分享
err收藏
YAC transgene-mediated olfactory receptor gene choiceYAC转基因介导的嗅觉受体基因选择
err2000-02-01
err0
errOAAI
errFarah A.W. Ebrahimi; James Edmondson; Rodney Rothstein; Andrew Chess
err分享
err收藏
Efficient Mining of Frequent Patterns on Uncertain Graphs
err2019-02-01
err36
PREAI
errChen, Yifan; Zhao, Xiang; Lin, Xuemin; Wang, Yang; Guo, Deke
err分享
err收藏
M-SQL: Multi-Task Representation Learning for Single-Table Text2sql Generation
err2020-01-01
err8
errOAAI
errZhang, Xiaoyu; Yin, Fengjing; Ma, Guojie; Ge, Bin; Xiao, Weidong
err分享
err收藏
A high temperature variety of BiOF一种高温品种的BiOF
err1983-09-01
err0
PREAI
errSamir Matar; Jean-Maurice Reau; Louis Rabardel; Gérard Demazeau; Paul Hagenmuller
err分享
err收藏
学者 查看更多内容