Sigma: A dataset for text-to-code semantic parsing with statistical analysis

Fuente: arXiv
Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Almohaimeed, Saleh, Liu, Shenyang, Alsofyani, May, Almohaimeed, Saad, Wang, Liqiang
Format: Preprint
Veröffentlicht: 2025
Schlagworte:
Online-Zugang:
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
_version_ 1866909567418368000
author Almohaimeed, Saleh
Liu, Shenyang
Alsofyani, May
Almohaimeed, Saad
Wang, Liqiang
author_facet Almohaimeed, Saleh
Liu, Shenyang
Alsofyani, May
Almohaimeed, Saad
Wang, Liqiang
contents In the domain of semantic parsing, significant progress has been achieved in Text-to-SQL and question-answering tasks, both of which focus on extracting information from data sources in their native formats. However, the inherent constraints of their formal meaning representations, such as SQL programming language or basic logical forms, 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 comprises 6000 questions with corresponding Python code labels, spanning across 160 databases. Half of the questions involve query types, which return information in its original format, while the remaining 50% are statistical analysis questions, which perform statistical operations on the data. The Python code labels in our dataset cover 4 types of query types and 40 types of statistical analysis patterns. We evaluated the SIGMA dataset using three different baseline models: LGESQL, SmBoP, 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 SmBoP model, when combined with GraPPa and T5, reaches 76.38%.
format Preprint
id arxiv_https___arxiv_org_abs_2504_04301
institution arXiv
publishDate 2025
record_format arxiv
spellingShingle Sigma: A dataset for text-to-code semantic parsing with statistical analysis
Almohaimeed, Saleh
Liu, Shenyang
Alsofyani, May
Almohaimeed, Saad
Wang, Liqiang
Machine Learning
Artificial Intelligence
Databases
In the domain of semantic parsing, significant progress has been achieved in Text-to-SQL and question-answering tasks, both of which focus on extracting information from data sources in their native formats. However, the inherent constraints of their formal meaning representations, such as SQL programming language or basic logical forms, 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 comprises 6000 questions with corresponding Python code labels, spanning across 160 databases. Half of the questions involve query types, which return information in its original format, while the remaining 50% are statistical analysis questions, which perform statistical operations on the data. The Python code labels in our dataset cover 4 types of query types and 40 types of statistical analysis patterns. We evaluated the SIGMA dataset using three different baseline models: LGESQL, SmBoP, 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 SmBoP model, when combined with GraPPa and T5, reaches 76.38%.
title Sigma: A dataset for text-to-code semantic parsing with statistical analysis
topic Machine Learning
Artificial Intelligence
Databases
url https://arxiv.org/abs/2504.04301