Our new X account is live! Follow @wizwand_team for updates
WorkDL logo mark

IGSQL: Database Schema Interaction Graph Based Neural Model for Context-Dependent Text-to-SQL Generation

About

Context-dependent text-to-SQL task has drawn much attention in recent years. Previous models on context-dependent text-to-SQL task only concentrate on utilizing historical user inputs. In this work, in addition to using encoders to capture historical information of user inputs, we propose a database schema interaction graph encoder to utilize historicalal information of database schema items. In decoding phase, we introduce a gate mechanism to weigh the importance of different vocabularies and then make the prediction of SQL tokens. We evaluate our model on the benchmark SParC and CoSQL datasets, which are two large complex context-dependent cross-domain text-to-SQL datasets. Our model outperforms previous state-of-the-art model by a large margin and achieves new state-of-the-art results on the two datasets. The comparison and ablation results demonstrate the efficacy of our model and the usefulness of the database schema interaction graph encoder.

Yitao Cai, Xiaojun Wan• 2020

Related benchmarks

TaskDatasetResultRank
Context-dependent Text-to-SQLSParC (test)
Question Match51.2
12
Conversational text-to-SQLSparc (dev)
Question Match50.7
7
Multi-turn Text-to-SQLCoSQL original (dev)
Exact Match (EM)44.1
2
Multi-turn Text-to-SQLCoSQL (ADVETA-RPL)
Exact Match (EM)16.4
2
Multi-turn Text-to-SQLCoSQL ADVETA-ADD
Exact Match (EM)32.8
2
Multi-turn Text-to-SQLSParC original (dev)
Exact Match (EM)50.7
2
Multi-turn Text-to-SQLSParC (ADVETA-RPL)
Exact Match (EM)34.2
2
Multi-turn Text-to-SQLSParC (ADVETA-ADD)
EM42.9
2
Showing 8 of 8 rows

Other info

Follow for update