臺灣博碩士論文加值系統

本研究探討了模糊關聯資料庫的型態、模糊功能相依、模糊多重值相依及模糊資料庫的應用等議題，並介紹模糊關聯資料庫的四種類型。在資料庫的設計中，正規化在模糊資料庫中變成一個很重要的問題，正規化可使得資料庫在異動時不會產生失真、資料重覆的現象，正規化中資料相依是非常重要的議題包括功能相依、多重值相依。
模糊功能相依、模糊多重值相依是指屬性之間的關係，是否關聯表中所有不為主鍵之屬性都全部功能相依於關聯表中的主鍵，且因模糊資料的表達方式多元，所以要比對兩筆記錄的屬性值是否相等，就透過測量模糊資料屬性值之間的語意關係，其測量結果為語意相等的程度，愈趨近於1表示此模糊資料愈相等。

This research discuss about the topic of such application type as fuzzy relation database, fuzzy function dependence, fuzzy multiple-value dependence, and introduction of four kinds of the fuzzy relation database. During the process of database designing, the normalization is getting become as a very important problem on fuzzy relation database. The function of normalization in database can be evaded the happening of distortion and data reoccurrence; data dependence during the normalization with regarding to function dependence, multiple-value function dependence can also thought of as an importance issue.
Fuzzy function dependence, fuzzy multiple-value dependence is refers to the relationship of attributes, whether attribute of all non-primary key depends upon the primary key in the relation table. Besides, there are many kind of fuzzy data expression methods, therefore, whether to compare the value of two tuple attributes with each other is equal or not, should have tested through the measurement of such semantic relation among the attributes of fuzzy data. Suppose to compare results of such measuring with each other is equal to the degree of semantic, the more approaching to the value of 1; the more equality of such fuzzy data.

中文摘要…………………………………………………………… IX
英文摘要…………………………………………………………… IX
致謝辭……………………………………………………………… IX
目錄………………………………………………………………… IX
圖目錄……………………………………………………………… XI
表目錄……………………………………………………………… IX
第一章 緒論……………………………………………………… 1
1.1 研究背景……………………………………………………… 1
1.2 研究動機……………………………………………………… 3
1.3 研究目的……………………………………………………… 3
1.4 論文架構……………………………………………………… 3
第二章 文獻探討………………………………………………… 5
2.1 關聯資料庫（Relational Databases）的基本概念……… 5
2.2 模糊集理論（Fuzzy Sets theory）的基本概念………… 6
第三章 模糊資料庫介紹………………………………………… 9
3.1 模糊資料類型………………………………………………… 9
3.2 模糊關聯資料庫（Fuzzy Relational Databases）……… 9
3.3 模糊關聯資料庫的種類……………………………………… 11
3.3.1 相似關聯為主的關聯模型………………………………… 8
3.3.2 近似關聯為主的關聯模型………………………………… 13
3.3.3 可能性為主的關聯模型…………………………………… 14
3.3.4 延伸可能性為主的關聯模型……………………………… 14
第四章 模糊關聯資料庫的研究及應用………………………… 16
4.1 模糊關聯資料庫的等價類別………………………………… 16
4.2 模糊關聯資料庫的功能相依、多重值應用………………… 20
4.2.1 關聯式資料庫之正規化理論……………………………… 21
4.2.2 功能相依性（functional dependencies）…………… 23
4.2.3 多重值相依性(Multi-valued dependency)…………… 25
4.2.4 延伸可能性為主模糊資料庫的資料相依………………… 27
4.3 模糊關聯資料庫的應用……………………………………… 34
第五章 結論……………………………………………………… 37
5.1 研究結論及建議……………………………………………… 37

