Lossless Join Decomposition for Extended Possibility-Based Fuzzy Relational Databases
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...
Saved in:
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Wiley
2014-01-01
|
| Series: | Journal of Applied Mathematics |
| Online Access: | http://dx.doi.org/10.1155/2014/842680 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1832565481773465600 |
|---|---|
| author | Julie Yu-Chih Liu |
| author_facet | Julie Yu-Chih Liu |
| author_sort | Julie Yu-Chih Liu |
| collection | DOAJ |
| description | 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. |
| format | Article |
| id | doaj-art-f08652bc7d3b4388b55b0f26031dd61f |
| institution | Kabale University |
| issn | 1110-757X 1687-0042 |
| language | English |
| publishDate | 2014-01-01 |
| publisher | Wiley |
| record_format | Article |
| series | Journal of Applied Mathematics |
| spelling | doaj-art-f08652bc7d3b4388b55b0f26031dd61f2025-02-03T01:07:32ZengWileyJournal of Applied Mathematics1110-757X1687-00422014-01-01201410.1155/2014/842680842680Lossless Join Decomposition for Extended Possibility-Based Fuzzy Relational DatabasesJulie Yu-Chih Liu0Department of Information Management, Yuan Ze University, Chung Li, Taoyuan 320, TaiwanFunctional 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.http://dx.doi.org/10.1155/2014/842680 |
| spellingShingle | Julie Yu-Chih Liu Lossless Join Decomposition for Extended Possibility-Based Fuzzy Relational Databases Journal of Applied Mathematics |
| title | Lossless Join Decomposition for Extended Possibility-Based Fuzzy Relational Databases |
| title_full | Lossless Join Decomposition for Extended Possibility-Based Fuzzy Relational Databases |
| title_fullStr | Lossless Join Decomposition for Extended Possibility-Based Fuzzy Relational Databases |
| title_full_unstemmed | Lossless Join Decomposition for Extended Possibility-Based Fuzzy Relational Databases |
| title_short | Lossless Join Decomposition for Extended Possibility-Based Fuzzy Relational Databases |
| title_sort | lossless join decomposition for extended possibility based fuzzy relational databases |
| url | http://dx.doi.org/10.1155/2014/842680 |
| work_keys_str_mv | AT julieyuchihliu losslessjoindecompositionforextendedpossibilitybasedfuzzyrelationaldatabases |