Skip to main navigation Skip to search Skip to main content

Retrieval-Then-Parsing: A Two-Stage Model for SQL Generation in Financial Domain

  • Harbin Institute of Technology Shenzhen

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

Abstract

Querying financial databases with natural language has been a strong requirement for financial company staff in recent years. The common method for this task is to transform the natural language into structured query language (SQL), which is referred to as semantic parsing. In this paper, we propose a two-stage model for semantic parsing in large financial databases. The two-stage model consists of an integrated table retriever that is used to retrieve related tables from a large database and a knowledge-enhanced semantic parser that utilizes a knowledge base for SQL generation. Experimental results show that our model achieves decent performance, which ranks the first place on both development and test datasets of CCKS 2022 evaluation task 11.

Original languageEnglish
Title of host publicationCCKS 2022 - Evaluation Track - 7th China Conference on Knowledge Graph and Semantic Computing Evaluations, CCKS 2022, Revised Selected Papers
EditorsNingyu Zhang, Meng Wang, Tianxing Wu, Wei Hu, Shumin Deng
PublisherSpringer Science and Business Media Deutschland GmbH
Pages214-220
Number of pages7
ISBN (Print)9789811982996
DOIs
StatePublished - 2022
Externally publishedYes
Event7th China Conference on Knowledge Graph and Semantic Computing Evaluations, CCKS 2022 - Qinhuangdao, China
Duration: 24 Aug 202227 Aug 2022

Publication series

NameCommunications in Computer and Information Science
Volume1711 CCIS
ISSN (Print)1865-0929
ISSN (Electronic)1865-0937

Conference

Conference7th China Conference on Knowledge Graph and Semantic Computing Evaluations, CCKS 2022
Country/TerritoryChina
CityQinhuangdao
Period24/08/2227/08/22

Keywords

  • Semantic parsing
  • Table question answering
  • Table retrieval

Fingerprint

Dive into the research topics of 'Retrieval-Then-Parsing: A Two-Stage Model for SQL Generation in Financial Domain'. Together they form a unique fingerprint.

Cite this