Towards an interface for translating natural language questions to SQL: a conceptual framework from a systematic review Online publication date: Mon, 14-Dec-2020
by Karam Ahkouk; Mustapha Machkour
International Journal of Reasoning-based Intelligent Systems (IJRIS), Vol. 12, No. 4, 2020
Abstract: Querying relational databases using human language is a complex process that must take into consideration the lack of knowledge of SQL by the end users who use the content of these systems. Many studies published in the last decade are based on limited, unbalanced or even small datasets, thing that is by far not realistic for training and evaluating a model. The SQL structure is rich and the scale of complexity is very large. Moreover, the difference between the natural language, which is a language of communication, and the SQL language that contains details of implementation specific to relational databases, adds more complications to the problem. In this paper, we present a full systematic review of the existing approaches in the task of text to SQL and we introduce the details of our suggested architecture as well as our new approach to tackle the problem of nested queries.
Online publication date: Mon, 14-Dec-2020
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Reasoning-based Intelligent Systems (IJRIS):
Login with your Inderscience username and password:
Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.
If you still need assistance, please email firstname.lastname@example.org