基于openEHR的原型关系映射方法
发布时间：2018-11-11 18:41
【摘要】：医疗信息的复杂性和动态性给医疗信息系统带来1巨大挑战。openEHR规范的两层建模思想可以提高医疗信息系统的灵活性,适应医疗信息需求的变化。目前虽然已有采用openEHR官方提出的属性+路径(node+path)和openEHR参考模型对象关系映射的openEHR数据存储实现方案,但其性能无法达到临床实际应用的需要。本研究提出一种基于openEHR原型和关系数据库的自动映射方法,将原型映射为关系数据表、原型属性映射为关系数据表字段,在此基础上设计了原型驱动的数据持久化和数据访问平台。基于原型关系映射方法,对原型查询语言进行扩展,添加INSERT、UPDATE、DELETE等语法,使原型查询语言支持完整的数据操作功能。结果表明,原型关系映射方法与属性+路径和openEHR参考模型对象关系映射方法相比,在1 231条数据中查询3条数据时快69倍和8倍,在128 141条数据中查询1 593条数据时快2倍和17倍。原型关系映射和原型查询语言等技术不但可以发挥两层建模方法在医疗信息表达、存储和访问等方面的灵活性优势,而且能大幅提高数据访问的性能。
[Abstract]:The complexity and dynamics of medical information bring a great challenge to medical information system. The two-layer modeling idea of openEHR specification can improve the flexibility of medical information system and adapt to the change of medical information demand. Although there is an implementation scheme of openEHR data storage based on attribute path (node path) and openEHR reference model object-relational mapping proposed by openEHR, its performance can not meet the needs of clinical application. In this paper, an automatic mapping method based on openEHR prototype and relational database is proposed. The prototype is mapped to relational data table, and prototype attribute is mapped to relational data table field. On this basis, a prototype driven data persistence and data access platform is designed. Based on the prototype relational mapping method, the prototype query language is extended, and syntax such as INSERT,UPDATE,DELETE is added to make the prototype query language support the complete data operation function. The results show that compared with attribute path and openEHR reference model object mapping, the prototype relational mapping method is 69 times and 8 times faster when querying 3 pieces of data in 1 231 pieces of data. The speed of querying 1,593 data out of 128,141 data was 2 times and 17 times faster. The techniques of prototype relational mapping and prototype query language can not only give full play to the flexibility of two-tier modeling method in medical information representation, storage and access, but also greatly improve the performance of data access.
【作者单位】： 浙江大学生物医学工程与仪器科学学院;
【基金】：国家高技术研究发展计划(863计划)(2012AA02A601) 国家科技重大专项(2013ZX03005012)
【分类号】：R310
本文编号：2325773
[Abstract]:The complexity and dynamics of medical information bring a great challenge to medical information system. The two-layer modeling idea of openEHR specification can improve the flexibility of medical information system and adapt to the change of medical information demand. Although there is an implementation scheme of openEHR data storage based on attribute path (node path) and openEHR reference model object-relational mapping proposed by openEHR, its performance can not meet the needs of clinical application. In this paper, an automatic mapping method based on openEHR prototype and relational database is proposed. The prototype is mapped to relational data table, and prototype attribute is mapped to relational data table field. On this basis, a prototype driven data persistence and data access platform is designed. Based on the prototype relational mapping method, the prototype query language is extended, and syntax such as INSERT,UPDATE,DELETE is added to make the prototype query language support the complete data operation function. The results show that compared with attribute path and openEHR reference model object mapping, the prototype relational mapping method is 69 times and 8 times faster when querying 3 pieces of data in 1 231 pieces of data. The speed of querying 1,593 data out of 128,141 data was 2 times and 17 times faster. The techniques of prototype relational mapping and prototype query language can not only give full play to the flexibility of two-tier modeling method in medical information representation, storage and access, but also greatly improve the performance of data access.
【作者单位】： 浙江大学生物医学工程与仪器科学学院;
【基金】：国家高技术研究发展计划(863计划)(2012AA02A601) 国家科技重大专项(2013ZX03005012)
【分类号】：R310
【参考文献】
相关期刊论文 前1条
1 曾蔷;姚志洪;刘雷;;双模型健康档案标准openEHR[J];中国医疗设备;2010年03期
【共引文献】
相关期刊论文 前2条
1 姚志洪;;医疗卫生信息化十大视点[J];中国卫生信息管理杂志;2012年03期
2 姚志洪;;医疗卫生信息化10大视点[J];医学信息学杂志;2013年01期
相关硕士学位论文 前1条
1 贝乾;数据仓库技术在医院系统集成中的应用[D];苏州大学;2013年
【二级参考文献】
相关期刊论文 前1条
1 吕孟涛;李道苹;吴静;饶克勤;;电子健康档案现状分析与展望[J];医学与社会;2006年07期
，本文编号：2325773
本文链接：https://www.wllwen.com/yixuelunwen/swyx/2325773.html
