DOI: 10.5281/zenodo.5205322
title: Spider Realistic Dataset In Structure-Grounded Pretraining for Text-to-SQL

description: This folder contains the Spider-Realistic dataset used for evaluation in the paper "Structure-Grounded Pretraining for Text-to-SQL". The dataset is created based on the dev split of the Spider dataset (2020-06-07 version from https://yale-lily.github.io/spider). We manually modified the original questions to remove the explicit mention of column names while keeping the SQL queries unchanged to better evaluate the model's capability in aligning the NL utterance and the DB schema. For more details, please check our paper at https://arxiv.org/abs/2010.12773. It contains the following files: - spider-realistic.json<br> # The spider-realistic evaluation set<br> # Examples: 508<br> # Databases: 19<br> - dev.json<br> # The original dev split of Spider<br> # Examples: 1034<br> # Databases: 20<br> - tables.json<br> # The original DB schemas from Spider<br> # Databases: 166<br> - README.txt<br> - license The Spider-Realistic dataset is created based on the dev split of the Spider dataset realsed by Yu, Tao, et al. "Spider: A large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-sql task." It is a subset of the original dataset with explicit mention of the column names removed. The sql queries and databases are kept unchanged.<br> For the format of each json file, please refer to the github page of Spider https://github.com/taoyds/spider.<br> For the database files please refer to the official Spider release https://yale-lily.github.io/spider. This dataset is distributed under the CC BY-SA 4.0 license. If you use the dataset, please cite the following papers including the original Spider datasets, Finegan-Dollak et al., 2018 and the original datasets for Restaurants, GeoQuery, Scholar, Academic, IMDB, and Yelp. @article{deng2020structure,<br> title={Structure-Grounded Pretraining for Text-to-SQL},<br> author={Deng, Xiang and Awadallah, Ahmed Hassan and Meek, Christopher and Polozov, Oleksandr and Sun, Huan and Richardson, Matthew},<br> journal={arXiv preprint arXiv:2010.12773},<br> year={2020}<br> } @inproceedings{Yu&al.18c,<br> year = 2018,<br> title = {Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Task},<br> booktitle = {EMNLP},<br> author = {Tao Yu and Rui Zhang and Kai Yang and Michihiro Yasunaga and Dongxu Wang and Zifan Li and James Ma and Irene Li and Qingning Yao and Shanelle Roman and Zilin Zhang and Dragomir Radev }<br> } @InProceedings{P18-1033,<br> author = "Finegan-Dollak, Catherine<br> and Kummerfeld, Jonathan K.<br> and Zhang, Li<br> and Ramanathan, Karthik<br> and Sadasivam, Sesh<br> and Zhang, Rui<br> and Radev, Dragomir",<br> title = "Improving Text-to-SQL Evaluation Methodology",<br> booktitle = "Proceedings of the 56th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers)",<br> year = "2018",<br> publisher = "Association for Computational Linguistics",<br> pages = "351--360",<br> location = "Melbourne, Australia",<br> url = "http://aclweb.org/anthology/P18-1033"<br> } @InProceedings{data-sql-imdb-yelp,<br> dataset = {IMDB and Yelp},<br> author = {Navid Yaghmazadeh, Yuepeng Wang, Isil Dillig, and Thomas Dillig},<br> title = {SQLizer: Query Synthesis from Natural Language},<br> booktitle = {International Conference on Object-Oriented Programming, Systems, Languages, and Applications, ACM},<br> month = {October},<br> year = {2017},<br> pages = {63:1--63:26},<br> url = {http://doi.org/10.1145/3133887},<br> } @article{data-academic,<br> dataset = {Academic},<br> author = {Fei Li and H. V. Jagadish},<br> title = {Constructing an Interactive Natural Language Interface for Relational Databases},<br> journal = {Proceedings of the VLDB Endowment},<br> volume = {8},<br> number = {1},<br> month = {September},<br> year = {2014},<br> pages = {73--84},<br> url = {http://dx.doi.org/10.14778/2735461.2735468},<br> } @InProceedings{data-atis-geography-scholar,<br> dataset = {Scholar, and Updated ATIS and Geography},<br> author = {Srinivasan Iyer, Ioannis Konstas, Alvin Cheung, Jayant Krishnamurthy, and Luke Zettlemoyer},<br> title = {Learning a Neural Semantic Parser from User Feedback},<br> booktitle = {Proceedings of the 55th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers)},<br> year = {2017},<br> pages = {963--973},<br> location = {Vancouver, Canada},<br> url = {http://www.aclweb.org/anthology/P17-1089},<br> } @inproceedings{data-geography-original<br> dataset = {Geography, original},<br> author = {John M. Zelle and Raymond J. Mooney},<br> title = {Learning to Parse Database Queries Using Inductive Logic Programming},<br> booktitle = {Proceedings of the Thirteenth National Conference on Artificial Intelligence - Volume 2},<br> year = {1996},<br> pages = {1050--1055},<br> location = {Portland, Oregon},<br> url = {http://dl.acm.org/citation.cfm?id=1864519.1864543},<br> } @inproceedings{data-restaurants-logic,<br> author = {Lappoon R. Tang and Raymond J. Mooney},<br> title = {Automated Construction of Database Interfaces: Intergrating Statistical and Relational Learning for Semantic Parsing},<br> booktitle = {2000 Joint SIGDAT Conference on Empirical Methods in Natural Language Processing and Very Large Corpora},<br> year = {2000},<br> pages = {133--141},<br> location = {Hong Kong, China},<br> url = {http://www.aclweb.org/anthology/W00-1317},<br> } @inproceedings{data-restaurants-original,<br> author = {Ana-Maria Popescu, Oren Etzioni, and Henry Kautz},<br> title = {Towards a Theory of Natural Language Interfaces to Databases},<br> booktitle = {Proceedings of the 8th International Conference on Intelligent User Interfaces},<br> year = {2003},<br> location = {Miami, Florida, USA},<br> pages = {149--157},<br> url = {http://doi.acm.org/10.1145/604045.604070},<br> } @inproceedings{data-restaurants,<br> author = {Alessandra Giordani and Alessandro Moschitti},<br> title = {Automatic Generation and Reranking of SQL-derived Answers to NL Questions},<br> booktitle = {Proceedings of the Second International Conference on Trustworthy Eternal Systems via Evolving Software, Data and Knowledge},<br> year = {2012},<br> location = {Montpellier, France},<br> pages = {59--76},<br> url = {https://doi.org/10.1007/978-3-642-45260-4_5},<br> }