臺灣博碩士論文加值系統

有效的企業經營管理與決策有賴正確的資訊，而正確的資訊的基礎在於資料完整性(data integrity)與資訊完整性(information integrity)。目前資料庫之cascade update功能滿足了資料完整性之需求，而資訊完整性則多運用所使用之特定資料庫所提供之Active Database 實作機制，針對企業邏輯撰寫維護程式，由於受限於特定資料庫品牌，使得維護程式缺乏可攜性(portability)，再由於係針對企業邏輯撰寫使得該維護程式僅適用於特定企業而缺乏一般性(genericity)與可設定性(configurability)，以致於不具軟體可再用性(reusability)，也使得企業資訊系統之開發與維護成本居高不下。
本研究提出一具一般性之資訊完整性維護模式(information integrity maintenance model)，使之適用於各個企業或組織，並依此模式設計一資訊串連更新元件，使其具有企業邏輯可設定性、資料庫可攜性，以利資訊完整性維護機制之建立，提供資訊系統開發者與維護人員更簡易、更具彈性之解決方案。

Business administration and complicated decision making fully rely on the accurate information gathered from the whole enterprise on the basis of data integrity and information integrity . As far as data integrity is concerned, the cascade update functionalities provided by database systems are often used for the data integrity maintenance. Meanwhile, Active Database mechenisms provided by some specific database firms are often used to maintain information integrity, and the logic of information integrity mainenance program are designed for specific enterprises under specific specification proposed by different database system providers. The differences of enterprise business logic and program implementation specification cause that all the information integrity maintenance programs are lack of portability, genericity, configurability and reusability, and the unacceptable high cost of system
development and mainenance.
In this thesis a generic information integrity maintence model is proposed and can be applied to every kind of enterprises or organizations. Then, according to the model, an information integrity maintenance component model is developed, with the property of business logic configurability, database portability that can facilitate the construction of information integrity maintenance mechanism, providing a simple and flexible information integrity maintenance solution for
information system developer and maintainer

第一章 緒論1
1.1　研究背景1
1.2　研究動機2
1.3　研究目的2
1.4　問題分析3
1.5　研究步驟與方法3
1.6　論文架構5
第二章　文獻探討7
2.1資料完整性7
2.1.1 資料完整性定義7
2.1.2　資料完整性維護9
2.1.3　串連更新11
2.2　資訊完整性13
2.2.1　資訊完整性定義13
2.2.2　資訊完整性維護14
2.2.2.1　Active Database15
2.3 企業規則16
2.4 軟體元件18
第三章 資訊完整性維護分析與模式設計20
3.1 使用者觀點之資訊完整性維護分析20
3.2　使用者觀點之資訊活動型態分析24
第四章 資訊串連更新元件設計42
4.1 串連更新程序分析42
4.1.1 來源資訊活動43
4.1.2 串連更新之資訊活動46
4.1.2.1目的資料表與目的資料操作型態定義47
4.1.2.2 來源資料表與目的資料表之對應關係定義52
4.1.3 檢查規則59
4.1.3.1 operand61
4.1.3.2 operator62
4.2 串連更新程序之定義綱要設計64
4.3 串連更新之資料庫交易模式分析73
4.4 元件設計80
第五章 元件實作與驗證92
5.1 實作環境介紹92
5.2 元件實作93
5.3 元件模型驗證99
5.3.1 YJS-ERP簡介99
5.3.2　資訊串連更新元件之驗證105
第六章 結論與未來研究方向128
6.1 結論與成果128
6.2 未來研究方向建議130
參考文獻132
附錄A 定義綱要說明134

[1]Beck, J.E., Reagin, J.M., Sweeny, T.E., Anderson, R.L. and Garner, T.D., “Applying a component-based software architecture to robotic workcell applications,” IEEE Transactions on Robotics and Automation, 2000, Page(s): 207 —217
[2]Chandra, R.; Segev,A ” Active databases for financial applications,” Research Issues in Data Engineering, 1994. Active Database Systems. Proceedings Fourth International Workshop on , 14-15 Feb. 1994 , Page(s): 46 -52
[3]Chauki, Jeong and Shahsavari, M.M, “Component-based distributed network management,” Proceedings of Southeastcon 2000, 2000 , Page(s): 460 —466
[4]Elmasri, Navarhe, “Fundamentals of Database Systems,” third Edition, Addison-Wesley, 2000
[5]Fingar and Peter, “Component-Based Frameworks for E-Commerce,” Communications of the ACM, 2000, Page(s): 61
[6]Jeri Edwards, "3-Tier Client/Server At Work," ISBN 0-471-18443-8, Wiley Computer Publishing, 1997
[7]John K.Akeson, “ASSURING SYSTEM DATA INTEGRITY — AN OVERVIEW”, Global Telecommunications Conference, 1989, and Exhibition. ''Communications
Technology for the 1990s and Beyond''. GLOBECOM ''89., IEEE , 27-30 Nov. 1989 Page(s): 217 -221 vol.1
[8]Merle P. Martin, “ANAYSIS AND DESIGN OF BUSINESS INFORMATION SYSTEMS” second edition, Prentice-Hall International Editions, 1995
[9]Object Management Group, http://www.omg.org/
[10]Paul Prabhaker, “Integrity of Information: The Next Competitive Advantage?” , Information Integrity Coalition, http://www.informationintegrity.org/, 2003,
[11]Ravi Sandhu, “A perspective on integrity mechanisms”, Computer Security Applications Conference, 1989., Fifth Annual , 4-8 Dec 1989 Page(s): 279
[12]Richard Monson-Haefel, "Enterprise JavaBeans" , ISBN 957-8247-42-7, O''Reilly, 2001
[13]Ronald G. Ross,“Expressing business rules”, ACM SIGMOD Record , Proceedings of the 2000 ACM SIGMOD international conference on Management of data, May 2000
[14]Rosca, D., Greenspan, S., Feblowitz, M. and Wild, C.,“A decision making methodology in support of the business rules lifecycle Requirements Engineering,” 1997., Proceedings of the Third IEEE International Symposium , 1997, Page(s): 236—246.
[15]The Future Is Freedom Pty Ltd,http://www.freedomsoft.com.au/technology.htm
[16]William E.Perry, “Ensuring Database Integrity”, Ronald Press, 1983
[17]呂學錄, 『聯盟同步工程之全方位式工程資料管理架構設計』,碩士論文,成功大學 製造工程研究所, 1999
[18]林裕隆, 『元件式企業軟體應用系統解決方案』,http://www.sos747.com.tw/ASP/Feature/sosf-main.htm
[19]柯育泉, 『以元件為基之多層次企業資源規劃系統架構設計』,碩士論文,成功大學 製造工程研究所, 2001
[20]陳宗義, 『以企業資源規劃為基之彈性化電子商務系統架構設計』,碩士論文,成功大學 製造工程研究所, 2001
[21]楊仁達, 『元件式電子商務應用與趨勢』,http://www.sos747.com.tw/ASP/Feature/sosf-main.htm
[22]楊哲彥, 『協同式知識管理系統架構設計』,碩士論文,成功大學 製造工程研究所, 2002
[23]詹彥道, 『虛擬企業供應鏈監控系統之研發』,碩士論文,成功大學 製造工程研究所, 2000
[24]魏豪江, 『跨企業動態工作流程管理核心元件開發』,碩士論文,成功大學 製造工程研究所, 2003