arrow
Return

M-SQL: Multi-Task Representation Learning for Single-Table Text2sql Generation

delete2020-01-01
delete8
delete
OA
AI
X
Xiaoyu Zhang
F
Fengjing Yin *
G
Guojie Ma
B
Bin Ge
W
Weidong Xiao
DOI:10.1109/ACCESS.2020.2977613delete
deleteOriginal
deleteShare
deleteSave
View PDF
Abstract

Abstract

En 中文
Text2SQL can help non-professionals connect with databases by turning natural languages into SQL. Although previous researches about Text2SQL have provided some workable solutions, most of them extract values based on column representation. If there are multiple values in the query and these values belong to different columns, the previous approaches based on column representation cannot accurately extract values. In this work, we propose a new neural network architecture based on the pre-trained BERT, called M-SQL. The column-based value extraction is divided into two modules, value extraction and value-column matching. We evaluate M-SQL on a more complicated TableQA dataset, which comes from an AI competition. We rank first in this competition. Experimental results and competition ranking show that our proposed M-SQL achieves state-of-the-art results on TableQA.
Keywords:
Task analysis
Databases
Bit error rate
Semantics
Syntactics
Decoding
Natural languages
Text2SQL
M-SQL
pre-trained
multi-task learning
AI Summary

AI Summary

Key information extracted from the uploaded paper, including a brief overview, abstract, background, key highlights, visual analysis, and future outlook.

Journal

IEEE Access cover
IEEE Access
IF:
3.6
Papers:
9.8W
Citations:
29.4W

Organization

E
east china normal university
Scholars:
3.1W
Papers: 2.1W
Citations: 25
N
national university of defense technology - china
Scholars:
1.8W
Papers: 1.4W
Citations: 9
Cited Papers

Cited Papers

YAC transgene-mediated olfactory receptor gene choice
err2000-02-01
err0
errOAAI
errFarah A.W. Ebrahimi; James Edmondson; Rodney Rothstein; Andrew Chess
errShare
errSave
Auditing adult first seizure assessments
err2015-01-28
err0
PREAI
errLiam Stuart Carroll; Joseph Anderson
errShare
errSave
Determining the three-dimensional geometry of a dike swarm and its impact on later rift geometry using seismic reflection data
err2017-12-08
err0
errOAAI
errThomas B. Phillips; Craig Magee; Christopher A.-L. Jackson; Rebecca E. Bell
errShare
errSave
no more