Proton: Probing Schema Linking Information from Pre-trained Language Models for Text-to-SQL Parsing

06/28/2022
by   Lihan Wang, et al.
4

The importance of building text-to-SQL parsers which can be applied to new databases has long been acknowledged, and a critical step to achieve this goal is schema linking, i.e., properly recognizing mentions of unseen columns or tables when generating SQLs. In this work, we propose a novel framework to elicit relational structures from large-scale pre-trained language models (PLMs) via a probing procedure based on Poincaré distance metric, and use the induced relations to augment current graph-based parsers for better schema linking. Compared with commonly-used rule-based methods for schema linking, we found that probing relations can robustly capture semantic correspondences, even when surface forms of mentions and entities differ. Moreover, our probing procedure is entirely unsupervised and requires no additional parameters. Extensive experiments show that our framework sets new state-of-the-art performance on three benchmarks. We empirically verify that our probing procedure can indeed find desired relational structures through qualitative analysis.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
08/08/2022

Semantic Enhanced Text-to-SQL Parsing via Iteratively Learning Schema Linking Graph

The generalizability to new databases is of vital importance to Text-to-...
research
09/30/2020

A Tale of Two Linkings: Dynamically Gating between Schema Linking and Structural Linking for Text-to-SQL Parsing

In Text-to-SQL semantic parsing, selecting the correct entities (tables ...
research
05/14/2022

RASAT: Integrating Relational Structures into Pretrained Seq2Seq Model for Text-to-SQL

Relational structures such as schema linking and schema encoding have be...
research
04/01/2018

Unsupervised Correlation Analysis

Linking between two data sources is a basic building block in numerous c...
research
02/03/2021

An Investigation Between Schema Linking and Text-to-SQL Performance

Text-to-SQL is a crucial task toward developing methods for understandin...
research
02/21/2023

Conversational Text-to-SQL: An Odyssey into State-of-the-Art and Challenges Ahead

Conversational, multi-turn, text-to-SQL (CoSQL) tasks map natural langua...
research
12/18/2020

Mention Extraction and Linking for SQL Query Generation

On the WikiSQL benchmark, state-of-the-art text-to-SQL systems typically...

Please sign up or login with your details

Forgot password? Click here to reset