臺灣博碩士論文加值系統

採用元件式軟體發展技術(Component Base Software Develop- ment, CBSD)方法將關連式資料庫特性與物件導向開發技術結合，設計出融合資深開發人員與設計師的商業知識背景之關連式資料庫元件產生器(Database Business Component Generator, DBCG)，藉由DBCG減少技術人員異動造成專案品質難以掌控問題、縮減應用系統專案的開發時程與減少錯誤的發生。
本論文是在三層式應用系統架構的商業邏輯層提出關連式資料庫元件產生器(DBCG)，DBCG可以快速產生資料庫商業元件(Database Business Component, DBC)，可供網頁應用程式(Web Form)或視窗應用程式(Window Form)所使用，元件是使用ADO.Net物件或OLE DB.Net物件，透過資料提供者的DataReader、DataAdapter及Command物件連接關連式資料庫，間接與關連式資料庫進行交易處理，DBC可以做為展示層與資料層進行資料存取的中介元件。
系統開發人員依需求採用軟體元件組裝的方式開發應用系統，隨時可依關連表格增減產生新的元件，修改時亦僅侷限部分元件而不需要牽動整個系統。軟體開發者只需要專注於有價值的商業邏輯撰寫，研究結果顯示依照軟體特性與軟體度量，整個開發時程因而減少1/3時程，系統平均每千行錯誤率也由5.4個錯誤下降至2.3個錯誤，專案管理在設計階段的軟體品質因此獲得改善。

Component-based software development (CBSD) was adopted to combine the relation database property and Object-Oriented development methology to develop the relation database business component generator (DBCG) for senior developers and designers with business knowledge. By using DBCG to reduce the unexpected problems of project quality which were caused by the usage of different engineers, it is believed that DBCG can also shorten the developing schedule and avoid the mistakes occurred in the process.
This paper is to bring up an DBCG on business logic tier of three-tier application system of structure. DBCG can rapidly generate the database business components (DBC) to offer the use of the web form or window form. The generated components conver ADO.Net object or OLE DB.Net object to link the relational database through the DataReader, DataAdapter and Command objects by the data providers. It can transact with the relational database exchangely. DBC can be the intermediary component between the presentation tier and data service tier to deposit and withdraw the materials.
The system developers can base on the DBCG to develop the application system with the software component assembled methods. The system developers can generate a new component occasionally due to the change of the relations. When the system needs to to be modified, the software developers only need to focus on some valued business logic writing without modifying the whole system. The data showed that according to the software features and software measurement, the schedule of development can be shortened one third and every a thousand lines mistake rate on average of the system drops from 5.4 errors to 2.3 errors. It can be seen that the software quality of project management in the design phase can be improved.

封面內頁
簽名頁
授權書………..……..……………………………………………....iii
中文摘要……..……………………………………………………....iv
英文摘要……….…………………………………………………....vi
誌謝………………………………………………………………....vii
目錄………….……………………………………………………....viii
圖目錄………………………………………………………………....xi
表目錄……………………………………………………………….xiii

第一章　緒論
1.1 研究背景與動機 1
1.2 研究目的 3
1.3 研究流程 4
1.4 研究範圍與限制 6
1.5 論文架構 6
第二章　文獻探討
2.1 資料庫管理系統 8
2.1.1 關連式資料庫系統 8
2.1.2 物件導向式資料庫系統 9
2.1.3 物件關聯式資料庫系統 9
2.1.4 「關連表綱要」 9
2.1.5 結構化查詢語言 9
2.2 軟體專案管理 10
2.2.1 專案開發管理 11
2.2.2 專案開發模式 12
2.2.3 軟體流程與軟體流程改善 16
2.3 物件導向軟體工程 18
2.3.1 物件 19
2.3.2 類別 19
2.3.4 封裝 19
2.3.5 繼承 19
2.3.6 多型 20
2.3.7 元件式軟體發展技術 20
2.4 應用系統架構 21
2.4.1 主從式架構 22
2.4.2 三層式架構 22
2.4.3 .NET平台 23
2.5 軟體品質管理 24
2.5.1 專案品質管理 25
2.5.2 軟體品質評量 26
2.5.3 軟體品質特性 26
2.5.4 品質的測量 30
2.5.5 個人軟體流程 32
第三章　研究方法與系統架構
3.1 研究方法 36
3.2 系統架構 36
3.3 關連式資料庫元件 40
第四章　關連式資料庫商業元件產生器之設計
4.1 元件基礎類別架構 42
4.2 元件基礎功能 44
4.2.1 表格類別 45
4.2.2 表格集合類別 48
4.2.3 商業交易作業函數類別 49
4.3 關連式資料庫商業元件產生器專案 51
4.3.1 關連式資料庫商業元件產生器專案 53
4.3.2 關連式資料庫商業元件專案 56
4.4 表格類別設計概念 57
4.4.1 關連表格類別範例 59
4.4.2 同步商業交易處理類別範例 73
第五章　專案管理設計階段品質改善
5.1 設計階段品質改善 79
5.2 研究成果 81
第六章　結論
6.1 研究結論 86
6.2 未來的研究方向 87
參考文獻 89

