基于XML和.NET技术的远程医疗信息系统的设计与实现
|
摘要
随着计算机网络和Internet的迅猛发展,运用先进的信息管理系统及软件开发平台,对信息进行科学化和网络化管理,已经成为医疗信息系统的发展趋势。在基于传统技术开发的信息系统中,大多数的系统还是停留在利用ASP或者ASP.NET生成动态网页以及与后台数据库进行简单的交互。这样是远远满足不了不断升级的用户需求的,因此,对高性能的远程医疗系统的研究应运而生,设计开发一个既高效又人性化的医疗信息系统具有重大的现实意义。
本文立足于Microsoft公司的.NET开发平台,在对远程医疗信息系统建设需求进行分析的基础上,比较了目前较为流行的几种实现技术,论述了一个基于.NET与XML技术的远程医疗信息系统的实现。本文主要分析了.NET框架的构成和优势,阐述了ASP.NET技术,研究了以XML文档为载体的用户数据的存贮与转换问题。并对新一代数据访问模型ADO.NET进行了详细探讨。对相关技术细节进行深入的研究与探索,并制定出系统的设计方案。本系统以数据库SQL Server为依托,使用全新的面向对象语言C#,结合ASP.NET,运用Web服务器控件设计完成。本系统采用三层结构模型和模块化设计方法,采用存储过程实现对底层数据的操作,采用.NET技术实现了程序和代码的分离,使得程序代码更安全,执行效率也更高,同时通过程序安全设置、权限分配等增加系统的安全性。具体工作主要包含以下几方面:
1.对系统开发需要使用到的工具和涉及到的技术进行了阐述。并结合相关技术对系统进行软件定义和需求分析。
2.根据需求分析完成了系统各个模块的功能设计,然后对系统进行了详细的设计,并最终开发完成了“基于XML和.NET技术的远程医疗信息系统”。
3.以数据存贮与转换为中心对基于XML的用户健康档案问题进行了研究探讨,重点关注了基于XML的用户健康档案数据在关系数据库中的存贮策略,并研究了具体的数据存贮模型和转换方法。
Using new management information system and software development platform to manage information has become a development trend of the Medical information system, with the rapid development of computer network. The majority of system is still in using of ASP or ASP.NET to produces the dynamic Web page and making a simple connection with the backstage database, in information system that using traditional technology to develop. However like this, traditional system far failed to meet the needs of users. Therefore, the research of high performance long-distance medical system emerges as the times require.
After finishing the requirement analysis of long-distance medical information system and Comparing with several kind of realizations technology that are more popular in present, this paper describes the implementation procedure of a long-distance medical information system that based on .NET and XML technology. The paper introduces predominance and composing of .NET framework, explains ASP.NET technology, disscusses the storage and transformation of XML documents data, and describes a new generation of data access model that named ADO.NET in detail. The paper also studies the detail of interrelated technical in-depth, and establish design proposal of system. The system relies on SQL Server database, uses C# that is a new object-oriented language and ASP.NET technology, makes use of web controls. The system uses a three-tier structure model and modular design method, uses the process of storing data to achieve the first floor data. By using .NET technology, we can divide the program and code to two different parts, thus, the program and codes is safer, executive efficiency is higher, on the other hand, through setting up security procedures and distributing jurisdiction to increase security. Specific work mainly includes the following aspects:
1. The tool that needs to use in system development and the technology that comes down to system are expatiated. Software definition and the requirement analysis of the system are finished.
2. According to the requirement analysisthe, paper has completed the functional design of each module on the inside system. Then according to the detailed design of system, Paper finally has developed completedly "long-distance medical service information system that based on XML and .NET technology".
3. Taking the data Stores and transforms as the center, the discussion about the user healthy file is finished. Paper pays attention with emphasis in date transformation strategy between XML documents and relational database, and studies the concrete data storage model and transformation algorithm.
本文立足于Microsoft公司的.NET开发平台,在对远程医疗信息系统建设需求进行分析的基础上,比较了目前较为流行的几种实现技术,论述了一个基于.NET与XML技术的远程医疗信息系统的实现。本文主要分析了.NET框架的构成和优势,阐述了ASP.NET技术,研究了以XML文档为载体的用户数据的存贮与转换问题。并对新一代数据访问模型ADO.NET进行了详细探讨。对相关技术细节进行深入的研究与探索,并制定出系统的设计方案。本系统以数据库SQL Server为依托,使用全新的面向对象语言C#,结合ASP.NET,运用Web服务器控件设计完成。本系统采用三层结构模型和模块化设计方法,采用存储过程实现对底层数据的操作,采用.NET技术实现了程序和代码的分离,使得程序代码更安全,执行效率也更高,同时通过程序安全设置、权限分配等增加系统的安全性。具体工作主要包含以下几方面:
1.对系统开发需要使用到的工具和涉及到的技术进行了阐述。并结合相关技术对系统进行软件定义和需求分析。
2.根据需求分析完成了系统各个模块的功能设计,然后对系统进行了详细的设计,并最终开发完成了“基于XML和.NET技术的远程医疗信息系统”。
3.以数据存贮与转换为中心对基于XML的用户健康档案问题进行了研究探讨,重点关注了基于XML的用户健康档案数据在关系数据库中的存贮策略,并研究了具体的数据存贮模型和转换方法。
Using new management information system and software development platform to manage information has become a development trend of the Medical information system, with the rapid development of computer network. The majority of system is still in using of ASP or ASP.NET to produces the dynamic Web page and making a simple connection with the backstage database, in information system that using traditional technology to develop. However like this, traditional system far failed to meet the needs of users. Therefore, the research of high performance long-distance medical system emerges as the times require.
After finishing the requirement analysis of long-distance medical information system and Comparing with several kind of realizations technology that are more popular in present, this paper describes the implementation procedure of a long-distance medical information system that based on .NET and XML technology. The paper introduces predominance and composing of .NET framework, explains ASP.NET technology, disscusses the storage and transformation of XML documents data, and describes a new generation of data access model that named ADO.NET in detail. The paper also studies the detail of interrelated technical in-depth, and establish design proposal of system. The system relies on SQL Server database, uses C# that is a new object-oriented language and ASP.NET technology, makes use of web controls. The system uses a three-tier structure model and modular design method, uses the process of storing data to achieve the first floor data. By using .NET technology, we can divide the program and code to two different parts, thus, the program and codes is safer, executive efficiency is higher, on the other hand, through setting up security procedures and distributing jurisdiction to increase security. Specific work mainly includes the following aspects:
1. The tool that needs to use in system development and the technology that comes down to system are expatiated. Software definition and the requirement analysis of the system are finished.
2. According to the requirement analysisthe, paper has completed the functional design of each module on the inside system. Then according to the detailed design of system, Paper finally has developed completedly "long-distance medical service information system that based on XML and .NET technology".
3. Taking the data Stores and transforms as the center, the discussion about the user healthy file is finished. Paper pays attention with emphasis in date transformation strategy between XML documents and relational database, and studies the concrete data storage model and transformation algorithm.
引文
[1]诸强,王学民.无线远程医疗系统.北京生物医学工程,2004.23(3):127-128
[2]白净,张永红等.远程医疗概论.北京:清华大学出版社,2000.1-11
[3]罗峻.医院信息系统之综述篇.中国计算机报,2002.(2):17-23
[4]Rebecca Wurtz,MD,MPH.An analysis of healthcare professional'resistance to clinical information systems and strategies for change.The Journal of clinical information,2001.52(1):80-85
[5]侯微.医院信息系统及电子病历研发和应用中需要注意的问题.广州医药,2004.16(3):68-70
[6]薛万国.医疗系统涉及的技术论述.西南国防医药,2005.15(5):545-547
[7]Anthony CS.Compter application in critical care medicine.Critic Care Med.The Journal of clinical information,2001.52(1):99-102
[8]Alex Homer,Dave Sussman等.Asp.net 2.0高级编程(李敏波译).北京:清华大学出版社,2005
[9]吴晨,孙少波,叶莞.ASR.NET数据库项目案例导航.北京:清华大学出版社,2004
[10]Lloyd,David.Integrating reporting services into ASP.NET.Dr Dobb's Journal,2005.
[11]Mike Gunderloy.ADO与ADO.NET编程指南(邱伸潘等译).北京:电子工业出版社,2002
[12]Kouresh Ardestain,Kevin Hoffman.高效掌握ADO.NET C#编程篇(张哲峰译).北京:清华大学,2006
[13]Paul Nielson等.SQL Server 2000宝典.(刘瑞,陈微,刘文等译).北京:中国铁道出版社,2004
[14]王超,张鹏等.ASP.NET/XML深入编程技术.北京:希望出版社,2005
[15]Dan Suciu.On Database theory and XML.In Proceeding of the ACM PODS International Conference,2001.302-308
[16]彭军.基于ASP.NET的企业信息平台设计与实现.泰州职业技术学院学报,2006.12(8):35-38
[17]张学军.XML及其技术应用.现代情报,2005.(8):75-76
[18]刘振岩,刘慧敏,王欢.ASP.NET数据库开发入门与提高.北京:清华大学,2004
[19]傅学胜等.用.NET和XML构建Web应用程序.北京:清华大学出版社,2003
[20]贺金凌.微软XML技术指南.北京:中国电力出版社.2003
[21]东名,吴名月等.ASP.NET动态网页设计高手.北京:清华大学出版社,2005
[22]Graeme Malcolm.SQL Server 2000与XML数据库编程(孙瑛霖,梁超译).北京:清华大学出版社,2003
[23]Burton Harvey,Simon Robinson,Julian Templeman等.C#程序设计教程.北京:清华大学出版社,2001
[24]刘晓华.精通.NET核心技术--原理和架构.北京:电子工业出版社,2005
[25]J.H.Van bemmel,M,A,Musen等.医学信息学(包含飞,郑学侃译).上海:上海科技出版社,2005
[26]何雨生.美国医院信息化情况调查与分析.医疗设备信息,2005.20(5):18-19
[27]贺金凌.基于.NET平台的Web解决方案的安全机制.计算机应用与软件,2002.(11):19-21[28]Peter Aitken.Building Web Solutions with ASRNET and ADO.NET.Microsoft Press.2002
[29]潘哲信,终俐鹃.基于Web服务的分布式异构数据库集成研究.计算机应用研究,2006.(3):208-210
[30]柴晓路,梁宇奇著.Web Services技术、架构和应用.北京:电子工业出版社,2003
[31]Jason Beres.21天学通Visual Studio.NET 2003(袁鹏飞等译).北京:人民邮电出版社.2003
[32]Muralidhar Krishnaprasad,Liu,Z.H,Anand Manikutty,Vikas Arora.Towards an industrial strength SQL/XML infrastructure.21st International Conference,ICDE Proceedings,2005.991-1000
[33]Li Zhang,Chongquan Zhong,Chao Sun.Development of Intelligent Design System for Small Transformer Based on B/S Mode.Intelligent Control and Automation,The Sixth WCICA World Congress,2006.(2):7523-7526
[34]Ahuja,S.P,Clark,R.Comparison of Web services technologies from a developer's perspective.Coding and Computing,ITCC 2005 International Conference,2005.(14):791-792
[35]Guo-Shun Lin,Dong Xiang,Qing Chang.Development strategy of MIS for small and medium-sized enterprise.Management of Innovation and Technology,IEEE International Conference,2000.545-548
[36]郑仕辉,周傲英,季文赞.基于SQL的XML查询的有效实现.计算机研究与发展,2001.38(4):422-428
[37]孙永强,陆波,杨丽昆.Framework程序设计.北京:清华大学出版社,2005
[38]Joshi,J.Security Models for Web-Based Applications.Communications of the ACM 2001.44(2):38-44
[39]张春晓.构建基于ASP的安全的Web站点.现代情报技术,2004.(12):85-87
[40]Meicr,J.D.Improving Web Application Security Threats and Countermeasures.Microsoft Corporation,2003.21-23
[41]王书海,李金英,王建民.基于SQL Server应用系统的安全策略.石家庄铁道学院学报,2001.(1):65-68
[42]Fruhling,A,Tyser,K,de Vrccde,G.Experiences with Extreme Programming in Tclehealth:Developing and Implementing a Biosccurity Health Care Application.System Sciences,2005.HICSS '05.Proceedings of the 38th Annual Hawaii International Conference,2005.(2):151-152
[43]Rashvand,H.F,Hines,E.L,llliescu,D.Integrated Telchealth-Requirement and Implementation.Vehicular Technology Conference,Advances in Medical,Signal and Information Processing,2006.MEDSIP 2006.IET 3rd International Conference,(3):1-4
[44]Hughes,G.Hudgins,B.MacDougall,J.Using telehealth technology to improve the delivery of health services to people who arc deaf.Engineering in Medicine and Biology Society,2004.lEMBS '04.26th Annual International Conference of the IEEE,2004.(4):3084-3087
[45]吕旭东.医疗信息系统关键问题研究.浙江大学博士后研究工作报告,2004
[46]李包罗,马琏,梁铭会.中国医院信息基本数据集标准.中国医院,2005.(7):25-27.
[47]Pardede,E,Rahayu,J,Taniar,D.XML-Enabled Relational Database for XML Document Update.Advanced Information Networking and Applications,20th International Conference,2006,.(2):205-212
[48]许斗,陈恩红.xML的半结构化数据表示方法及其在医学文档处理中的应用.计算机工程,2003.28(1):78-80
[49]Qiu Peng,Chen Jian-hui,Chang Qing.Study of XML & SQL Server and Application in Distributed Integration.Electronic Measurement and Instruments,ICEMI '07.8th International Conference,2007.(4):369-372
[50]Gantenbein,R.E.,Cadez,F.Establishing a rural teleheaith project:the Wyoming network for telehealth.Engineering in Medicine and Biology Society,2004.lEMBS '04.26th Annual International Conference of the IEEE,2004.(2):3089-3092
[51]Boucher,S,Steinmetz,R.Embedding XML schema constraints in search-based intersection tests for XPath query optimization.Database and Expert Systems Applications,Sixteenth International Workshop,2005,(4):842-846
[52]Kotsakis,E,Bohm,K.XML Schema Directory:a data structure for XML data processing.Web Information Systems Engineering International Conference.2000.(2):62-69
[53]Berler,A.Konnis,G.Use of XML technology in a virtual patient record infrastructure.Information Technology Applications in Biomedicine 2003.4th International IEEE EMBS Special Topic Conference,2003.(2):118-121
[54]Krishnamurthy,R.Chakaravarthy,V.Recursive XML schemas,recursive XML queries,and relational storage:XML-to-SQL query translation.Data Engineering 20th International Conference,2002.(37):42-53
[55]Wei Sun,Wansong Zhang.An efficient method for XML queries optimization based DTD abstraction and classification.Intelligent Control and Automation Fifth Word Congress,2004.(5):3926-3929
[56]Weidong Yang.,Qingming Wang.The Optimization of Complex XML Queries over XML Streams under DTD.Information Management Workshops Seventh International Conference,2006.(40):10-11
[57]阎慧,李希民,李彩萍.基于XML的Web安全模型,.装备指挥技术学院学报,2002.(4)
[58]徐周,黄上腾.基于XML实现数据库间信息交换的方法.计算机工程,2006.27(11):65-66
[2]白净,张永红等.远程医疗概论.北京:清华大学出版社,2000.1-11
[3]罗峻.医院信息系统之综述篇.中国计算机报,2002.(2):17-23
[4]Rebecca Wurtz,MD,MPH.An analysis of healthcare professional'resistance to clinical information systems and strategies for change.The Journal of clinical information,2001.52(1):80-85
[5]侯微.医院信息系统及电子病历研发和应用中需要注意的问题.广州医药,2004.16(3):68-70
[6]薛万国.医疗系统涉及的技术论述.西南国防医药,2005.15(5):545-547
[7]Anthony CS.Compter application in critical care medicine.Critic Care Med.The Journal of clinical information,2001.52(1):99-102
[8]Alex Homer,Dave Sussman等.Asp.net 2.0高级编程(李敏波译).北京:清华大学出版社,2005
[9]吴晨,孙少波,叶莞.ASR.NET数据库项目案例导航.北京:清华大学出版社,2004
[10]Lloyd,David.Integrating reporting services into ASP.NET.Dr Dobb's Journal,2005.
[11]Mike Gunderloy.ADO与ADO.NET编程指南(邱伸潘等译).北京:电子工业出版社,2002
[12]Kouresh Ardestain,Kevin Hoffman.高效掌握ADO.NET C#编程篇(张哲峰译).北京:清华大学,2006
[13]Paul Nielson等.SQL Server 2000宝典.(刘瑞,陈微,刘文等译).北京:中国铁道出版社,2004
[14]王超,张鹏等.ASP.NET/XML深入编程技术.北京:希望出版社,2005
[15]Dan Suciu.On Database theory and XML.In Proceeding of the ACM PODS International Conference,2001.302-308
[16]彭军.基于ASP.NET的企业信息平台设计与实现.泰州职业技术学院学报,2006.12(8):35-38
[17]张学军.XML及其技术应用.现代情报,2005.(8):75-76
[18]刘振岩,刘慧敏,王欢.ASP.NET数据库开发入门与提高.北京:清华大学,2004
[19]傅学胜等.用.NET和XML构建Web应用程序.北京:清华大学出版社,2003
[20]贺金凌.微软XML技术指南.北京:中国电力出版社.2003
[21]东名,吴名月等.ASP.NET动态网页设计高手.北京:清华大学出版社,2005
[22]Graeme Malcolm.SQL Server 2000与XML数据库编程(孙瑛霖,梁超译).北京:清华大学出版社,2003
[23]Burton Harvey,Simon Robinson,Julian Templeman等.C#程序设计教程.北京:清华大学出版社,2001
[24]刘晓华.精通.NET核心技术--原理和架构.北京:电子工业出版社,2005
[25]J.H.Van bemmel,M,A,Musen等.医学信息学(包含飞,郑学侃译).上海:上海科技出版社,2005
[26]何雨生.美国医院信息化情况调查与分析.医疗设备信息,2005.20(5):18-19
[27]贺金凌.基于.NET平台的Web解决方案的安全机制.计算机应用与软件,2002.(11):19-21[28]Peter Aitken.Building Web Solutions with ASRNET and ADO.NET.Microsoft Press.2002
[29]潘哲信,终俐鹃.基于Web服务的分布式异构数据库集成研究.计算机应用研究,2006.(3):208-210
[30]柴晓路,梁宇奇著.Web Services技术、架构和应用.北京:电子工业出版社,2003
[31]Jason Beres.21天学通Visual Studio.NET 2003(袁鹏飞等译).北京:人民邮电出版社.2003
[32]Muralidhar Krishnaprasad,Liu,Z.H,Anand Manikutty,Vikas Arora.Towards an industrial strength SQL/XML infrastructure.21st International Conference,ICDE Proceedings,2005.991-1000
[33]Li Zhang,Chongquan Zhong,Chao Sun.Development of Intelligent Design System for Small Transformer Based on B/S Mode.Intelligent Control and Automation,The Sixth WCICA World Congress,2006.(2):7523-7526
[34]Ahuja,S.P,Clark,R.Comparison of Web services technologies from a developer's perspective.Coding and Computing,ITCC 2005 International Conference,2005.(14):791-792
[35]Guo-Shun Lin,Dong Xiang,Qing Chang.Development strategy of MIS for small and medium-sized enterprise.Management of Innovation and Technology,IEEE International Conference,2000.545-548
[36]郑仕辉,周傲英,季文赞.基于SQL的XML查询的有效实现.计算机研究与发展,2001.38(4):422-428
[37]孙永强,陆波,杨丽昆.Framework程序设计.北京:清华大学出版社,2005
[38]Joshi,J.Security Models for Web-Based Applications.Communications of the ACM 2001.44(2):38-44
[39]张春晓.构建基于ASP的安全的Web站点.现代情报技术,2004.(12):85-87
[40]Meicr,J.D.Improving Web Application Security Threats and Countermeasures.Microsoft Corporation,2003.21-23
[41]王书海,李金英,王建民.基于SQL Server应用系统的安全策略.石家庄铁道学院学报,2001.(1):65-68
[42]Fruhling,A,Tyser,K,de Vrccde,G.Experiences with Extreme Programming in Tclehealth:Developing and Implementing a Biosccurity Health Care Application.System Sciences,2005.HICSS '05.Proceedings of the 38th Annual Hawaii International Conference,2005.(2):151-152
[43]Rashvand,H.F,Hines,E.L,llliescu,D.Integrated Telchealth-Requirement and Implementation.Vehicular Technology Conference,Advances in Medical,Signal and Information Processing,2006.MEDSIP 2006.IET 3rd International Conference,(3):1-4
[44]Hughes,G.Hudgins,B.MacDougall,J.Using telehealth technology to improve the delivery of health services to people who arc deaf.Engineering in Medicine and Biology Society,2004.lEMBS '04.26th Annual International Conference of the IEEE,2004.(4):3084-3087
[45]吕旭东.医疗信息系统关键问题研究.浙江大学博士后研究工作报告,2004
[46]李包罗,马琏,梁铭会.中国医院信息基本数据集标准.中国医院,2005.(7):25-27.
[47]Pardede,E,Rahayu,J,Taniar,D.XML-Enabled Relational Database for XML Document Update.Advanced Information Networking and Applications,20th International Conference,2006,.(2):205-212
[48]许斗,陈恩红.xML的半结构化数据表示方法及其在医学文档处理中的应用.计算机工程,2003.28(1):78-80
[49]Qiu Peng,Chen Jian-hui,Chang Qing.Study of XML & SQL Server and Application in Distributed Integration.Electronic Measurement and Instruments,ICEMI '07.8th International Conference,2007.(4):369-372
[50]Gantenbein,R.E.,Cadez,F.Establishing a rural teleheaith project:the Wyoming network for telehealth.Engineering in Medicine and Biology Society,2004.lEMBS '04.26th Annual International Conference of the IEEE,2004.(2):3089-3092
[51]Boucher,S,Steinmetz,R.Embedding XML schema constraints in search-based intersection tests for XPath query optimization.Database and Expert Systems Applications,Sixteenth International Workshop,2005,(4):842-846
[52]Kotsakis,E,Bohm,K.XML Schema Directory:a data structure for XML data processing.Web Information Systems Engineering International Conference.2000.(2):62-69
[53]Berler,A.Konnis,G.Use of XML technology in a virtual patient record infrastructure.Information Technology Applications in Biomedicine 2003.4th International IEEE EMBS Special Topic Conference,2003.(2):118-121
[54]Krishnamurthy,R.Chakaravarthy,V.Recursive XML schemas,recursive XML queries,and relational storage:XML-to-SQL query translation.Data Engineering 20th International Conference,2002.(37):42-53
[55]Wei Sun,Wansong Zhang.An efficient method for XML queries optimization based DTD abstraction and classification.Intelligent Control and Automation Fifth Word Congress,2004.(5):3926-3929
[56]Weidong Yang.,Qingming Wang.The Optimization of Complex XML Queries over XML Streams under DTD.Information Management Workshops Seventh International Conference,2006.(40):10-11
[57]阎慧,李希民,李彩萍.基于XML的Web安全模型,.装备指挥技术学院学报,2002.(4)
[58]徐周,黄上腾.基于XML实现数据库间信息交换的方法.计算机工程,2006.27(11):65-66