View in EDS

Translation of imprecise query into SQL Query via MATLAB

Saved in:
Bibliographic Details
Title: Translation of imprecise query into SQL Query via MATLAB
Authors: null Subita Kumari, null Sonia
Source: World Journal of Advanced Engineering Technology and Sciences. 15:2312-2319
Publisher Information: GSC Online Press, 2025.
Publication Year: 2025
Description: A Relational Data Base Management System (RDBMS) is software which offers convenient and effective method of storing and retrieving information from database. In real life user’s queries are in natural language, so queries need to be expressed using vague or imprecise or fuzzy terms. This paper provides the flexibility to query the database in natural language using FRDB (Fuzzy Relational Data Base). FRDB allow users to have a range of answers, which in turn will enhance the eloquence of human expression, without extra search time and cost. Fuzzy query interpreter layer of FRDB assists to translate vague query into SQL query without learning a new query language. Automatic mapping of existing RDBMS can be done with FRDB, which increases the efficiency of query response. In this paper fuzzy queries are being translated into SQL query. Query Builder tool of MATLAB is being used to show the result of query.
Document Type: Article
ISSN: 2582-8266
DOI: 10.30574/wjaets.2025.15.3.1149
Accession Number: edsair.doi...........fda1bce1bb008aaebe93b70b5508862d
Database: OpenAIRE
Description
Abstract:A Relational Data Base Management System (RDBMS) is software which offers convenient and effective method of storing and retrieving information from database. In real life user’s queries are in natural language, so queries need to be expressed using vague or imprecise or fuzzy terms. This paper provides the flexibility to query the database in natural language using FRDB (Fuzzy Relational Data Base). FRDB allow users to have a range of answers, which in turn will enhance the eloquence of human expression, without extra search time and cost. Fuzzy query interpreter layer of FRDB assists to translate vague query into SQL query without learning a new query language. Automatic mapping of existing RDBMS can be done with FRDB, which increases the efficiency of query response. In this paper fuzzy queries are being translated into SQL query. Query Builder tool of MATLAB is being used to show the result of query.
ISSN:25828266
DOI:10.30574/wjaets.2025.15.3.1149