Lune

ACL Findings2022

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 attention. Previous works leverage context-dependence information either from interaction history utterances or the previous predicted SQL queries but fail in taking advantage of both since of the mismatch between natural language and logicform 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 pretrained model to bridge the gap between them. Besides, we design a schema-linking graph to enhance connections from utterances and the SQL query to the database schema. We show our history information enhanced methods improve the performance of HIE-SQL by a significant margin, which achieves new state-of-theart results on the two context-dependent textto-SQL benchmarks, the SparC and CoSQL datasets, at the writing time.

Ask Lune

Ask anything. The answer quotes the paper.

Lune reads all of it and the papers around it, then shows you the passages behind every answer.

Questions to start from

Lune answers from

the full paper · 9 top-tier papers that cite it · related work

Get the answer

Free to start. No credit card required.

Cited by top-tier papers9

  1. Text-to-SQL Empowered by Large Language Models: A Benchmark EvaluationDawei Gao, Haibin Wang, Yaliang Li, Xiuyu Sun et al.VLDB 2024 · 609 citations
  2. RASAT: Integrating Relational Structures into Pretrained Seq2Seq Model for Text-to-SQLJiexing Qi, Jingyao Tang, Ziwei He, Xiangpeng Wan et al.EMNLP 2022 · 73 citations
  3. MIGA: A Unified Multi-Task Generation Framework for Conversational Text-to-SQLYingwen Fu, Wenjie Ou, Zhou Yu, Yue LinAAAI 2023 · 14 citations
  4. Learn from Yesterday: A Semi-supervised Continual Learning Method for Supervision-Limited Text-to-SQL Task StreamsYongrui Chen, Xinnan Guo, Tongtong Wu, Guilin Qi et al.AAAI 2023 · 11 citations
  5. Parameterizing Context: Unleashing the Power of Parameter-Efficient Fine-Tuning and In-Context Tuning for Continual Table Semantic ParsingYongrui Chen, Shenyu Zhang, Guilin Qi, Xinnan GuoNeurIPS 2023 · 11 citations

Builds on14

  1. CodeBERT: A Pre-Trained Model for Programming and Natural LanguagesZhangyin Feng, Daya Guo, Duyu Tang, Nan Duan et al.EMNLP Findings 2020 · 2,828 citations
  2. Multimodal Few-Shot Learning with Frozen Language ModelsMaria Tsimpoukelli, Jacob Menick, Serkan Cabi, S. M. Ali Eslami et al.NeurIPS 2021 · 1,020 citations
  3. R-Drop: Regularized Dropout for Neural NetworksXiaobo Liang, Lijun Wu, Juntao Li, Yue Wang et al.NeurIPS 2021 · 610 citations
  4. Bridging Textual and Tabular Data for Cross-Domain Text-to-SQL Semantic ParsingXi Victoria Lin, Richard Socher, Caiming XiongEMNLP Findings 2020 · 186 citations
  5. Natural SQL: Making SQL Easier to Infer from Natural Language SpecificationsYujian Gan, Xinyun Chen, Jinxia Xie, Matthew Purver et al.EMNLP Findings 2021 · 88 citations

Related papers

  1. IGSQL: Database Schema Interaction Graph Based Neural Model for Context-Dependent Text-to-SQL GenerationYitao Cai, Xiaojun WanEMNLP 2020 · 41 citations
  2. Tracking Interaction States for Multi-Turn Text-to-SQL Semantic ParsingRunze Wang, Zhen-Hua Ling, Jingbo Zhou, Yu HuAAAI 2021 · 29 citations
  3. STAR: SQL Guided Pre-Training for Context-dependent Text-to-SQL ParsingZefeng Cai, Xiangyu Li, Binyuan Hui, Min Yang et al.EMNLP Findings 2022 · 27 citations
  4. CQR-SQL: Conversational Question Reformulation Enhanced Context-Dependent Text-to-SQL ParsersDongling Xiao, Linzheng Chai, Qian-Wen Zhang, Zhao Yan et al.EMNLP Findings 2022 · 14 citations
  5. S²SQL: Injecting Syntax to Question-Schema Interaction Graph Encoder for Text-to-SQL ParsersBinyuan Hui, Ruiying Geng, Lihan Wang, Bowen Qin et al.ACL Findings 2022 · 66 citations
Dusk over the sea between two cliffs drawn in fine vertical lines