[1] 林信成、彭啟峰，〈Oh！Fuzzy─模糊理論剖析〉，頁1-7~1-16
[2] E. Codd, Further Normalization of the Data Base Relational
Model, In Rustin, 1972.
[3] 卓嫈琴，「模糊關聯式資料庫之模糊多重值相依性研究」，私立元
智大學 資訊管理研究所碩士論文，民91.
[4] S. Shenoi and A. Melton, “Proximity Relations in the
Fuzzy Relational Database Model”,Fuzzy Sets and Systems,
Volume 31, pp.285-296, 1989.
[5] D. Dubois and H. Prade, “Fuzzy Sets and Systems：Theory
and Applications”, Academic Press, New York, 1980.
[6] H. Prade and C. Testamale, “Generalizing Database
Relational Algebra for the Treatment of Incomplete or
Uncertain Information and Vague Queries”, Information
Sciences, 34, pp.115-143, 1984.
[7] Guoqing Chen, Etienne E. Kerre, and Jacques Vandenbulcke,
“A General Treatment of Data Redundancy in a Fuzzy
Relational Data Model”, Journal of the American Society
of Information Science, Volume 43, pp.304-311, 1992.
[8] Anna Czinkoczky Sali, “The Combinatorial Structure of
Fuzzy Functional Dependencies”, IEEE, pp.239-243, 1997.
[9] 曾守正/著，〈資料庫系統之理論與實務〉，1999年14版，頁11-
6~11-41
[10] W.W. Armstrong, “Dependency structures of Data Base
Relationships,” Proceedings of the IFIP Congress, pp.580-
583, 1974.
[11] C. Beeri, R. Fagin, and J.H. Howard, “A Complete
Axiomatization for Function and Multivalued
Dependencies”, Proc. ACM SIGMOD-ACM International
Conference on Management of Data, pp.47-61, 1977.
[12] Z. M. Ma, W. J. Zhang W. Y. Ma, and F. Mili, “Data
Dependencies in Extended Possibility-Based fuzzy
relational database,”International Journal of
Intelligent System, Volume 17, pp.321-332, 2002.
[13] Zhang Ming, Ye Ming, Hu Hailiang, “Fuzzy Processing
Based on a Management Information System”, IEEE, pp.351-
354,1997.
[14] Michinori Nakata, “Dependencies in Fuzzy Databases :
Functional Dependency”, IEEE, pp.757-764,1995.
[15] Michinori Nakata, “Dependencies in Fuzzy Databases :
Multivalued Dependency”, IEEE, pp.1591-1597, 1996.
[16] Rolly Intan, Masao Mukaidono, “Fuzzy functional
dependencies and its Application to Approximate Data
Querying”, IEEE, pp.47-54, 2000.
[17] K. V. S. N. Raju and Arun K. Majundar, “Fuzzy functional
dependencies and lossless join decomposition of fuzzy
relational database systems”, ACM Transactions on
Database Systems, Volume 13, pp.129-166, 1988.
[18] P.C. Saxena and B.k. Tyagi, “Fuzzy functional
dependencies and independencies in extended fuzzy
relational database Model”, Fuzzy Sets and Systems,
Volume 69, pp.65-89, 1995.
[19] L.A. Zadeh, “Fuzzy Sets”, Journal of Information and
Control, Volume 8, pp.338-353, 1965.
[20] B.P. Buckles and F.E. Petry, “A Fuzzy Representation of
Data for Relational database”, Fuzzy Sets and Systems,
Volume 5, pp.213-226, 1992.
[21] Z.M. Ma, W.J. Zhang, W.Y. Ma, “Semantic measure of fuzzy
data in extended possibility-based fuzzy relational
databases.”, International Journal of Intelligent
Systems, Volume 15, Issue 8 , pp.705-716, 2000.
[22] Z.M. Ma, W.J. Zhang, and W.Y. Ma, “Assessment of data
redundancy in fuzzy relational databases based on
semantic inclusion degree”, Information Processing
letter, 72, pp.25-29, 1999.
[23] R. Fagin, “Multivalued dependencies and a new normal
form for relational databases”, ACM Transactions on
Database Systems, Volume 2, No.3, pp.262—278, 1977.