■■■
Chapter 6
Fuzzy SQL and Intelligent
Queries
Nearly all model development (as well as data mining) projects begin with
an exploration of the underlying data space. With the exception of statisti-
cal analysis, the most common tool for data exploration is the Structured
Query Language (SQL) facilities associated with nearly all modern rela-
tional databases. In this chapter, we examine ways of improving SQL
requests using fuzzy forms of the where and having statements. By applying
fuzzy logic and approximate reasoning to the evaluation of record selec-
tion and clustering, we significantly improve the robustness and utility of
database query operations. In this chapter, we will be primarily concerned
with the where statement and its various forms. We ...