SIGMA: A Dataset for Text-to-Code Semantic Parsing with Statistical Analysis
- 15 December 2023
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 851-857
Abstract
In the semantic parsing domain, significant progress has been achieved in Text-to-SQL and question-answering tasks, both focused on extracting information from data sources in their native format. However, the inherent constraints of their formal meaning representations, such as SQL programming language, hinder their ability to analyze data from various perspectives, such as conducting statistical analyses. To address this limitation and inspire research in this field, we design SIGMA, a new dataset for Text-to-Code semantic parsing with statistical analysis. SIGMA consists of 6000 questions with corresponding Python code labels. The Python code labels in our dataset cover 4 types of query patterns, which return data in their original format, and 40 types of statistical analysis patterns, which perform statistical operations on the data. We evaluated the SIGMA dataset using three different baseline models: LGESQL, 5mBoP, and SLSQL. The experimental results show that the LGESQL model with ELECTRA outperforms all other models, achieving 83.37% structure accuracy. In terms of execution accuracy, the 5mBoP model, when combined with GraPPa and T5, reaches 76.38%.Keywords
All Related Versions
This publication has 17 references indexed in Scilit:
- LGESQL: Line Graph Enhanced Text-to-SQL Model with Mixed Local and Non-Local Relations2021
- Re-examining the Role of Schema Linking in Text-to-SQL2020
- CoSQL: A Conversational Text-to-SQL Challenge Towards Cross-Domain Natural Language Interfaces to Databases2019
- Constructing Datasets for Multi-hop Reading Comprehension Across DocumentsTransactions of the Association for Computational Linguistics, 2018
- Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Task2018
- Learning a Neural Semantic Parser from User Feedback2017
- TriviaQA: A Large Scale Distantly Supervised Challenge Dataset for Reading Comprehension2017
- Latent Predictor Networks for Code Generation2016
- Learning to Generate Pseudo-Code from Source Code Using Statistical Machine Translation2015
- Constructing an interactive natural language interface for relational databasesProceedings of the VLDB Endowment, 2014