HIE-SQL: History Information Enhanced Network for Context-Dependent Text-to-SQL Semantic Parsing

Yanzhao Zheng, Haibin Wang, Baohua Dong, Xingjun Wang, Changshan Li


Abstract
Recently, context-dependent text-to-SQL semantic parsing which translates natural language into SQL in an interaction process has attracted a lot of attentions. Previous works leverage context dependence information either from interaction history utterances or previous predicted queries but fail in taking advantage of both of them since of the mismatch between the natural language and logic-form SQL. In this work, we propose a History Information Enhanced text-to-SQL model (HIE-SQL) to exploit context dependence information from both history utterances and the last predicted SQL query. In view of the mismatch, we treat natural language and SQL as two modalities and propose a bimodal pre-trained model to bridge the gap between them. Besides, we design a schema-linking graph to enhance connections from utterances and the SQL query to database schema. We show our history information enhanced methods improve the performance of HIE-SQL by a significant margin, which achieves new state-of-the-art results on two context-dependent text-to-SQL benchmarks, the SparC and CoSQL datasets, at the writing time.
Anthology ID:
2022.findings-acl.236
Volume:
Findings of the Association for Computational Linguistics: ACL 2022
Month:
May
Year:
2022
Address:
Dublin, Ireland
Editors:
Smaranda Muresan, Preslav Nakov, Aline Villavicencio
Venue:
Findings
SIG:
Publisher:
Association for Computational Linguistics
Note:
Pages:
2997–3007
Language:
URL:
https://aclanthology.org/2022.findings-acl.236
DOI:
10.18653/v1/2022.findings-acl.236
Bibkey:
Cite (ACL):
Yanzhao Zheng, Haibin Wang, Baohua Dong, Xingjun Wang, and Changshan Li. 2022. HIE-SQL: History Information Enhanced Network for Context-Dependent Text-to-SQL Semantic Parsing. In Findings of the Association for Computational Linguistics: ACL 2022, pages 2997–3007, Dublin, Ireland. Association for Computational Linguistics.
Cite (Informal):
HIE-SQL: History Information Enhanced Network for Context-Dependent Text-to-SQL Semantic Parsing (Zheng et al., Findings 2022)
Copy Citation:
PDF:
https://aclanthology.org/2022.findings-acl.236.pdf
Data
CoSQLSpider-Realistic