Native XML数据库在电子病历存储中的应用分析  

The Application Analysis of Native XML Database in Electronic Medical Record Storage

作　　者：田昊宇 马义[2] 

机构地区：[1]沈阳市20中学,沈阳110003 [2]沈阳市回民中学,沈阳110016

出　　处：《软件》2017年第10期202-206,共5页Software

摘　　要：针对使用传统关系型数据库进行电子病历存储所存在的数据建模复杂、扩展性差、查询性能低等问题,提出了使用Native XML数据库来存储XML格式的电子病历,并以DB2 Pure XML数据库为例,在实验环境下模拟构造XML电子病历数据,分别就数据建模、查询语言、客户端开发和性能四个方面进行验证与分析。验证结果显示使用DB2进行XML数据建模结构简单、扩展性好,优于使用传统对象关系模型建模;使用基于XQuery和XPath的查询语言以及客户端开发成本不高;在性能方面,基于10.6k的病历文件、100000数据量及有索引的情况下,查询性能可以达到0.046秒。表明Native XML数据库适合于构建电子病历的存储。Based on the problem of traditional relational database for electronic medical records, such as data modeling of complicated, poor scalability, low query performance, put forward the use of Native XML database to store the XML format of electronic medical records, and with DB2 Pure XML database, for example, in the experi-mental environment simulation data of XML structure, data model, query language and client development and per-formance of four aspects for validation and analysis. The results show that using DB2 for XML data modeling structure is simple and extensible, which is better than modeling with traditional object relational model. Using query languages based on XQuery and XPath and client development costs are not high; In terms of performance, the query performance can reach 0.046 seconds based on 10.6 k of medical records, 100,000 data and indexes. It is shown that the use of Native XML database is applicable to the storage of electronic medical records.

关 键 词：电子病历 XML XQUERY XPATH DB2 NATIVE XML数据库 

分 类 号：TP392[自动化与计算机技术—计算机应用技术]