Functional dependencies with null values, fuzzy values, and crisp values
Research output: Journal Publications and Reviews (RGC: 21, 22, 62) › 21_Publication in refereed journal › peer-review
Author(s)
Related Research Unit(s)
Detail(s)
| Original language | English |
|---|---|
| Pages (from-to) | 97-103 |
| Journal / Publication | IEEE Transactions on Fuzzy Systems |
| Volume | 7 |
| Issue number | 1 |
| Publication status | Published - 1999 |
Link(s)
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.
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 journal › peer-review
