The Research on Applying Relation Database Component Generator for Quality Improvement of Project Management in ...
蕭志昌、楊豐兆
E-mail: 9510753@mail.dyu.edu.tw
ABSTRACT
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.
Keywords : project management ; component-based software development ; database business component generator ; software metrics ; software quality
Table of Contents
封面內頁 簽名頁 授權書...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.2 軟體專案管理 ...10 2.3 物件導向軟體工程 ...18 2.4 應用系統架構 ...21 2.5 軟體品質管理 ...24 第三章 研究方法與系統架構 3.1 研究方法 ...36 3.2 系統架構 ...36 3.3 關連式資料庫元件 ...40 第四章 關連式資料庫 商業元件產生器之設計 4.1 元件基礎類別架構 ...42 4.2 元件基礎功能 ...44 4.3 關連式資料庫商 業元件產生器專案 ...51 4.4 表格類別設計概念 ...57 第五章 專案管理設計階段品質改善 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
REFERENCES
一、中文部份 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.
