Functional dependencies with null values, fuzzy values, and crisp values

Research output: Journal Publications and Reviews (RGC: 21, 22, 62)21_Publication in refereed journalpeer-review

33 Scopus Citations
View graph of relations

Author(s)

Related Research Unit(s)

Detail(s)

Original languageEnglish
Pages (from-to)97-103
Journal / PublicationIEEE Transactions on Fuzzy Systems
Volume7
Issue number1
Publication statusPublished - 1999

Abstract

This correspondence discusses the functional dependency with null values, fuzzy values, and crisp values. Based on the concepts of the semantic proximity, we present a definition of the fuzzy functional dependency. We show that the inference rules for fuzzy functional dependencies, which are the same as Armstrong's Axioms for the crisp case, are correct and complete. We also show that dependent constraints with null values constitute a lattice. Functional dependencies in classical relational databases and null functional dependencies can be viewed as a special case of fuzzy functional dependencies. By applying the unified functional dependencies to the relational database design, we can represent the data with fuzzy values, null values, and crisp values under relational database management systems. By using fuzzy functional dependencies, we can compress the range of a fuzzy value and make this fuzzy value "clearer." © 1999 IEEE.

Research Area(s)

  • Fuzzy functional dependency, Fuzzy value, Null value, Relational database, Semantic proximity

Citation Format(s)

Functional dependencies with null values, fuzzy values, and crisp values. / Liao, S. Y.; Wang, H. Q.; Liu, W. Y.

In: IEEE Transactions on Fuzzy Systems, Vol. 7, No. 1, 1999, p. 97-103.

Research output: Journal Publications and Reviews (RGC: 21, 22, 62)21_Publication in refereed journalpeer-review