Improvement and development of sql using fuzzy based queries and query generator tool

Abstract

Databases hold data that represent properties of real world objects In most new commercial business software applications the data is systematically stored in the database layers and precisely retrieved using Relational Database Management System RDBMS Structured Query Language SQL is the standard language used by RDBMS to communicate with relational databases Though SQL is a very successful and powerful entity oriented query language for data manipulation using relational algebra often it fall short of addressing some of the critical needs of searching near to or close to or just about or approximate values during decision making processes To address these needs this research work proposes certain improvement on standard SQL using fuzzy concepts called Enhanced SQL ESQL It is also proposed to develop an automated query generator tool for the above ESQL to utilize it to the full capacity newlineHuman have the ability to arrive quick estimation based on approximations Whenever interacting with the database human try to create nonstandard complex queries to arrive fast conclusions The complexity in the query normally arises in the form of ambiguity from uncertainty The conventional SQL is crisp deterministic and firm in nature Here firmness indicates that the structures and parameters of the model is to be undeniably known But in real situations human queries are not always crisp and deterministic and therefore cannot be described precisely Standard SQL is not capable of addressing such complex and vague queries newline