Litcius/Paper detail

Mention Extraction and Linking for SQL Query Generation

Jianqiang Ma, Zeyu Yan, Shuai Pang, Yang Zhang, Jianping Shen

202021 citationsDOIOpen Access PDF

Abstract

On the WikiSQL benchmark, state-of-the-art text-to-SQL systems typically take a slotfilling approach by building several dedicated models for each type of slots. Such modularized systems are not only complex but also of limited capacity for capturing interdependencies among SQL clauses. To solve these problems, this paper proposes a novel extraction-linking approach, where a unified extractor recognizes all types of slot mentions appearing in the question sentence before a linker maps the recognized columns to the table schema to generate executable SQL queries. Trained with automatically generated annotations, the proposed method achieves the first place on the WikiSQL benchmark.

Topics & Concepts

Computer scienceSQLExtractorProgramming languageQuery by ExampleTable (database)DatabaseSchema (genetic algorithms)Data miningInformation retrievalExecutableRelational databaseInformation extractionArtificial intelligenceData definition languageRedundancy (engineering)Partition (number theory)Online analytical processingSearch engine indexingData modelingNatural Language Processing TechniquesTopic ModelingWeb Data Mining and Analysis
Mention Extraction and Linking for SQL Query Generation | Litcius