Cited By
View all- Garg RKiwelekar ANetak L(2021)Logistics and Freight Transportation Management: An NLP based Approach for Shipment TrackingPertanika Journal of Science and Technology10.47836/pjst.29.4.2829:4Online publication date: 18-Oct-2021
Inferring SQL Queries Using Interactivity
Article No.: 1, Pages 1 - 7
Abstract
Interactivity in language processing plays a pivotal role to allow models to better understand how to build the appropriate output. In the task of Natural Language to SQL, the fact of including the users' interactivity can be one of the practical solutions that haven't been studied deeply in the existing works published in the last decade. Using databases by users with limited familiarity in SQL will create an additional obstacle for these users to better exploit the content stored in the database systems. In this paper we present the already published studies and we discuss the utility of using the interactivity to definitely improve the query generation process in order to construct a model that generalize for unseen and complex sentences and to automatically generate the appropriate outputs.
References
[1]
Karam Ahkouk, Mustapha Machkour, Mourad Ennaji, Brahim Erraha, Jilali Antari. Comparative study of existing approaches on the Task of Natural Language to Database Language. 2019 International Conference of Computer Science and Renewable Energies (ICCSRE)
[2]
Benoît Couderc, Jérémy Ferrero. Interrogation de bases de données en français. 22ème Traitement Automatique des Langues Naturelles, Jun 2015, Caen, France. 2015
[3]
Navid Yaghmazadeh, Yuepeng Wang, Isil Dillig, and Thomas Dillig. 2017. SQLizer: Query Synthesis from Natural Language. Proc. ACM Program. Lang. 1, 1, Article 1 (January 2017), 25 pages.
[4]
Hanane Bais. Mustapha Machkour. Lahcen Koutti. An independent-domain natural language interface for multi-model databases. International Journal of Computational Intelligence Studies. 2019
[5]
Victor Zhong, Caiming Xiong, and Richard Socher. Seq2sql: Generating structured queries from natural language using reinforcement learning. arXiv preprint arXiv:1709.00103, 2017.
[6]
Chenglong Wang, Marc Brockschmidt, Rishabh Singh. Pointing Out SQL Queries From Text. MSR-TR-2017-45 | November 2017.
[7]
Xiaojun Xu, Chang Liu, Dawn Song. SQLNet: Generating Structured Queries From Natural Language Without Reinforcement Learning. arXiv:1711.04436v1
[8]
Tao Yu, Zifan Li, Zilin Zhang, Rui Zhang, Dragomir Radev. TypeSQL: Knowledge-based Type-Aware Neural Text-to-SQL Generation. The 16th Annual Conference of the North American Chapter of the Association for Computational Linguistics, New Orleans, 2018
[9]
Li Dong, Mirella Lapata. Coarse-to-Fine Decoding for Neural Semantic Parsing. arXiv:1805.04793. Proceedings of the 56th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers)
[10]
Tianze Shi, Kedar Tatwawadi, Kaushik Chakrabarti, Yi Mao, Oleksandr Polozov, Weizhu Chen. IncSQL: training incremental text-to-sql parsers with non-deterministic oracles. arxiv:1809.05054
[11]
Wonseok Hwang, Jinyeung Yim, Seunghyun Park, Minjoon Seo, A Comprehensive Exploration on WikiSQL with Table-Aware Word Contextualization. 2019. arXiv:1902.01069v1
[12]
Pengcheng He, Yi Mao, Kaushik Chakrabarti, Weizhu Chen. X-SQL: reinforce context into schema representation. MSR-TR-2019-6 | March 2019. Published by Microsoft Dynamics 365 AI.
[13]
Xiaodong Liu, Pengcheng He, Weizhu Chen, Jianfeng Gao. Multi-Task Deep Neural Networks for Natural Language Understanding. 2019 arXiv:1901.11504
[14]
Tao Yu, Michihiro Yasunaga, Kai Yang, Rui Zhang, Dongxu Wang, Zifan Li, Dragomir Radev. SyntaxSQLNet: Syntax Tree Networks for Complex and Cross-DomainText-to-SQL Task. 2018 arXiv:1810.05237
[15]
Dongjun Lee. Clause-Wise and Recursive Decoding for Complex and Cross-Domain Text-to-SQL Generation. 2019 arXiv:1904.08835v1
[16]
Kevin Lin, Ben Bogin, Mark Neumann, Jonathan Berant, Matt Gardner. Grammar-based Neural Text-to-SQL Generation. 2019 arXiv:1905.13326
[17]
Ben Bogin, Matt Gardner, Jonathan Berant. Representing Schema Structure with Graph Neural Networks for Text-to-SQL Parsing. 2019 arXiv:1905.06241
[18]
Chenglong Wang, Po-Sen Huang, Alex Polozov, Marc Brockschmidt, and Rishabh Singh. 2018a. Execution-guided neural program decoding. In ICML workshop on Neural Abstract Machines and Program Induction v2 (NAMPI).
[19]
Ziyu Yao1, Yu Su1, Huan Sun1, Wen-tau Yih. Model-based Interactive Semantic Parsing: A Unified Framework and A Text-to-SQL Case Study. OSU & Facebook AI Research
[20]
Dzmitry Bahdanau, Kyunghyun Cho, Yoshua Bengio. Neural Machine Translation by Jointly Learning to Align and Translate. arXiv:1409.0473v7.
[21]
O. Vinyals, M. Fortunato, and N. Jaitly. Pointer Networks. ArXiv e-prints, June 2015. Advances in Neural Information Processing Systems 28 (NIPS 2015)
[22]
Jacob Devlin, Ming-Wei Chang, Kenton Lee, Kristina Toutanova. BERT: Pre-training of Deep Bidirectional Transformers for Language Understanding. arXiv:1810.04805
[23]
Ashish Vaswani, Noam Shazeer, Niki Parmar, Jakob Uszkoreit, Llion Jones, Aidan N. Gomez, Lukasz Kaiser, Illia Polosukhin. Attention Is All You Need. arXiv:1706.03762
[24]
Rachid Mama and Mustapha Machkour, Fuzzy Questions for Relational Systems. Innovations in Smart Cities Applications Edition 3. The Proceedings of the 4th International Conference on Smart City Applications. 2020
[25]
Yunyao Li, Huahai Yang, H. V. Jagadish. NaLIX: an interactive natural language interface for querying XML. SIGMOD Conference 2005.
Index Terms
- Inferring SQL Queries Using Interactivity
Comments
Please enable JavaScript to view thecomments powered by Disqus.Information & Contributors
Information
Published In
March 2020
528 pages
Copyright © 2020 ACM.
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]
Publisher
Association for Computing Machinery
New York, NY, United States
Publication History
Published: 18 May 2020
Check for updates
Author Tags
Qualifiers
- Research-article
- Research
- Refereed limited
Conference
NISS2020
NISS2020: The 3rd International Conference on Networking, Information Systems & Security
March 31 - April 2, 2020
Marrakech, Morocco
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- View Citations1Total Citations
- 150Total Downloads
- Downloads (Last 12 months)2
- Downloads (Last 6 weeks)0
Reflects downloads up to 13 Nov 2024
Other Metrics
Citations
Cited By
View all- Garg RKiwelekar ANetak L(2021)Logistics and Freight Transportation Management: An NLP based Approach for Shipment TrackingPertanika Journal of Science and Technology10.47836/pjst.29.4.2829:4Online publication date: 18-Oct-2021
View Options
Get Access
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in