基于Web的医学文献数据库的设计与实现
|
摘要
医学是一门实验性的科学,积累了大量的文献和数据,这些文献和数据对医学及同医学有关的研究领域有巨大的参考价值。由于计算机网络技术的飞速发展,越来越多的医学工作者利用计算机技术构造和处理医学信息,各种医学信息的处理与查询变得越来越便利。医学文献数据库已经成为医学工作者进行科学研究的重要工具。
本论文的主要目标是探索医学文献和文献中的事实数据的联合服务方法。通过使用本论文完成的基于Web的医学文献数据库,用户可以方便的使用Web浏览器通过Internet访问医学文献数据库。该数据库是一个医学信息比较完备的数据管理与信息服务系统,通过对不同的医学信息的相互标引、连接,实现了医学文献与其他医学信息之间的交互检索,增强了医学文献数据库的数据参考价值,满足了医学工作者多方面的信息需求,方便了用户的使用。
作者对医学文献和文献中的事实数据以及彼此间的关系进行了分析研究,建立了相应的关系模型,完成了相应的程序开发工作。论文的主要工作包括分析了国内外医学文献检索系统的发展状况,说明了进行医学文献数据库开发的必要性与重要意义;根据用户需求确定了医学文献数据库存储的信息;为系统选择了结构模式和开发工具;从数据库概念结构、数据库逻辑结构、数据库物理结构三个方面对医学文献数据库进行设计;对系统各模块功能进行了设计;对系统关键部分的实现进行了描述,并给出了部分核心代码。
Nowadays the information on the Internet is rapidly increasing and being updated in real time. How to acquire the needed information quickly and accurately is a main topic of the Web information retrieval technology.
Medicine is a science of experiment, accumulation of medical literatures and data which have great value of application and reference to the medicine study. With the rapid development of computer-based Internet technology, more and more scientists construct and process medical information through computers, and the procession and retrieval of the medical information have become more and more convenient. Medical literature database have also become important tools for medical workers.
Medical literature database can provide users with medical information service in the society and the industry. Users can visit the literature database through Web browser, and the system can eliminate differences of data access in different locations and can provide high quality medical information service to its users.
Medical literature database can make users obtain relevant medical information from different medical database in one search portal. The system can not only enhance the value of data reference but also help users get medical information more conveniently and more sufficiently.
Medical literature database is an integrated system which can not only manage medical data but also provide users with medical information service. The system provides different medical information search portal for its user; user can get medical information in different angle from the system. So the medical databases which are related with each other by the medical literature database became a system of medical knowledge system.
The balance of medical information production and processing was reached by the highly applied and processed to the huge medical information, the system solve the big contradiction between ever-increasing medical information and limit time in studying. And the system pushes the development of using medical information back to the future.
My major work in this subject is as follows: I had analyzed the behaviors of the medical users, and stated the necessity and great significance of medical literature database development; I analyzed what functions the medical literature database should have, that based on users’what functions and quality needs; I had designed the medical literature database system structure in three aspects: concept structure design, logic structure design, physics structure design; by analyzed users’needs, I found what information medical literature database system should include; selected system structure model and development tools for medical literature database system; designed function model of system; show some process codes.
本论文的主要目标是探索医学文献和文献中的事实数据的联合服务方法。通过使用本论文完成的基于Web的医学文献数据库,用户可以方便的使用Web浏览器通过Internet访问医学文献数据库。该数据库是一个医学信息比较完备的数据管理与信息服务系统,通过对不同的医学信息的相互标引、连接,实现了医学文献与其他医学信息之间的交互检索,增强了医学文献数据库的数据参考价值,满足了医学工作者多方面的信息需求,方便了用户的使用。
作者对医学文献和文献中的事实数据以及彼此间的关系进行了分析研究,建立了相应的关系模型,完成了相应的程序开发工作。论文的主要工作包括分析了国内外医学文献检索系统的发展状况,说明了进行医学文献数据库开发的必要性与重要意义;根据用户需求确定了医学文献数据库存储的信息;为系统选择了结构模式和开发工具;从数据库概念结构、数据库逻辑结构、数据库物理结构三个方面对医学文献数据库进行设计;对系统各模块功能进行了设计;对系统关键部分的实现进行了描述,并给出了部分核心代码。
Nowadays the information on the Internet is rapidly increasing and being updated in real time. How to acquire the needed information quickly and accurately is a main topic of the Web information retrieval technology.
Medicine is a science of experiment, accumulation of medical literatures and data which have great value of application and reference to the medicine study. With the rapid development of computer-based Internet technology, more and more scientists construct and process medical information through computers, and the procession and retrieval of the medical information have become more and more convenient. Medical literature database have also become important tools for medical workers.
Medical literature database can provide users with medical information service in the society and the industry. Users can visit the literature database through Web browser, and the system can eliminate differences of data access in different locations and can provide high quality medical information service to its users.
Medical literature database can make users obtain relevant medical information from different medical database in one search portal. The system can not only enhance the value of data reference but also help users get medical information more conveniently and more sufficiently.
Medical literature database is an integrated system which can not only manage medical data but also provide users with medical information service. The system provides different medical information search portal for its user; user can get medical information in different angle from the system. So the medical databases which are related with each other by the medical literature database became a system of medical knowledge system.
The balance of medical information production and processing was reached by the highly applied and processed to the huge medical information, the system solve the big contradiction between ever-increasing medical information and limit time in studying. And the system pushes the development of using medical information back to the future.
My major work in this subject is as follows: I had analyzed the behaviors of the medical users, and stated the necessity and great significance of medical literature database development; I analyzed what functions the medical literature database should have, that based on users’what functions and quality needs; I had designed the medical literature database system structure in three aspects: concept structure design, logic structure design, physics structure design; by analyzed users’needs, I found what information medical literature database system should include; selected system structure model and development tools for medical literature database system; designed function model of system; show some process codes.
引文
[1]任慧玲,胡铁军,李丹亚.谈医学网络数据库极其检索系统的发展趋势[J].探索与交流, 2005, 4: 43-45.
[2]林亚君.中国生物医学文献数据库与中国学术期刊全文数据库的比较[J].中华医学图书情报杂志, 2001.
[3] G. Sudhakar, A. Karmouch, N. D. Georganas. Design and Performance Evaluation Considerations of a Multimedia Medical Database [J]. IEEE Transactions on Knowledge and Data Engineering, 1993: 888~894.
[4] Michael Weiner, Timothy E. Stump, Christopher M.Callahan, John N.Lewis, Clement J.McDonald. A practical method of linking data from Medicare claims and a comprehensive electronic medical records system [J]. International Journal of Medical Informatics, 2003: 57~69.
[5]刘薇薇,张蕾,赵云艳.生物医学二次文献数据库现状及发展趋势[J].中华医学图书情报杂志, 2010: 19-23.
[6] Rudolf Seising. From vagueness in medical thought to the foundations of fuzzy reasoning in medical diagnosis [J]. Artificial Intelligence in Medicine, 2006: 237~256.
[7]陈伟洪.医学信息检索及常用网站[J].中外医疗, 2008, 10: 74-76.
[8]杨宏波.基于Web的中国化学文献检索系统设计与实现[M].华东师范大学硕士学位论文, 2007.
[9]宋阳,严平,曹彤.基于ASP、SQL Server 2000实现的Web文献检索系统及其查询优化[J].计算机应用与软件, 2006, 23(10): 25-29.
[10]沈秀丽,朱美英,邢宝山. ProQuest-Health & Medical Complete网络数据库检索方法[J].吉林大学学报, 2007, 33(2): 402-405.
[11]孟小峰,周龙骧,王珊.数据库技术发展趋势[J].软件学报, 2004, 15(12): 1822-1842.
[12]朱胜坚.当前医学数据库发展的若干热点[J].医学信息学杂志, 2008, 7: 29-33.
[13]汪晓航.数据库技术的发展[J].企业导报, 2011, 1: 289-290.
[14]孙思琴,韩丰谈.四个国内外医学数据库检索功能的比较研究[J].现代情报, 2003: 58-62.
[15]杜云祥,雷春炳,陈建青.国内5大中文生物医学期刊数据库文献收录比较研究[J].预防医学情报杂志, 2006: 162-166.
[16]吴晓萍.国内外医学数据库检索功能的比较研究[N].泰山医学院学报, 2006: 145-147.
[17]汤韧,刘辉. Internet中的国外药学文献检索系统资源[J].中国药学杂志, 2004, 39(5): 392-395.
[18]李卫,李英姿.国内实用网络文献检索系统[J].计算机应用, 2004, 13(9): 32-34.
[19]邸铭,张志慧.医学数据库Medline, PubMed, CBM的比较[J].农业图书情报学刊, 2009, 21(2): 61-64.
[20]宋一伦,杨学智,吕晓燕. PubMed-MEDLINE数据库英文中医药信息检索方法的探讨[J].中国中西医结合杂志, 2006, 26(7): 651-655.
[21]吴晓萍.国内外医学数据库检索功能的比较研究[J].泰山医学院学报, 2006, 27(2): 145-148.
[22]李炎,路莹.基于Lucene的医学文献检索系统[J].中华医学图书情报杂志, 2010, 9: 52-54.
[23]王红,赵亚朴,王沛.利用医学数据库检索临床病例用于教学的体会[J].医学理论与实践, 2008, 21(4): 494-496.
[24] Hairong Yu, Mari Davis, Concepcion S. Wilson, Fletcher T. H. Cole. Object-relational data modelling for informetric databases [J]. Journal of Informetrics, 2008: 240~251.
[25] Clement J. McDonald, Gunther Schadow, Michael Barnes, Paul Dexter, J. Marc Overhage, Burke Mamlin, J. Michael McCoy. Open Source software in medical informatics—why, how and what [J]. International Journal of Medical Informatics, 2003: 175~184.
[26]兰世龙,罗绯,周纬.局域网上医学数据库的安全模型[J].医院卫生装备, 2005, 26(1): 34-35.
[27] Yu-Cheng Chiang, Tsan-sheng Hsu, Sun Kuo, Churn-Jung Liau and Da-Wei Wang. Preserving confidentiality when sharing medical database with the Cellsecu system [J]. International Journal of Medical Informatics, 2003: 17~23.
[28] Efrat German, Akiva Leibowitza, Yuval Shahara. An architecture for linking medical decision-support applications to clinical databases and its evaluation [J]. Journal of Biomedical Informatics, 2009: 203~218.
[29]薄志忠,张更路,陈月强.动态网站开发语言比较[J].华北煤炭医学院学报, 2009, 11 (1): 135-137.
[30]王洪. PHP网站建设的安全性研究[J].计算机应用, 2004, 24(10): 64-67.
[31]张海林,杜忠友,汪美霞. PHP网站的攻击与安全防范[J].计算机安全, 2007, 1: 73-76.
[32]陈秀英.大型ORACLE数据库系统的优化设计方案[J].舰船科学技术, 2009, 31(2): 150-154.
[33] Pengyu Cao, Masao Hashiba, Kouhei Akazawa, Tomoko Yamakawa, Takayuki Matsuto. An integrated medical image database and retrieval system using a web application server [J]. International Journal of Medical Informatics, 2003: 51~55.
[34] Lars E. Olson, Carl A. Gunter, Sarah Peterson Olson, M. D. A Medical Database Case Study for Reflective Database Access Control [J]. Conference on Computer and Communications Security, 2009.
[35]申雪琴.浅析Oracle数据库中的并行处理技术[J].电脑知识与技术, 2010, 6(32): 8944-8946.
[36]魏亚楠,宋义秋. Oracle数据库应用系统的性能比较[J].制造业自动化, 2010, 32(8): 204-208.
[37] Hamid Medjahed, Dan Istrate, Jerome Boudy, Fran?ois Steenkeste, Jean-Louis Baldinger and Bernadette Dorizzi. A Multimodal Database for a Home Remote Medical Care Application [J]. Medical Biometrics Lecture Notes in Computer Science, 2007: 99~106.
[38] Paul C. Bartlett, James W. Van Buren, Margaret Neterer, Chun Zhou. Disease surveillance and referral bias in the veterinary medical database [J]. Preventive Veterinary Medicine, 2010: 264~271.
[39] Hiroshi Juzoji, Isao Nakajima, Masato Hata and Katsuyoshi Tanabe. Design of an SHD-Distributed Database over IP to Support Telemedicine [J]. Journal of Medical Systems: 285~295.
[40]周志德. Oracle数据库的SQL查询优化研究[J].计算机与数字工程, 2010, 38(11): 173-179.
[41]吴颖雪. Oracle数据库性能优化[J].科技传播, 2010, 10: 211-212.
[42]郭珉. Oracle数据库SQL优化原则[J].计算机系统应用, 2010, 19(4): 170-175.
[43]魏科科.基于Oracle数据库的索引优化[J].电脑知识与技术, 2010, 6(28): 7902-7904.
[44]张云帆. Oracle数据库备份与恢复策略[J].计算机工程, 2009, 35(15): 85-88.
[45] Mingui Sun, Yun Q. Shi, Qiang Liu and Robert J. Sclabassi. Data Integration for Medical Information Management [J]. The Journal of VLSI Signal Processing: 319~328.
[46] Raymond Sirochman, Arthur Fairfull, Neil Morgan. A Materials Database for medical devices [J]. Advanced Materials & Processes, 2008, 166(1): 215~222.
[47] Marcos. E. Acuna, CJ. Vela. B, Cavero. JM. A database for medical image management [J].Computer Methods and Programs in Biomedicine, 2007, 86(3): 51~62.
[48]王海,许占文.一种基于PHP开发动态网页的技术[J].沈阳工业大学学报, 2003, 25(4): 323-325.
[49] Yasushi Matsumura. Development of an Input System with Access to Medical Record Data and a Database Tailored for Clinical Study [J]. NEC Technical Journal, 2008, 3(3): 198~214.
[50] Ardhendu Behera, D. Lalanne, R. Ingold. DocMIR. An automatic document-based indexing system for meeting retrieval [J]. Multimedia tools and applications, 2008, 37(2): 61~80.
[51]李志红,任桢.文献检索系统结果浏览算法[J].武汉科技大学学报, 2005, 28(1): 82-85.
[2]林亚君.中国生物医学文献数据库与中国学术期刊全文数据库的比较[J].中华医学图书情报杂志, 2001.
[3] G. Sudhakar, A. Karmouch, N. D. Georganas. Design and Performance Evaluation Considerations of a Multimedia Medical Database [J]. IEEE Transactions on Knowledge and Data Engineering, 1993: 888~894.
[4] Michael Weiner, Timothy E. Stump, Christopher M.Callahan, John N.Lewis, Clement J.McDonald. A practical method of linking data from Medicare claims and a comprehensive electronic medical records system [J]. International Journal of Medical Informatics, 2003: 57~69.
[5]刘薇薇,张蕾,赵云艳.生物医学二次文献数据库现状及发展趋势[J].中华医学图书情报杂志, 2010: 19-23.
[6] Rudolf Seising. From vagueness in medical thought to the foundations of fuzzy reasoning in medical diagnosis [J]. Artificial Intelligence in Medicine, 2006: 237~256.
[7]陈伟洪.医学信息检索及常用网站[J].中外医疗, 2008, 10: 74-76.
[8]杨宏波.基于Web的中国化学文献检索系统设计与实现[M].华东师范大学硕士学位论文, 2007.
[9]宋阳,严平,曹彤.基于ASP、SQL Server 2000实现的Web文献检索系统及其查询优化[J].计算机应用与软件, 2006, 23(10): 25-29.
[10]沈秀丽,朱美英,邢宝山. ProQuest-Health & Medical Complete网络数据库检索方法[J].吉林大学学报, 2007, 33(2): 402-405.
[11]孟小峰,周龙骧,王珊.数据库技术发展趋势[J].软件学报, 2004, 15(12): 1822-1842.
[12]朱胜坚.当前医学数据库发展的若干热点[J].医学信息学杂志, 2008, 7: 29-33.
[13]汪晓航.数据库技术的发展[J].企业导报, 2011, 1: 289-290.
[14]孙思琴,韩丰谈.四个国内外医学数据库检索功能的比较研究[J].现代情报, 2003: 58-62.
[15]杜云祥,雷春炳,陈建青.国内5大中文生物医学期刊数据库文献收录比较研究[J].预防医学情报杂志, 2006: 162-166.
[16]吴晓萍.国内外医学数据库检索功能的比较研究[N].泰山医学院学报, 2006: 145-147.
[17]汤韧,刘辉. Internet中的国外药学文献检索系统资源[J].中国药学杂志, 2004, 39(5): 392-395.
[18]李卫,李英姿.国内实用网络文献检索系统[J].计算机应用, 2004, 13(9): 32-34.
[19]邸铭,张志慧.医学数据库Medline, PubMed, CBM的比较[J].农业图书情报学刊, 2009, 21(2): 61-64.
[20]宋一伦,杨学智,吕晓燕. PubMed-MEDLINE数据库英文中医药信息检索方法的探讨[J].中国中西医结合杂志, 2006, 26(7): 651-655.
[21]吴晓萍.国内外医学数据库检索功能的比较研究[J].泰山医学院学报, 2006, 27(2): 145-148.
[22]李炎,路莹.基于Lucene的医学文献检索系统[J].中华医学图书情报杂志, 2010, 9: 52-54.
[23]王红,赵亚朴,王沛.利用医学数据库检索临床病例用于教学的体会[J].医学理论与实践, 2008, 21(4): 494-496.
[24] Hairong Yu, Mari Davis, Concepcion S. Wilson, Fletcher T. H. Cole. Object-relational data modelling for informetric databases [J]. Journal of Informetrics, 2008: 240~251.
[25] Clement J. McDonald, Gunther Schadow, Michael Barnes, Paul Dexter, J. Marc Overhage, Burke Mamlin, J. Michael McCoy. Open Source software in medical informatics—why, how and what [J]. International Journal of Medical Informatics, 2003: 175~184.
[26]兰世龙,罗绯,周纬.局域网上医学数据库的安全模型[J].医院卫生装备, 2005, 26(1): 34-35.
[27] Yu-Cheng Chiang, Tsan-sheng Hsu, Sun Kuo, Churn-Jung Liau and Da-Wei Wang. Preserving confidentiality when sharing medical database with the Cellsecu system [J]. International Journal of Medical Informatics, 2003: 17~23.
[28] Efrat German, Akiva Leibowitza, Yuval Shahara. An architecture for linking medical decision-support applications to clinical databases and its evaluation [J]. Journal of Biomedical Informatics, 2009: 203~218.
[29]薄志忠,张更路,陈月强.动态网站开发语言比较[J].华北煤炭医学院学报, 2009, 11 (1): 135-137.
[30]王洪. PHP网站建设的安全性研究[J].计算机应用, 2004, 24(10): 64-67.
[31]张海林,杜忠友,汪美霞. PHP网站的攻击与安全防范[J].计算机安全, 2007, 1: 73-76.
[32]陈秀英.大型ORACLE数据库系统的优化设计方案[J].舰船科学技术, 2009, 31(2): 150-154.
[33] Pengyu Cao, Masao Hashiba, Kouhei Akazawa, Tomoko Yamakawa, Takayuki Matsuto. An integrated medical image database and retrieval system using a web application server [J]. International Journal of Medical Informatics, 2003: 51~55.
[34] Lars E. Olson, Carl A. Gunter, Sarah Peterson Olson, M. D. A Medical Database Case Study for Reflective Database Access Control [J]. Conference on Computer and Communications Security, 2009.
[35]申雪琴.浅析Oracle数据库中的并行处理技术[J].电脑知识与技术, 2010, 6(32): 8944-8946.
[36]魏亚楠,宋义秋. Oracle数据库应用系统的性能比较[J].制造业自动化, 2010, 32(8): 204-208.
[37] Hamid Medjahed, Dan Istrate, Jerome Boudy, Fran?ois Steenkeste, Jean-Louis Baldinger and Bernadette Dorizzi. A Multimodal Database for a Home Remote Medical Care Application [J]. Medical Biometrics Lecture Notes in Computer Science, 2007: 99~106.
[38] Paul C. Bartlett, James W. Van Buren, Margaret Neterer, Chun Zhou. Disease surveillance and referral bias in the veterinary medical database [J]. Preventive Veterinary Medicine, 2010: 264~271.
[39] Hiroshi Juzoji, Isao Nakajima, Masato Hata and Katsuyoshi Tanabe. Design of an SHD-Distributed Database over IP to Support Telemedicine [J]. Journal of Medical Systems: 285~295.
[40]周志德. Oracle数据库的SQL查询优化研究[J].计算机与数字工程, 2010, 38(11): 173-179.
[41]吴颖雪. Oracle数据库性能优化[J].科技传播, 2010, 10: 211-212.
[42]郭珉. Oracle数据库SQL优化原则[J].计算机系统应用, 2010, 19(4): 170-175.
[43]魏科科.基于Oracle数据库的索引优化[J].电脑知识与技术, 2010, 6(28): 7902-7904.
[44]张云帆. Oracle数据库备份与恢复策略[J].计算机工程, 2009, 35(15): 85-88.
[45] Mingui Sun, Yun Q. Shi, Qiang Liu and Robert J. Sclabassi. Data Integration for Medical Information Management [J]. The Journal of VLSI Signal Processing: 319~328.
[46] Raymond Sirochman, Arthur Fairfull, Neil Morgan. A Materials Database for medical devices [J]. Advanced Materials & Processes, 2008, 166(1): 215~222.
[47] Marcos. E. Acuna, CJ. Vela. B, Cavero. JM. A database for medical image management [J].Computer Methods and Programs in Biomedicine, 2007, 86(3): 51~62.
[48]王海,许占文.一种基于PHP开发动态网页的技术[J].沈阳工业大学学报, 2003, 25(4): 323-325.
[49] Yasushi Matsumura. Development of an Input System with Access to Medical Record Data and a Database Tailored for Clinical Study [J]. NEC Technical Journal, 2008, 3(3): 198~214.
[50] Ardhendu Behera, D. Lalanne, R. Ingold. DocMIR. An automatic document-based indexing system for meeting retrieval [J]. Multimedia tools and applications, 2008, 37(2): 61~80.
[51]李志红,任桢.文献检索系统结果浏览算法[J].武汉科技大学学报, 2005, 28(1): 82-85.