Vol.32, No.1, 2022, pp.285-299, doi:10.32604/iasc.2022.015488
OPEN ACCESS
ARTICLE
Evaluation of Natural Language Software Interfaces to Databases
  • Fiaz Majeed1, Muhammad Shoaib2, Monagi H. Alkinani3, Wazir Zada Khan4, Shahzada Khurram5, Akber Abid Gardezi6, Muhammad Shafiq7,*
1 Department of Software Engineering, University of Gujrat, Gujrat 50700, Pakistan
2 Computer Science and Engineering Department, University of Engineering and Technology Lahore, Pakistan
3 College of Computer and Engineering, Department of CS & AI, University of Jeddah, Saudi Arabia
4 Department of Computer Science, Capital University of Science and Technology, Islamabad, Pakistan
5 Faculty of Computing, The Islamia University of Bahawalpur, Bahawalpur 63100, Pakistan
6 Department of Computer Science, COMSATS University Islamabad, Islamabad, Pakistan
7 Department of Information and Communication Engineering, Yeungnam University, Gyeongsan, 38541, Korea
* Corresponding Author: Muhammad Shafiq. Email:
(This article belongs to this Special Issue: Soft Computing Methods for Innovative Software Practices)
Received 24 November 2020; Accepted 28 July 2021; Issue published 26 October 2021
Abstract
Relational databases are still important in modern times due to their many advantages, such as ease of interaction, simplicity and data integrity. In this regard, structured query language (SQL) and technical knowledge about database schemas are the basic building blocks for retrieving information from relational databases. Generally, non-expert users cannot skillfully write technical queries on the target database. To this end, many database natural language interfaces (NLIDB) have been developed to greatly facilitate users. However, each system provides a different interface for new users, so beginners can use different interactive modes to enter keyword-based queries. For users, migrating from one NLIDB to another is a difficult problem. To solve this problem, NLIDB needs to be standardized so that novice users can easily enter queries in their native language. This paper proposes a standardized interface for NLIDB, which considers the three quality parameters of interface, query comparison and performance. Based on these parameters, we developed a standardized interface called the keyword-based frequent search engine (FKBSE). The DBLP data set has been evaluated experimentally. The results show the effectiveness of FKBSE compared with parallel systems in terms of quality parameters.
Keywords
NLIDB; FKBSE; SQL; standardization; benchmark
Cite This Article
F. Majeed, M. Shoaib, M. H. Alkinani, W. Z. Khan, S. Khurram et al., "Evaluation of natural language software interfaces to databases," Intelligent Automation & Soft Computing, vol. 32, no.1, pp. 285–299, 2022.
This work is licensed under a Creative Commons Attribution 4.0 International License , which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.