Logical Foundations for Similarity-Based Databases

Extensions of relational databases which aim at utilizing various aspects of similarity and imprecision in data processing are widespread in the literature. A need for development of solid foundations for such extensions, sometimes called similarity-based relational databases, has repeatedly been emphasized by leading database experts. This paper argues that, contrary to what may be perceived from the literature, solid foundations for similarity-based databases can be developed in a conceptually simple way. In this paper, we outline such foundations and develop in detail a part of the the facet related to similarity-based queries and relational algebra. The foundations are close in principle to Codd's foundations for relational databases, yet they account for the main aspects of similarity-based data manipulation. A major implication of the paper is that similarity-based data manipulation can be made an integral part of an extended, similarity-based, relational model of data, rather than glued atop the classic relational model in an ad hoc manner.

[1]  C. J. Date The database relational model : a retrospective review and analysis : a historical account and assessment of E.F. Codd's contribution to the field of database technology , 2000 .

[2]  Henri Prade,et al.  Generalizing Database Relational Algebra for the Treatment of Incomplete/Uncertain Information and Vague Queries , 1984, Inf. Sci..

[3]  Ronald Fagin,et al.  Combining fuzzy information: an overview , 2002, SGMD.

[4]  Vilém Vychodil,et al.  Codd's Relational Model of Data and Fuzzy Logic: Comparisons, Observations, and Some New Results , 2006, 2006 International Conference on Computational Inteligence for Modelling Control and Automation and International Conference on Intelligent Agents Web Technologies and International Commerce (CIMCA'06).

[5]  Vilém Vychodil,et al.  Data Tables with Similarity Relations: Functional Dependencies, Complete Rules and Non-redundant Bases , 2006, DASFAA.

[6]  David Maier,et al.  The Theory of Relational Databases , 1983 .

[7]  Vilém Vychodil,et al.  Codd's Relational Model from the Point of View of Fuzzy Logic , 2011, J. Log. Comput..

[8]  Vilém Vychodil,et al.  Relational Algebra for Ranked Tables with Similarities: Properties and Implementation , 2007, IDA.

[9]  Frederick E. Petry,et al.  Fuzzy databases in the new era , 1995, SAC '95.

[10]  John Shawe-Taylor,et al.  Advances in Intelligent Data Analysis VII, 7th International Symposium on Intelligent Data Analysis, IDA 2007, Ljubljana, Slovenia, September 6-8, 2007, Proceedings , 2007, IDA.

[11]  Kevin Chen-Chuan Chang,et al.  RankSQL: query algebra and optimization for relational top-k queries , 2005, SIGMOD '05.

[12]  Siegfried Gottwald,et al.  Mathematical Fuzzy Logics , 2008, Bulletin of Symbolic Logic.

[13]  Jennifer Widom,et al.  The Lowell database research self-assessment , 2003, CACM.

[14]  Donald H. Kraft,et al.  Fuzzy sets in database and information systems: Status and opportunities , 2005, Fuzzy Sets Syst..

[15]  Yoshikane Takahashi Fuzzy Database Query Languages and Their Relational Completeness Theorem , 1993, IEEE Trans. Knowl. Data Eng..

[16]  Arun K. Majumdar,et al.  Fuzzy Functional Dependencies and Lossless Join Decomposition of Fuzzy Relational Database Systems , 1988, ACM Trans. Database Syst..

[17]  Petr Hájek,et al.  Metamathematics of Fuzzy Logic , 1998, Trends in Logic.