paper-with-me

홈 › Papers

Bridging the Generalization Gap in Text-to-SQL Parsing with Schema Expansion

2022-05-01 · ACL 2022 5 · Chen Zhao, Yu Su, Adam Pauls, Emmanouil Antonios Platanios

Text-to-SQL parsers map natural language questions to programs that are executable over tables to generate answers, and are typically evaluated on large-scale datasets like Spider (Yu et al., 2018). We argue that existing benchmarks fail to capture a certain out-of-domain generalization problem that is of significant practical importance: matching domain specific phrases to composite operation over columns. To study this problem, we first propose a synthetic dataset along with a re-purposed train/test split of the Squall dataset (Shi et al., 2020) as new benchmarks to quantify domain generalization over column operations, and find existing state-of-the-art parsers struggle in these benchmarks. We propose to address this problem by incorporating prior domain knowledge by preprocessing table schemas, and design a method that consists of two components: schema expansion and schema pruning. This method can be easily applied to multiple existing base parsers, and we show that it significantly outperforms baseline parsers on this domain generalization problem, boosting the underlying parsers’ overall performance by up to 13.8% relative accuracy gain (5.1% absolute) on the new Squall data split.

📄 PDF Abstract BibTeX

Code (0)

등록된 구현이 없습니다.

Tasks

Domain GeneralizationSQL ParsingText to SQLText-To-SQL

Similar Papers 제목 키워드 기반

Bridging Textual and Tabular Data for Cross-Domain Text-to-SQL Semantic Parsing

2020-12-23 · Findings of the Association for Computational Linguistics 2020 · Xi Victoria Lin, Richard Socher, Caiming Xiong

We present BRIDGE, a powerful sequential architecture for modeling dependencies between natural language questions and relational databases in cross-DB semantic parsing. BRIDGE represents the question and DB schema in a …

DecoderDeep AttentionSemantic ParsingText to SQL+1

ShadowGNN: Graph Projection Neural Network for Text-to-SQL Parser

2021-04-10 · NAACL 2021 4 · Zhi Chen, Lu Chen, Yanbin Zhao, Ruisheng Cao 외

Given a database schema, Text-to-SQL aims to translate a natural language question into the corresponding SQL query. Under the setup of cross-domain, traditional semantic parsing models struggle to adapt to unseen databa…

DecoderSemantic ParsingText to SQLText-To-SQL

RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQL

2023-02-12 · Haoyang Li, Jing Zhang, Cuiping Li, Hong Chen

One of the recent best attempts at Text-to-SQL is the pre-trained language model. Due to the structural property of the SQL queries, the seq2seq model takes the responsibility of parsing both the schema items (i.e., tabl…

DecoderLanguage ModelingLanguage ModellingSemantic Parsing+3

CQR-SQL: Conversational Question Reformulation Enhanced Context-Dependent Text-to-SQL Parsers

2022-05-16 · Dongling Xiao, Linzheng Chai, Qian-Wen Zhang, Zhao Yan 외

Context-dependent text-to-SQL is the task of translating multi-turn questions into database-related SQL queries. Existing methods typically focus on making full use of history context or previously predicted SQL for curr…

SQL ParsingText to SQLText-To-SQL

Schema-adaptable Knowledge Graph Construction

2023-05-15 · Hongbin Ye, Honghao Gui, Xin Xu, Xi Chen 외

Conventional Knowledge Graph Construction (KGC) approaches typically follow the static information extraction paradigm with a closed set of pre-defined schema. As a result, such approaches fall short when applied to dyna…

graph constructionUIE