圖目錄

圖1.1 研究流程 5
圖2.1 專案開發模式圖 13
圖2.2 三層式架構圖 22
圖2.3 品質評量概念圖 26
圖3.1 DBCG系統架構圖 37
圖3.2 DBCG元件資料存取架構圖 38
圖4.1 關連式資料庫商業元件架構圖範例 43
圖4.2 關連式資料庫關連表類別圖 44
圖4.3 關連式資料庫關連表類別圖 49
圖4.4 異動交易處理類別圖 49
圖4.5 DBCG程式碼產生器專案 51
圖4.7 DBCG系統操作步驟圖－資料來源設定 53
圖4.8 資料來源設定XML檔 53
圖4.9 DBCG系統操作步驟圖－資料庫商業元件產生器 54
圖4.10 DBCG系統操作步驟圖－Bussiness元件產生 55
圖4.11 DBCG資料庫元件專案 57
圖4.12 收文創稿流程類別程式碼 61
圖4.13 收文創稿流程類別程式碼－Insert() 63
圖4.14 收文創稿流程類別程式碼－Update() 65
圖4.15 收文創稿流程類別程式碼－Delete() 66
圖4.16 收文創稿流程類別程式碼－IsExist() 68
圖4.17 收文創稿流程類別程式碼－Refresh() 70
圖4.18 收創文流程類別程式碼－RcvflowCollection() 73
圖4.19 同步交易類別程式碼－DBFun.cs 75
圖4.20 同步交易類別程式碼－收文登記新增 78

一、中文部份
1.林信惠、黃明祥、黃文良，軟體專案管理，智勝圖書股份有限公司，2002。
2.賴森堂，「以類別品質提昇物件導向軟體維護性之研究」，第十三屆物件導向技術及應用研討會，2002。
3.黃松浪編譯，軟體工程第3 版，台北：儒林，1993 譯自Pressman, R.S。
4.陳秋霞，賴森堂，「資訊軟體品質評量之研究」，第四屆全國品質管理研討會，中壢，元智大學，頁29-35，1998年。
5.曾守正、周韻寰編著，資料庫系統進階實務，儒林圖書，1999。
6.吳仁和、林信惠,系統分析與設計：理論與實務應用,智勝文化，2002。
7.許育誠，軟體設計與品質管理，文魁，2003。


