臺灣博碩士論文加值系統

模糊理論用於將人的主觀思考或判斷的過程模型化，並以Fuzzy Set來做定量性處理的方法，故Fuzzy理論的運用日廣，從地下鐵、電梯到洗衣機、照相機等家電運用，並大量運用於電腦和人的主觀性相結合之產品上。
本文中的房屋選購查詢系統即是將電腦運算與人主觀判斷相結合所產生的應用，使用模糊理論的原因主要在於傳統房仲業者所使用的房屋查詢系統，僅能列出與查詢條件相符的資料，無法自動將相近的資料，依據其與條件的接近程度做一適當的選擇呈現。此外，使用者的喜好與需求通常會以模糊的辭彙表達，然而一般的查詢系統卻無法處理具有模糊辭彙的查詢條件。
為了解除上述的缺點及限制，本文將模糊理論與加權的觀念應用在查詢系統，建置一轉置器(Translater)使其能將模糊的查詢條件與加權值，轉為一合理的明確範圍查詢。並將查詢結果根據其與條件的符合度加以排序，方便使用者能快速找到較符合需求的資料。
此外，本文還說明如何運用企業單位實際交易資料做轉換，透過定期更新資料的內容，讓模糊語句轉譯成清晰查詢時更能反映資料的現況。

Fuzzy theory is a method of handling the fixed-quantity, and it is applied to model the subjective thinking and the procedure of judgement for people, therefore, from subway, elevator to appliance such as the washer and camera, fuzzy theory is getting to be used wilder and wilder. And it is also widely applied on the combination of computer and humanity.
The Property Survey System in this content is an application to which to combination of computer calculation and human’s subjective judgment is generated. The reason to use fuzzy theory is to improve the Housing Inquiry System from which the traditional real estate agency can only list the information which corresponds to the condition of inquiry, but can not automatically present the appropriate choice from the similar information. Otherwise, user’s preference and requirement are usually expressed by fuzzy vocabulary, however, general inquiry system is unable to handle the condition with the fuzzy vocabulary.
To resolve the defect and limitation described above, fuzzy theory and perception of weights are applied on the inquiry system in this content. And establishing a translator for translating the fuzzy inquiry condition and weights into an rational and definite range of inquiry. Furthermore, arrange the inquiry results according to the conditional correspondence is convenient to find the correspondent information efficiently for the user.
Additionally, this content also explains how to make the translation by applying the actual transaction information in business. Through the content of updating the information periodically to show the correct condition of information better while translating the fuzzy sentence to the clear inquiry.

一、 緒論…………………………………………………………………...1
1.1 研究動機與目的………………………………………….….....1
1.2 模糊集合的基本概念…………………………………………..2
1.3 論文架構……………………………………………………......9
二、 相關文獻…………………………………………………………….11
2.1 語意變數與模糊項……………………………………………11
2.2 Fuzzy Query相關研究………………………………………...13
2.3 房地產買賣考量因素…………………………………………15
三、 研究內容…………………………………………………………….19
3.1 模糊查詢轉置器架構…………………………………………19
3.2 訂定模糊查詢的Metadata…………………………………….20
3.3 轉換模糊條件為清晰條件……………………………………23
3.4 權重處理………………………………………………………24
3.5 計算隸屬度……………………………………………………26
3.6 效能改善………………………………………………………28
3.7 查詢形態………………………………………………………31
四、 系統實作…………………………………………………………….33
4.1 系統環境說明…………………………………………………33
五、 結論………………………………………………………………….41
5.1 研究貢獻………………………………………………………41
5.2 研究限制………………………………………………………42
5.3 未來研究建議…………………………………………………42
參考文獻……………………………………………………………………44

