Abstract
We study rules \(A \Longrightarrow B\) describing attribute dependencies in tables over domains with similarity relations. \(A \Longrightarrow B\) reads “for any two table rows: similar values of attributes from A imply similar values of attributes from B”. The rules generalize ordinary functional dependencies in that they allow for processing of similarity of attribute values. Similarity is modeled by reflexive and symmetric fuzzy relations. We show a system of Armstrong-like derivation rules and prove its completeness (two versions). Furthermore, we describe a non-redundant basis of all rules which are true in a data table and present an algorithm to compute bases.
Supported by grant No. 1ET101370417 of GA AV ČR, by grant No. 201/05/0079 of the Czech Science Foundation, and by institutional support, research plan MSM 6198959214.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Abiteboul, S., et al.: The Lowell database research self-assessment. Communications of ACM 48(5), 111–118 (2005)
Armstrong, W.W.: Dependency structures in data base relationships. IFIP Congress, Geneva, Switzerland, pp. 580–583 (1974)
Bělohlávek, R.: Fuzzy Relational Systems: Foundations and Principles, New York. Kluwer, Academic/Plenum Publishers (2002)
Bělohlávek R., Chlupová M., Vychodil V.: Implications from data with fuzzy attributes. AISTA 2004 in Cooperation with the IEEE Computer Society Proceedings, 2004, 5 pages, ISBN 2–9599776–8–8.
Bělohlávek R., Vychodil V.: Functional dependencies of data tables over domains with similarity relations (to appear).
Buckles B. P., Petry F. E.: Fuzzy databases in the new era. Proceedings of the 1995 ACM symposium on Applied computing, pp. 497–502, Nashville, Tennessee, ISBN 0-89791-658-1, 1995.
Ganter B., Wille R.: Formal Concept Analysis. Mathematical Foundations. Springer, Berlin, 1999.
Gerla G.: Fuzzy Logic. Mathematical Tools for Approximate Reasoning. Kluwer, Dordrecht, 2001.
Hájek P.: Metamathematics of Fuzzy Logic. Kluwer, Dordrecht, 1998.
Holzer R.: Knowledge Acquisition under Incomplete Knowledge using Methods from Formal Concept Analysis: Part I. Fundamenta Informaticae, 63(1)(2004), 17–39.
Klir G. J., Yuan B.: Fuzzy Sets and Fuzzy Logic. Theory and Applications. Prentice Hall, 1995.
Maier D.: The Theory of Relational Databases. Computer Science Press, Rockville, 1983.
Prade H., Testemale C.: Generalizing database relational algebra for the treatment of incomplete or uncertain information and vague queries. Information Sciences 34(1984), 115–143.
Raju K. V. S. V. N., Majumdar A. K.: Fuzzy functional dependencies and lossless join decomposition of fuzzy relational database systems. ACM Trans. Database Systems Vol. 13, No. 2, 1988, pp. 129–166.
Tyagi B. K., Sharfuddin A., Dutta R. N., Tayal D. K.: A complete axiomatization of fuzzy functional dependencies using fuzzy function. Fuzzy Sets and Systems 151(2)(2005), 363–379.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Bělohlávek, R., Vychodil, V. (2006). Data Tables with Similarity Relations: Functional Dependencies, Complete Rules and Non-redundant Bases. In: Li Lee, M., Tan, KL., Wuwongse, V. (eds) Database Systems for Advanced Applications. DASFAA 2006. Lecture Notes in Computer Science, vol 3882. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11733836_45
Download citation
DOI: https://doi.org/10.1007/11733836_45
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-33337-1
Online ISBN: 978-3-540-33338-8
eBook Packages: Computer ScienceComputer Science (R0)