二、英文部份
8.Dien D. Phan, Douglas R. Vogel, and Jay F. Nunamaker, Jr., "Empirical Studies in Software Development Projects: Fields Survey and OS/400 Study," Information & Management, Vol. 28, No. 4, pp. 271-280, Apr. 1995.
9.Roger S. Pressman, Software Engineering: A Practitioner’s Approach. 5th Edition. New York: McGraw-Hill, 1987.
10.Roger Stephen Schach, Classical and Object-Oriented Software Engineering. New York: McGraw-Hill Companies, 1999.
11.Edward Yourdon, Rise and Resurrection of the American Programmer. Upper Saddle River, NJ: Yourdon Press,, 1996.
12.Fisher J. and Light WR, Jr., "Definitions of Software Quality Management," Software Quality Management, New York: Petrocelli Books, 1979.
13.IEEE Standard Glossary of Software Engineering Terminology,　IEEE Std 729, 1983.
14.Department of defense, Washington, Defense System Software Development and Documentation Standard, DOD-STD-2167A, 29 Feb. 1988.
15.Barbara Kitchenham, "Software quality assurance," Microprocessors and Microcomputers, Vol. 13, No. 6, pp. 373–381, Aug. 1989.
16.Alan W. Brown, Editor, Component-Based Software Engineering. New York: IEEE Computer Society, 1996.
17.Alan W. Brown and Keith Short, "On Components and Objects: The Foundations of Component Based Development," Assessment of Software Tools and Technologies, IEEE CS Press, pp. 112-121, Jun. 1997.
18.Rajiv D. Banker, Robert J. Kauffman, and Rachna Kumar, “An Empirical Test of Object-based Output Measurement Metrics in a CASE Environment,” Journal of Management Information, Vol. 8, No. 3, pp. 127–150, Feb. 1992.
19.Ramez Elmasri and Shamkant B., Fundamentals of Database Systems. 4th Edition. Massachusetts: Addison Wesley, 2003.
20.Sean Eom, "Database Systems: Concepts, Languages and Architectures," Journal of Database Management, Vol. 12, No. 1, pp. 48-49, Jan.-Mar. 2001.
21.II-Myoung Kwon, et al., “Building Generic Data Interface through a Data Object Generalization Pattern,” Journal of Object-Orient Programming, Vol. 13, No. 6, pp. 6-10, 1999.
22.George T. Heineman and William T. Councill, Component-Based Software Engineering: Putting The Pieces Together. New York: Addison-Wesley, 2001, pp. 1-500.
23.I. Rus and M. Lindvall, “Knowledge Management in Software Engineering,” IEEE Software, pp. 26-38, May/Jun. 2002.
24.Adnane Belout and Clothilde Gauvreau, “Factors influencing project success: the impact of human resource management,” International Journal of Project Management, Vol. 22, No. 1, January, pp. 1-11, 2004.
25.Prodromos D Chatzoglou and Linda A Macaulay, “The Importance of Human Factors in Planning the Requirements Capture Stage of a Project,” International Journal of Project Management, Vol. 15, No. 1, pp. 39-53, Feb. 1997.
26.T. Lister, “Hallucinations at 37,000 feet,” IEEE Software, Vol. 15, No. 3, pp. 105-107, May-Jun. 1998.
27.Sajjad Mahmood, et al., “A survey of component based system quality assurance and assessment,” Information and Software Technology, Vol. 47, No. 10, pp. 693-707, Jul. 2005.
28.Thomas Drake, “Measuring Software Quality : A Case Study,” Computer , Vol. 29, No. 11 , pp. 78-87, Nov. 1996.
29.CMMI Product Team, Capability Maturity Model Integration. Ver 1.1, CMMI-SW/SE/IPPD/SS, Continuous Representation CMU/SEI-2002-TR-011, 2002.
30.CMMI Product Team, Capability Maturity Model Integration. Ver 1.1, CMMI-SW/SE/IPPD/SS, Continuous Representation CMU/SEI-2002-TR-012, 2002.
31.M. Jorgensen, "Software quality measurement," Advances in Engineering Software, Vol. 30, No. 12, pp. 907-912, Dec. 1999.
32.Motoei Azuma, "Software products evaluation system: quality models, metrics and processes–International Standards and Japanese Practice," Information and Software Technology, Vol. 38, No. 3, pp.145-154, Mar. 1996.
33.Mark. C. Paulk, et al., Capability Maturity Model for Software, Vol 1.1. Technical, Software Engineering Institute, Report No. CMU/SEI-93-TR-024, Feb. 1993.
34.Olson, Timothy G., et al., Conducting SEI-assisted software process assessment. Software Engineering Institute, Report No. CMU/SEI-89-TR-7, 1989.
35.E. F. Codd, "A Relational Model of Data for Large Shared Data Banks," Communications of the ACM, Vol. 13, No. 6, pp. 377-387, Jun. 1970.
36.E. F. Codd, "Relational Database: A Practical Foundation for Productivity," Communication of the ACM, Vol. 25, No. 2, pp. 109-118, Feb. 1982.
37.Hock Chuan Chan, Hong Jun Lu, and Kwok Kee Wei, "A survey of SQL language," Journal of Database Management, Vol. 4, No. 4, pp. 4-16, Fall 1993.
38.Ramakanth S. Devarakonda,"Object-Relational Database Systems - The Road Ahead," Communications of the ACM, Vol. 7, No. 3, pp. 15-18, Mar. 2001.
39.Greg Baster, Prabhudev Konana, and Judy E. Scott, "Business components: a case study of bankers trust Australia limited," Communications of the ACM, Vol. 44, No. 5, pp. 92-98, May 2001.
40.Shih-Chien Chou and Jen-Yen Jason Chen, "An object-oriented analysis technique based on the unified modeling language," Journal of Object - Oriented Programming, Vol. 14, No. 2, pp. 32-42, Jun./Jul. 2001.
41.Ivar Jacobson, Object-Oriented Software Engineering, a Use Case Driven Approach. Wokingham UK: Addison-Wesley, 1995.
42.James R Rumbaugh, et al., Object-Oriented Modeling and Design. Englewood Cliffs, NJ: Prentice Hall, 1991.
43.Talib Damij, "A procedure for object-model development," Journal of Object - Oriented Programming, Vol. 13, No. 8, pp. 16-19, Dec. 2000.
44.Ying Liang, "An approach to assessing and comparing object-oriented analysis methods," Journal of Object - Oriented Programming, Vol. 13, No. 3, pp. 27-33, Jun. 2000.
45.Alan W. Brown and Kurt C. Wallnau, "The Current State of CBSE," IEEE Software, Vol. 15, No. 5, pp. 37-46, Sep.-Oct. 1998.
46.Yunsik Ahn, et al., "The software maintenance project effort estimation model based on function points," Journal of Software Maintenance, Vol. 15, No. 2, pp. 71-85, Mar. 2003.
47.Te-Wei Wang and Kenneth E Murphy, "Semantic Heterogeneity in Multidatabase Systems: A Review and a Proposed Meta-Data Structure," Journal of Database Management, Vol. 15, No. 4, pp. 71-87, Oct.-Dec. 2004.
48.Qianxiang Wang, et al., "A component-based approach to online software evolution," Journal of Software Maintenance, Vol. 18, No. 3, pp. 181-205, May/Jun. 2006.
49.Graham Tate and Thomas W. G. Docker, "A rapid prototyping system based on data flow principles," ACM SIGSOFT Software Engineering Notes, Vol. 10, No. 2, pp. 28-34, Apr. 1985.
50.Joao W. Cangussu and Richard M. Karcich, "A control approach for agile processes," IEEE Conference Proceeding, Vol. 2, No. 1, pp. 123-126, Jul. 2005.