Translation of imprecise query into SQL Query via MATLAB

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.

Authors

Publication Details

Journal
World Journal of Advanced Engineering Technology and Sciences
Published
2025-06-28
DOI
https://doi.org/10.30574/wjaets.2025.15.3.1149
Primary Topic
Advanced Database Systems and Queries
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Translation of imprecise query into SQL Query via MATLAB

Subita Kumari, Sonia Sonia
World Journal of Advanced Engineering Technology and Sciences
Advanced Database Systems and Queries
article

Translation of imprecise query into SQL Query via MATLAB

Subita Kumari, Sonia Sonia
article en

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.

World Journal of Advanced Engineering Technology and SciencesVol. 15(3)
Openalex Percentile: Top 84%
Advanced Database Systems and Queries
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.