Handling Fuzzy SQL on Crisp databases using Lex-YACC

Conventional querying language presumes precision and certainty in user queries. But in factual situations the queries may be imprecise and may be desired to result in uncertain outcome. Introducing fuzziness in querying permits the realistic querying on the crisp data. In this paper, we propose the architecture for fuzzy querying along with an experimental implementation of the same. The implementation is using LEX and YACC that facilitate the lexical analysis of fuzzy terms and parsing the fuzzy query respectively. Fuzzy query is interpreted by the parser and the consequent semantic actions are carried out on MySQL database.