CFP last date
20 January 2025
Reseach Article

A New Functional Dependency in a Vague Relational Database Model

by Jaydev Mishra, Sharmistha Ghosh
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 39 - Number 8
Year of Publication: 2012
Authors: Jaydev Mishra, Sharmistha Ghosh
10.5120/4841-7104

Jaydev Mishra, Sharmistha Ghosh . A New Functional Dependency in a Vague Relational Database Model. International Journal of Computer Applications. 39, 8 ( February 2012), 29-36. DOI=10.5120/4841-7104

@article{ 10.5120/4841-7104,
author = { Jaydev Mishra, Sharmistha Ghosh },
title = { A New Functional Dependency in a Vague Relational Database Model },
journal = { International Journal of Computer Applications },
issue_date = { February 2012 },
volume = { 39 },
number = { 8 },
month = { February },
year = { 2012 },
issn = { 0975-8887 },
pages = { 29-36 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume39/number8/4841-7104/ },
doi = { 10.5120/4841-7104 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T20:25:55.970329+05:30
%A Jaydev Mishra
%A Sharmistha Ghosh
%T A New Functional Dependency in a Vague Relational Database Model
%J International Journal of Computer Applications
%@ 0975-8887
%V 39
%N 8
%P 29-36
%D 2012
%I Foundation of Computer Science (FCS), NY, USA
Abstract

In order to model the real world with imprecise and uncertain information, various extensions of the classical relational data model have been studied in literature using fuzzy set theory. However, vague set, as a generalized fuzzy set, has more powerful ability to process fuzzy information than fuzzy set. In this paper, we have proposed a vague relational database model and have defined a new kind of vague functional dependency (called α-vfd) based on the notion of α-equality of tuples and the idea of similarity measure of vague sets. Next, we present a set of sound vague inference rules which are similar to Armstrong’s axioms for the classical case. Finally, partial α-vfd and vague key have been studied with the new notion of α-vfd and also tested with examples.

References
  1. Zadeh L. A., 1965, “Fuzzy Sets”, Information and Control, Vol. 8, No.3, pp. 338-353.
  2. Al-Hamouz S., Biswas R., 2006, “Fuzzy Functional Dependencies in Relational Databases”, International Journal of Computational Cognition, Vol. 4, No.1, pp. 39-43.
  3. Liao S. Y., Wang H. Q. and Liu W.Y., 1993, “Functional Dependencies with Null values, Fuzzy values, and Crisp values”, IEEE Transaction on Fuzzy Systems, Vol. 7, No. 1, pp. 97-103.
  4. Liu, W. Y., 1997, “Fuzzy Data Dependencies and Implication of Fuzzy Data Dependencies”, Fuzzy Sets and Systems, Vol. 92, No. 3, pp. 341-348.
  5. Ma Z. M., Zhang W.J., Ma W. Y., and Mili F., 2002, “Handling Fuzzy Information in Extended Possibility-Based Fuzzy Relational Databases”, International Journal of Intelligent Systems, Vol. 17, No. 10, pp. 925-942.
  6. Mishra J. and Ghosh S., 2008, “A Study of Fuzzy Relational Database”, International Journal of Computational Cognition, Vol. 6, No. 4, pp. 45-50.
  7. Yazici A. and Sozat M. I., 1998, “The Integrity Constraints for Similarity-Based Fuzzy Relational Databases”, International Journal of Intelligent Systems, Vol. 13, No. 7, pp. 641-659.
  8. Yazici A. and Sozat M. I., 2001, “A Complete Axiomatization for Fuzzy Functional and Multivalued Dependencies in Fuzzy Database Relations”, Fuzzy Sets and Systems, Vol. 117, No. 2, pp. 161-181.
  9. Singaraju J., 2010, “Fuzzy Subset Dependencies”, International Journal of Computer Applications, Vol. 8, No. 13, pp. 29-36.
  10. Bosc P. and Pivert O., 1995, “SQLf: A Relational Database Language for Fuzzy Querying”, IEEE Transactions on Fuzzy Systems, Vol. 3, No. 1, pp. 1-17.
  11. Gau W. L. and Buehrer D. J., 1993, “Vague Sets”, IEEE Trans. Syst. Man, Cybernetics, Vol. 23, No. 2, pp. 610-614.
  12. Zhao F. and Ma Z. M., 2006, “Functional Dependencies in Vague Relational Databases”, IEEE International Conference on Systems, Man and Cybernetics.
  13. Zhao F., Ma Z. M., and Yan L., 2007, “A Vague Relational Model and Algebra”, Fourth International Conference on Fuzzy Systems and Knowledge Discovery, (FSKD).
  14. Lu A. and Ng W., 2009, “Maintaining consistency of vague databases using data dependencies”, Data and Knowledge Engineering, Vol. 68, No. 7, pp. 622-641.
  15. Zadeh L. A., 1975, “The Concept of a Linguistic Variable and its Application to Approximate Reasoning - I”, Information Sciences, Vol. 8, pp. 199-249.
  16. Chen S. M., 1997, “Similarity Measure between Vague Sets and between Elements”, IEEE Trans. Syst. Man, Cybern., Vol. 27, No. 1, pp.153-158.
  17. Hong D. H. and Kim C., 1999, “A Note on Similarity Measures between Vague Sets and between Elements”, Information Sciences, Vol. 115, pp. 83-96.
  18. Lu A., and Ng W., 2004, “Managing Merged Data by Vague Functional Dependencies”, LNCS 3288, pp. 259-272, Springer-Verlag Berlin Heidelberg.
Index Terms

Computer Science
Information Sciences

Keywords

Vague set similarity measure of vague sets α vfd partial α-vfd vague key