Fuzzy queries on relational databases

Abstract

This article presents various forms of fuzzy queries, a detailed analysis of these queries and their conversion into standard SQL queries by means of Oracle 11g XE. A qualitative and quantitative study about the use of fuzzy queries on relational databases has been included in this article, as well. Given that fuzzy queries arrange results according to the degree in which they meet the conditions of the query, it is easier to analyze the results and the risk of obtaining an empty result is reduced thanks to an extended interpretation of the conditions of the query. The provided examples of conversion of fuzzy queries into standard SQL queries by means of Oracle 11g XE point to easy to implement methods of obtaining fuzzy information from the database, and thereby expand its functionality.