This paper concerns the modeling of imprecision, vagueness, and uncertainty
in databases through an extension of the relational model of data: the fuz
zy rough relational database, an approach which uses both fuzzy set and rou
gh set theories for knowledge representation of imprecise data in a relatio
nal database model. The fuzzy rough relational database is formally defined
, along with a fuzzy rough relational algebra for querying. Comparisons of
theoretical properties of operators in this model with those in the standar
d relational model are discussed. An example application is used to illustr
ate other aspects of this model, including a fuzzy entity-relationship type
diagram for database design, a fuzzy rough data definition language, and a
n SQL-like query language supportive of the fuzzy rough relational database
model. This example also illustrates the ease of use of the fuzzy rough re
lational database, which often produces results that are better than those
of conventional databases since it more accurately models the uncertainty o
f real-world enterprises than do conventional databases through the use of
indiscernibility and fuzzy membership values. (C) 2000 John Wiley & Sons, I
nc.