File Download
Links for fulltext
(May Require Subscription)
- Publisher Website: 10.18653/v1/N18-2093
- Scopus: eid_2-s2.0-85072866387
Supplementary
-
Citations:
- Scopus: 0
- Appears in Collections:
Conference Paper: TypeSQL: Knowledge-based type-aware neural text-to-SQL generation
Title | TypeSQL: Knowledge-based type-aware neural text-to-SQL generation |
---|---|
Authors | |
Issue Date | 2018 |
Citation | 2018 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies (NAACL-HLT 2018), New Orleans, LA, 1-6 June 2018. In Proceedings of the 2018 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies, Volume 2 (Short Papers), 2018, p. 588-594 How to Cite? |
Abstract | Interacting with relational databases through natural language helps users of any background easily query and analyze a vast amount of data. This requires a system that understands users' questions and converts them to SQL queries automatically. In this paper we present a novel approach, TYPESQL, which views this problem as a slot filling task. Additionally, TYPESQL utilizes type information to better understand rare entities and numbers in natural language questions. We test this idea on the WikiSQL dataset and outperform the prior state-of-the-art by 5.5% in much less time. We also show that accessing the content of databases can significantly improve the performance when users' queries are not wellformed. TYPESQL gets 82.6% accuracy, a 17.5% absolute improvement compared to the previous content-sensitive model. |
Persistent Identifier | http://hdl.handle.net/10722/303624 |
DC Field | Value | Language |
---|---|---|
dc.contributor.author | Yu, Tao | - |
dc.contributor.author | Li, Zifan | - |
dc.contributor.author | Zhang, Zilin | - |
dc.contributor.author | Zhang, Rui | - |
dc.contributor.author | Radev, Dragomir | - |
dc.date.accessioned | 2021-09-15T08:25:41Z | - |
dc.date.available | 2021-09-15T08:25:41Z | - |
dc.date.issued | 2018 | - |
dc.identifier.citation | 2018 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies (NAACL-HLT 2018), New Orleans, LA, 1-6 June 2018. In Proceedings of the 2018 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies, Volume 2 (Short Papers), 2018, p. 588-594 | - |
dc.identifier.uri | http://hdl.handle.net/10722/303624 | - |
dc.description.abstract | Interacting with relational databases through natural language helps users of any background easily query and analyze a vast amount of data. This requires a system that understands users' questions and converts them to SQL queries automatically. In this paper we present a novel approach, TYPESQL, which views this problem as a slot filling task. Additionally, TYPESQL utilizes type information to better understand rare entities and numbers in natural language questions. We test this idea on the WikiSQL dataset and outperform the prior state-of-the-art by 5.5% in much less time. We also show that accessing the content of databases can significantly improve the performance when users' queries are not wellformed. TYPESQL gets 82.6% accuracy, a 17.5% absolute improvement compared to the previous content-sensitive model. | - |
dc.language | eng | - |
dc.relation.ispartof | Proceedings of the 2018 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies, Volume 2 (Short Papers) | - |
dc.rights | This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License. | - |
dc.title | TypeSQL: Knowledge-based type-aware neural text-to-SQL generation | - |
dc.type | Conference_Paper | - |
dc.description.nature | published_or_final_version | - |
dc.identifier.doi | 10.18653/v1/N18-2093 | - |
dc.identifier.scopus | eid_2-s2.0-85072866387 | - |
dc.identifier.spage | 588 | - |
dc.identifier.epage | 594 | - |