Open AccessFuzzy improvement of the SQL
Author(s) -
Miroslav Hudec
Publication year - 2011
Publication title -
yugoslav journal of operations research
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.221
H-Index - 21
eISSN - 1820-743X
pISSN - 0354-0243
DOI - 10.2298/yjor1102239h
Subject(s) - computer science , sql , data definition language , sql injection , query by example , extension (predicate logic) , fuzzy logic , relational database , realization (probability) , database , sql/psm , language integrated query , programming language , stored procedure , data mining , information retrieval , artificial intelligence , mathematics , web search query , search engine , statistics
Structured Query Language (SQL) is used to obtain data from relational databases. Fuzzy improvement of SQL queries has advantages in cases when the user cannot unambiguously define selection criteria or when the user wants to examine data that almost meet the given criteria. In this paper we examine a realization of the fuzzy querying concept. For this purposes the fuzzy generalized logical condition for the WHERE part of the SQL is created. It allows users to create queries by linguistic terms. The proposed model is an extension of the SQL so that no modification inside databases has to be undertaken