基于PowerBuilder与SQL Server的体检管理系统设计
|
摘要
医院信息系统是新兴的医学信息学的重要分支,主要目标是实现数据动态管理,以实现医院管理、临床医疗和科研教学的信息网络化。体检管理系统是医疗信息管理的重要组成部分,能够提高医院体检业务的工作效率,实现高效量化管理,使体检信息更加准确、全面、完美,明显提高体检业务的竞争力。
论文从系统开发的必要性和背景入手,对软件工程、面向对象等关键技术进行分析,在此基础上详细分析了系统需求,阐明了详细的系统设计,包括系统的设计目标及原则、模块设计、系统命名及编码规则、业务流程等,并着重阐述了系统的实现方法,包括数据库建设、界面实现及代码编写,最终完成了体检管理系统的设计与实现。
在关键技术上,系统采用了软件工程的方法和面向对象技术;在实现技术上,系统选择了Sybase公司的PowerBuilder作为前台开发工具,微软公司的SQL Server关系数据库作为后台数据库系统,并进行了友好配合;在此基础上,分析了系统开发策略,制定了相应的技术路线。
在系统设计中,依据需求分析,确定了系统目标、原则及模块,依次进行了总体模块设计、流程设计、接口及数据表设计、安全设计、用户界面设计。
在系统实现上,确定了系统的软硬件运行环境,创建了相关数据库,分析了详细业务流程,制定了命名、编码规则,对用户界面和系统使用进行了详细设计。
本文分析了系统的背景,确定了课题研究的主要内容和范围,运用软件工程生命周期法的思想,通过对体检前台基本业务的具体分析,指出了业务的关键点,建立了系统的总体结构,并对各管理模块进行了具体的功能描述;然后进行了系统总体规划和详细设计(各功能模块、数据库、数据接口等);具体讨论了系统研发过程中所遇到的几个关键问题;描述了系统的实现过程;对系统的运行情况进行了闸述;最后总结了系统研发工作并闸述了下一步的拓展思路。
Hospital information system is an important branch of new and developing medical information science with the goal of realization management of dynamic data, with which the hospital management, clinical medical treatment and scientific research can be conducted through information network. The physical examination management information system, as an important part of medical treatment information management system, can help to improve the efficiency in physical examination, realize the efficient and quantified management. The application of the system may provide with an accurate, comprehensive and perfect archive files, with which the physical examination service and competitiveness will be greatly improved.
Beginning with the discussion on the background and necessity of system research and development, the thesis analyzes the key engineering technologies, such as software engineering, object oriented method and so on. Based on that, it gives a detailed analysis on the system requisites, and expounds the system design, including the goal and principle of the system design, module design, rename, coding principle, and work process, etc. With elaborating the ways how the system realizes its functions, which include database building, windows realization and code compiling, the thesis is supposed to achieve its design of the physical examination management system.
The system adopts software engineering method and object-oriented technology as its key know-how, use Sybase's PowerBuilder as the development kit and MS SQL Server as the database, and combines them in a friendly way. Bases on this, with a analysis of the system development tactics, the related technical route has be designed.
In system design, based on the requirement analysis, the goal and principle and module of the system design have been defined as the first step, and then designs of total module design, process design, connection and data report design, risk design, and custom windows design are also carried out in sequence.
In system realization, the design defines system operating environment in terms of software and hardware; sets up the related database; analyzes the detailed working process; lays down naming and coding principle and at last, carefully designs the customer windows and system operation.
This article, with the background analysis of the physical examination system, sets up main content and the scope of the research; applies the software engineering life cycle method; points out the key points of the service through concrete analysis on the onstage basic service of the physical examination; establishes the overall system structure, and gives concrete description of functions of each administration module. Then it has carries out the overall system planning and the detailed design (various functions module, database, data connection and so on); discusses several key issues in the system research and development process; describes the system realization process; explains the operation of the system and at last, summarizes the system research and development and proposes some expectations in further study in this area as well.
论文从系统开发的必要性和背景入手,对软件工程、面向对象等关键技术进行分析,在此基础上详细分析了系统需求,阐明了详细的系统设计,包括系统的设计目标及原则、模块设计、系统命名及编码规则、业务流程等,并着重阐述了系统的实现方法,包括数据库建设、界面实现及代码编写,最终完成了体检管理系统的设计与实现。
在关键技术上,系统采用了软件工程的方法和面向对象技术;在实现技术上,系统选择了Sybase公司的PowerBuilder作为前台开发工具,微软公司的SQL Server关系数据库作为后台数据库系统,并进行了友好配合;在此基础上,分析了系统开发策略,制定了相应的技术路线。
在系统设计中,依据需求分析,确定了系统目标、原则及模块,依次进行了总体模块设计、流程设计、接口及数据表设计、安全设计、用户界面设计。
在系统实现上,确定了系统的软硬件运行环境,创建了相关数据库,分析了详细业务流程,制定了命名、编码规则,对用户界面和系统使用进行了详细设计。
本文分析了系统的背景,确定了课题研究的主要内容和范围,运用软件工程生命周期法的思想,通过对体检前台基本业务的具体分析,指出了业务的关键点,建立了系统的总体结构,并对各管理模块进行了具体的功能描述;然后进行了系统总体规划和详细设计(各功能模块、数据库、数据接口等);具体讨论了系统研发过程中所遇到的几个关键问题;描述了系统的实现过程;对系统的运行情况进行了闸述;最后总结了系统研发工作并闸述了下一步的拓展思路。
Hospital information system is an important branch of new and developing medical information science with the goal of realization management of dynamic data, with which the hospital management, clinical medical treatment and scientific research can be conducted through information network. The physical examination management information system, as an important part of medical treatment information management system, can help to improve the efficiency in physical examination, realize the efficient and quantified management. The application of the system may provide with an accurate, comprehensive and perfect archive files, with which the physical examination service and competitiveness will be greatly improved.
Beginning with the discussion on the background and necessity of system research and development, the thesis analyzes the key engineering technologies, such as software engineering, object oriented method and so on. Based on that, it gives a detailed analysis on the system requisites, and expounds the system design, including the goal and principle of the system design, module design, rename, coding principle, and work process, etc. With elaborating the ways how the system realizes its functions, which include database building, windows realization and code compiling, the thesis is supposed to achieve its design of the physical examination management system.
The system adopts software engineering method and object-oriented technology as its key know-how, use Sybase's PowerBuilder as the development kit and MS SQL Server as the database, and combines them in a friendly way. Bases on this, with a analysis of the system development tactics, the related technical route has be designed.
In system design, based on the requirement analysis, the goal and principle and module of the system design have been defined as the first step, and then designs of total module design, process design, connection and data report design, risk design, and custom windows design are also carried out in sequence.
In system realization, the design defines system operating environment in terms of software and hardware; sets up the related database; analyzes the detailed working process; lays down naming and coding principle and at last, carefully designs the customer windows and system operation.
This article, with the background analysis of the physical examination system, sets up main content and the scope of the research; applies the software engineering life cycle method; points out the key points of the service through concrete analysis on the onstage basic service of the physical examination; establishes the overall system structure, and gives concrete description of functions of each administration module. Then it has carries out the overall system planning and the detailed design (various functions module, database, data connection and so on); discusses several key issues in the system research and development process; describes the system realization process; explains the operation of the system and at last, summarizes the system research and development and proposes some expectations in further study in this area as well.
引文
[1]丁涵章.现代医院管理全书.杭州:杭州出版社,1999.15-16
[2]董恒.医院管理学.上海:上海医科大学出版社,2000.12-14
[3]Andrew S.Tranebaum.Distributed Operating System.北京:清华大学出版社,1997.158-160
[4]陈静文.预防性健康体检网络管理系统的应用.广东卫生防疫,2000,26(1):94-96.
[5]王召平,张爱莉.日木健康体检医学的现状.上海预防医学杂志.2002,14(3):124-124.
[6]GlennH artwig.Tr endsin R apidP rototyping.D esktope ngineering,2001,4(7):55-56
[7]龚进梅.医疗设备计算机管理系统的设计与应用.医疗卫生装备,2001,6(5):72-74
[8]王建明.基于B/S体系结构的企业综合信息管理系统[J].计算机应用与软件,2001,(4):75-77.
[9]Allan Heydon,Roy Levin,Timothy Mann,et al.The Vesta Approach to Software Configuration Management.Compaq Systems Research Center Technical Note,1999,2(4):28-35
[10]Daniel C.Halbert,Patrick D.O'Brien.Object-oriented development.IEEE Software,1987,4(5):71-79
[11]周建军,李建涛.论述面向对象技术在软件设计中的应用.电讯技术,1998,6(3):56-59
[12]王博,晓龙.面向对象的建模、设计技术与方法.北京:北京希望电脑公司,1996.23-34
[13]蔡希尧,陈平.面向对象技术.西安:电子科技大学出版社,1993.34-37
[14]谷艺.数据库中的多面手:PowerBuilder 6.0.北京:人民邮电出版社,2000.112-114
[15]王蓉.PowerBuilder应用开发技术详解.北京:电子工业出版社,2002.202-210
[16]郑阿奇.SQL Server实用教程.北京:电子工业出版社,2005.192-195
[17]吴家强.数据库原理及应用.湖南:中南大学出版社,2004.261-262
[18]Capers Jones.Variations in Software Development Practices.IEEE Software,2003,20(6):22-27
[19]陈永强.SQL Server数据库企业应用系统开发.北京:清华大学出版社,2005.210-212
[20]Brooks F.P No silver bullet:Essence and accidents of software engineering.IEEE Computer,1987,10(6):10-19
[21]R.L.Glass.Software Runaways:Lessons Learned from Massive Software Project Failures.Informatin Ststem Management,2003,10(5):125-129
[22]游志勇.数据库管理系统.北京:中国水利水电出版社,2004.150-152
[23]王珊,李盛海.数据库基础与应用.北京:人民邮电出版社,2002.98-99
[24]刘增进.PowerBuilder 7.0数据窗口技术详解.北京:电子工业出版社,2005.56-58
[25]周之英.现代软件工程.北京:科学出版社,2000.75-78
[26]M Bielikova,P Navrat.An approach to automated building of software system configurations.International Journal of Software Engineering and Knowledge Engineering,1999,9(1):73-95
[27]H.Wohlwend,S.Rosenbaum.Software Improvements in an International Company.International Journal of Software Engineering and Knowledge Engineering,1999,9(3):38-41
[28]何国伟.软件可靠性.北京:国防工业出版社,1998,45-48
[29]RogerS.Pressman.SoftwareEngineering.APractitioner's pproach,1997,McGRaw-Hill.
[30]Andrew S.Tanenbaum.Computer Networws.1996,Prentice Hall,Inc.
[31]陈卫,钱立志,丁燕.信息安全性、可用性问题与对策研究.计算机工程与应用,2003,39(1):202-204
[32]Rebert A.Anthony,Vijay Govindarajan.管理控制系统.赵玉涛译.北京:机械工业出版社,2004:98-103
[33]B Westfechtel.A Graph-Based system for manageing configurations of engineering design documents.International Journal of Software Engineering and Knowledge Engineering,1996,6(4):549-583
[34]蔡持峰,毋国庆,李剑.实时控制系统需求描述方法及其应用.计算机科学.2001(3):33-34
[35]方风波.C语言程序设计.北京:地质出版社,2006.174-176
[36]Norman Ronald J.Object Oriented System Analysis and Design.New Jersey:Prentice Hall,1996.329-335
[37]邝明华.软件企业质量管理创新和发展研究.计算机系统应用,2003,5:73-75
[38]叶乃文,喻国宝.面向对象程序设计.北京:清华大学出版社,2004.120-15
[39]王意洁.面向对象的数据库技术.北京:电子工业出版社,2003.55-57
[40](美)沃大斯-布洛克.面向对象软件设计经典.北京:电子工业出版社,2003.70-71
[41]Zahniser,R.Timeboxing for Top Team Performance.Software Development,1994,20(3):35-38
[42]R Conradi,B Westfechtel.Version Models for Software Configuration Management.ACM Computing Surveys,1998,30(2):232-282
[43]陆廷孝,郑鹏洲.可靠性设计与分析.北京:国防工业出版社,1995.12-18
[44]Jerome Kanter and John J.Walsh.Toward More Sucessful Project Management.Informatin Ststem Management,2004,20(4):16-21
[45]萨师煊,王珊.数据库系统概论.北京:高等教育出版社,2000.25-28
[2]董恒.医院管理学.上海:上海医科大学出版社,2000.12-14
[3]Andrew S.Tranebaum.Distributed Operating System.北京:清华大学出版社,1997.158-160
[4]陈静文.预防性健康体检网络管理系统的应用.广东卫生防疫,2000,26(1):94-96.
[5]王召平,张爱莉.日木健康体检医学的现状.上海预防医学杂志.2002,14(3):124-124.
[6]GlennH artwig.Tr endsin R apidP rototyping.D esktope ngineering,2001,4(7):55-56
[7]龚进梅.医疗设备计算机管理系统的设计与应用.医疗卫生装备,2001,6(5):72-74
[8]王建明.基于B/S体系结构的企业综合信息管理系统[J].计算机应用与软件,2001,(4):75-77.
[9]Allan Heydon,Roy Levin,Timothy Mann,et al.The Vesta Approach to Software Configuration Management.Compaq Systems Research Center Technical Note,1999,2(4):28-35
[10]Daniel C.Halbert,Patrick D.O'Brien.Object-oriented development.IEEE Software,1987,4(5):71-79
[11]周建军,李建涛.论述面向对象技术在软件设计中的应用.电讯技术,1998,6(3):56-59
[12]王博,晓龙.面向对象的建模、设计技术与方法.北京:北京希望电脑公司,1996.23-34
[13]蔡希尧,陈平.面向对象技术.西安:电子科技大学出版社,1993.34-37
[14]谷艺.数据库中的多面手:PowerBuilder 6.0.北京:人民邮电出版社,2000.112-114
[15]王蓉.PowerBuilder应用开发技术详解.北京:电子工业出版社,2002.202-210
[16]郑阿奇.SQL Server实用教程.北京:电子工业出版社,2005.192-195
[17]吴家强.数据库原理及应用.湖南:中南大学出版社,2004.261-262
[18]Capers Jones.Variations in Software Development Practices.IEEE Software,2003,20(6):22-27
[19]陈永强.SQL Server数据库企业应用系统开发.北京:清华大学出版社,2005.210-212
[20]Brooks F.P No silver bullet:Essence and accidents of software engineering.IEEE Computer,1987,10(6):10-19
[21]R.L.Glass.Software Runaways:Lessons Learned from Massive Software Project Failures.Informatin Ststem Management,2003,10(5):125-129
[22]游志勇.数据库管理系统.北京:中国水利水电出版社,2004.150-152
[23]王珊,李盛海.数据库基础与应用.北京:人民邮电出版社,2002.98-99
[24]刘增进.PowerBuilder 7.0数据窗口技术详解.北京:电子工业出版社,2005.56-58
[25]周之英.现代软件工程.北京:科学出版社,2000.75-78
[26]M Bielikova,P Navrat.An approach to automated building of software system configurations.International Journal of Software Engineering and Knowledge Engineering,1999,9(1):73-95
[27]H.Wohlwend,S.Rosenbaum.Software Improvements in an International Company.International Journal of Software Engineering and Knowledge Engineering,1999,9(3):38-41
[28]何国伟.软件可靠性.北京:国防工业出版社,1998,45-48
[29]RogerS.Pressman.SoftwareEngineering.APractitioner's pproach,1997,McGRaw-Hill.
[30]Andrew S.Tanenbaum.Computer Networws.1996,Prentice Hall,Inc.
[31]陈卫,钱立志,丁燕.信息安全性、可用性问题与对策研究.计算机工程与应用,2003,39(1):202-204
[32]Rebert A.Anthony,Vijay Govindarajan.管理控制系统.赵玉涛译.北京:机械工业出版社,2004:98-103
[33]B Westfechtel.A Graph-Based system for manageing configurations of engineering design documents.International Journal of Software Engineering and Knowledge Engineering,1996,6(4):549-583
[34]蔡持峰,毋国庆,李剑.实时控制系统需求描述方法及其应用.计算机科学.2001(3):33-34
[35]方风波.C语言程序设计.北京:地质出版社,2006.174-176
[36]Norman Ronald J.Object Oriented System Analysis and Design.New Jersey:Prentice Hall,1996.329-335
[37]邝明华.软件企业质量管理创新和发展研究.计算机系统应用,2003,5:73-75
[38]叶乃文,喻国宝.面向对象程序设计.北京:清华大学出版社,2004.120-15
[39]王意洁.面向对象的数据库技术.北京:电子工业出版社,2003.55-57
[40](美)沃大斯-布洛克.面向对象软件设计经典.北京:电子工业出版社,2003.70-71
[41]Zahniser,R.Timeboxing for Top Team Performance.Software Development,1994,20(3):35-38
[42]R Conradi,B Westfechtel.Version Models for Software Configuration Management.ACM Computing Surveys,1998,30(2):232-282
[43]陆廷孝,郑鹏洲.可靠性设计与分析.北京:国防工业出版社,1995.12-18
[44]Jerome Kanter and John J.Walsh.Toward More Sucessful Project Management.Informatin Ststem Management,2004,20(4):16-21
[45]萨师煊,王珊.数据库系统概论.北京:高等教育出版社,2000.25-28