[1]S.M.Chen, J.S.Ke and J.F.Chang, ”Techniques of fuzzy query translation for database systems” , in Proc. 1986 Int. Computer Symp, Tainan, Taiwan, R.O.C, Dec.1986, pp.1281-1290.
[2]S.M.Chen, W.T.Jong, ”Fuzzy Query Translation for Relational Database Systems” , IEEE Trans. Systems. Man. Cybernet.,Part B:CYBERNETICS. Vol. 27, No. 4, 1997., pp.714-721.
[3]J.Giarratano, G.Riley, ”Expert Systems:Principles and Programming” , Boston, MA:PWS-Kent, 1989.
[4]Buckles, B.P., F.E. Petry, ”Information-theoretical characterization of fuzzy relational databases” , IEEE Trans. Systems. Man. Cybernet., SMC-13(1)(1983 Jan./Feb.).
[5]Buckles, B.P., F.E. Petry, ”A fuzzy representation of data for relational databases” , Fuzzy Sets and Systems 7, 1982, pp.213-226.
[6]Buckles, B.P., F.E. Petry, ”Exetending the fuzzy databases with fuzzy numbers” , Information Sciences 34, 1984, pp.145-155.
[7]Tseng,T.Y., C.M. Klein, ”New Algorithm for the ranking procedure in fuzzy decisionmaking” , IEEE Trans.System.Man. Cybern, Vol.SMC-19, 1989, pp.1289-1296.
[8]L.A.Zadeh, ”The concept of a linguistic variable and its application to approximate reasoning” , Inf. Sci.,Vol.8, No.l3, 1975, pp.199-249.
[9]S.M.Chen, ”Using fuzzy reasoning techniques for fault diagnosis of the J-85 jet engines” , Proceedings of the Third National Conference on Science and Technology of National Defense,Taoyuan,Taiwan,Republic of China, 1995, pp.216-219.
[10]A. Kaufmann, M.M. Gupta, ”Fuzz Mathematical Models in Engineering and Management Science” , Amsterdama: North-Holland, 1988.
[11]Y.C.Hou, C.M.Chen, ”Apply the fuzzy set theory to the structural query language of database” , Proceeding International Joint Conference of CFSA/IFIS/SOFT’95 on Fuzzy Theory and Applications, Taipei, Taiwan, Republic of China, 1995, pp.107-113.
[12]F.E. Petry, “Fuzzy Databases: Principles and Applications” , Kluwer Academic Publishers, Boston, 1996.
[13]A.Kaufmann, M.M.Gupta, ”Introduction to fuzzy arithmetic” , Van Nostrand Reinhold, New York, 1991.
[14]L.A. Zadeh, “Fuzzy sets” ,Information and Control, Vol.8, 1965, pp.338-353.
[15]R. Bellman, M. Giertz, “On the Analytic Formalism of the Theory of Fuzzy Sets” , Information Sciences 5, 1973, pp.149-156.
[16]Lin, Yun-Shyang; Chen, Shyi-Ming, "Using Automatic Clustering Techniques for Fuzzy Query Processing in Relational Database Systems", The Eleventh National Conference on Information Management, 2000, pp1185-1194.
[17]Yu-Chuan Chen, Shyi-Ming Chen, "Techniques of Fuzzy Query Processing for Fuzzy Database Systems" , Proceedings of the Fifth Conference on Artificial Intelligence and Applications, 2000, pp361-368.
[18]Gupta, J. Oi, “Theory of T-norms and fuzzy inference methods” , Fuzzy Sets and Systems 40(3), 1991, pp431-450.
[19]Zimmermann, “Fuzzy Set Theory and Its Applications” ,Kluwer Academic Publishers, Dordrecht, 1991.
[20]Janusz Kacprzyk, Slawomir Zadrozny, “Computing with words in intelligent database querying: standalone and Internet-based applications” ,Information Sciences 134, 2001, pp71-109.
[21]B. Schweizer and A. Sklar, "Associative functions and abstract semigroups" , Publ. Math. Debrecen,Vol. 10, 1963, pp69-81.
[22]R. Yanger, "On a general class of fuzzy connectives" , Fuzzy Sets and Systems,Vol 4,No. 3, 1980, pp235-242.
[23]M. J. Frank, "On the simultaneous associativity of F(x, y) and x+y-F(x, y)" , A Equations Mathematicae, Vol. 19, No.2-3, 1979, pp194-226.
[24]W. Yn and Z. Bien, "Design of fuzzy logic controller with inconsistent rule base" , Journal of Intelligent & Fuzzy Systems, Vol. 2, No. 2, 1994, pp147-159.
[25]Yager R. R., S. Ovchinnikov, R. M. Tong, and H.T. Nguyen, "Fuzzy Sets and Applications：Selected Papers by L.A. Zadeh" , Wiley-Interscience, 1987, pp46-79.
[26]Zimmermann, Hans J., "Fuzzy Sets, Decision Making, and Expert Systems" , Kluwer Academic Publishers, 1987.
[27]D. Lucarella and R. Morara, "First： Fuzzy information retrieval system" , J. Inf. Sci.,Vol 17, No. 1, 1987, pp81-91.
[28]劉俞志, 黃堯銘, "Using Proximity Semantic Equivalence for Fuzzy Query in Fuzzy Databases" , The Thirteen National Conference on Information Management, 2002, accepted.
[29]左心強, 黃堯銘, 劉俞志, "Apply fuzzy theory to property survey system" , Information Symposium on Digital Life and Internet Technologies, 2002, Accepted.
[30]張振芳,“房地產仲介業略資訊系統中之買賣配對專家系統的建構研究”, 東海大學企業管理研究所碩士論文, 1991.
[31]王琬宜,“地理資訊系統在不動產查詢與分析上之應用”, 政治大學地政學系碩士論文, 1999.
[32]江芳彬,“關聯式資料庫中模糊查詢整合模式之建立-以房屋仲介資訊為例”, 台灣工業技術學院碩士論文, 1993.
[33]徐瑞豐, “模糊查詢與模糊關連式資料庫整合模式-以觀光旅遊全球資訊網路系統為例”, 台灣科技大學碩士論文, 1995.
[34]何智明, “消費者住屋購買行為關鍵因素之研究-以台北都會區為例”, 中興大學碩士論文, 1998.
[35]郭嘉昌, “新竹科學工業園區員工對住宅環境偏好之分析”, 中華大學碩士論文, 2000.
[36]翁志賢, “消費者購屋行為之探討-品牌權益，品牌態度與購屋評估準則對購屋意圖之影響”, 成功大學碩士論文, 2000.
[37]蘇振昌, “消費者的網路資訊搜尋對購屋行為之影響”, 輔仁大學碩士論文, 1999.
[38]鄭淵聰, “中老年人對老人住宅購買行為及行銷策略之初探性研究-以台中都會區為例”, 雲林科技大學碩士論文, 1998.
[39]何志南, “住宅消費模式之建構與分析”, 成功大學碩士論文, 2000.
[40]黃嘉興, “不動產投資管理”, 新陸, 台北, 2001.
[41]王文俊, “認識Fuzzy”, 全華, 台北, 1997.
[42]林信成, 彭啟峰, “Oh! Fuzzy模糊理論剖析”, 第三波, 台北, 1994.
[43]蘇木春, 張孝德, “機器學習類神經網路、模糊系統以及基因演算法則”, 全華, 台北, 1997.