Lossless join decomposition for extended possibility-based fuzzy relational databases

DOI10.1155/2014/842680MaRDI QIDQ2336771zbMATH OpenOpenAlexWikidataFDO

Authors Julie Yu-Chih Liu

Publication date 19 November 2019

Published in Journal of Applied Mathematics (Search for Journal in Brave)

Copyright license Creative Commons Attribution 3.0 Unported

Full work available at URL https://doi.org/10.1155/2014/842680

Mathematics Subject Classification ID

Database theory (68P15)

Review text

Summary: Functional dependency is the basis of database normalization. Various types of fuzzy functional dependencies have been proposed for fuzzy relational database and applied to the process of database normalization. However, the problem of achieving lossless join decomposition occurs when employing the fuzzy functional dependencies to database normalization in an extended possibility-based fuzzy data models. To resolve the problem, this study defined fuzzy functional dependency based on a notion of approximate equality for extended possibility-based fuzzy relational databases. Examples show that the notion is more applicable than other similarity concept to the research related to the extended possibility-based data model. We provide a decomposition method of using the proposed fuzzy functional dependency for database normalization and prove the lossless join property of the decomposition method.

Recommendations

• Normalization and lossless join decomposition of similarity-based fuzzy relational databases
• Fuzzy functional dependencies and independencies in extended fuzzy relational database models
• Multivalued dependencies in fuzzy relational databases and lossless join decomposition
• Lossless join property in fuzzy relational databases
• The dependency-preserving decomposition and a testing algorithm in a fuzzy relational data model

Cites work

• A fuzzy representation of data for relational databases
• A relational model of data for large shared data banks
• An equivalence classes model of fuzzy relational databases
• Data dependencies in extended possibility-based fuzzy relational databases
• Data integration constraints for consistent data redundancy in fuzzy databases
• Defining fuzzy relationships in object models: Abstraction and interpretation.
• Fuzzy data compression based on data dependencies
• Fuzzy extensions for relationships in a generalized object model
• Fuzzy sets and systems. Theory and applications
• Fuzzy sets as a basis for a theory of possibility
• Generalizing database relational algebra for the treatment of incomplete or uncertain information and vague queries
• Handling fuzzy information in extended possibility-based fuzzy relational databases
• scientific article; zbMATH DE number 2021556 (Why is no real title available?)
• Lossless join property in fuzzy relational databases
• Multivalued dependencies in fuzzy relational databases and lossless join decomposition
• Normalization and lossless join decomposition of similarity-based fuzzy relational databases
• On nearness measures in fuzzy relational data models
• On the impact of regular functional dependencies when moving to a possibilistic database framework.
• Proximity relations in the fuzzy relational database model
• Semantic measure of fuzzy data in extended possibility-based fuzzy relational databases
• Updating extended possibility-based fuzzy relational databases

Cited in

(4)

• Normalization in type-2 fuzzy relational data model based on fuzzy functional dependency using fuzzy functions
• Normalization and lossless join decomposition of similarity-based fuzzy relational databases
• Lossless join property in fuzzy relational databases
• Rough Sets, Fuzzy Sets, Data Mining, and Granular Computing

This page was built for publication: Lossless join decomposition for extended possibility-based fuzzy relational databases

Report a bug (only for logged in users!)Click here to report a bug for this page (MaRDI item Q2336771)