A study of SQL query processing using soft computing techniques:a hybrid vague logic approach

摘要

As we know that in this new era, the availability of modern data sets is massive. It is very difficult to find the variation and appropriate class for a data set. So, this paper introduces a comparison between fuzzy and vague sets for handling Structured Query Language (SQL) processing problems. This paper proposed a new method to convert crisp set into vague set with help of Positive Ordered Transformation formula (POTF). Further, vague sets are converted into fuzzy sets with help of Transforming Vague Set into Fuzzy Set method proposed by Liu et al. (Trans Comput Sci Ⅱ LNCS 5152:133-144, 2008). Further the similarity measures have been used to obtain similar tuple for classical fuzzy, vague and converted fuzzy sets based on SQL query processing. This proposed system diverse a resultant as a set based on supply limit/a-cut for fuzzy/vagueness/unclear information. After testing through many cases, this paper discussed a very good finding about proposed method for SQL query processing problems.