Construction Method of Clinical Medical Data Warehouse Based on openEHR
1 College of Business Administration, Zhejiang University of Technology, Hangzhou 310023, China
2 College of Biomedical Engineering and Instrument Science, Zhejiang University, Hangzhou 310027, China
Abstract：Complexity and continuous evolution of healthcare information is the biggest challenge for healthcare information systems, and two-level information model from openEHR can facilitate healthcare information systems to adapt to the change of healthcare information requirements. However, the medical information system based on openEHR two-level modeling displays low performance when facing with specific operational demands such as a large number of data query and complex and mutative query conditions. This is mainly related to the fundamental data storage model. The multidimensional data model of data warehouse has the advantage of high-performance query, the data mart that is established for fulfilling users′ particular demand can increase the particular query speed. Due to the particularity of the medical information system that based on openEHR two-level modeling, the outcomes for traditional data warehouse construction method include low users′ participation and time consuming. In this work, a mapping method between template and multidimensional data model of data warehouse based on openEHR two-level modeling was proposed to solve this problem, aiming to achieve the configuration of multidimensional data model by users, and use the mapping path to accelerate the implementation of ETL. This research provided one kind of dirigible and scalable data warehouse construction method reflecting user′s requirements for medical industry. We also validated this method in performance. Results showed that the data mart that was built based on this method was 5.6 times faster than the database which was generated based on openEHR two-level modeling and was 0.97 times than the data mart that was built by traditional method when querying 329 results in 10861522 records.
王冬冬1 叶枫1 吕旭东2* 闵令通2 王利2. 基于openEHR的临床医疗数据仓库构建方法[J]. 中国生物医学工程学报, 2016, 35(2): 162-168.
Wang Dongdong1 Ye Feng1 Lv Xudong2* Min Lingtong2 Wang Li2 . Construction Method of Clinical Medical Data Warehouse Based on openEHR. journal1, 2016, 35(2): 162-168.
［1］曾蔷,姚志洪，刘雷.双模型健康档案标准openEHR［J］.中国医疗设备，2010，25(3):7-10.
［2］Beale T, Heard S, Kalra D, et al. OpenEHR architecture overview［J］. The OpenEHR Foundation, 2006.
［3］Kalra D, Beale T, Heard S. The openEHR foundation［J］. Studies in health technology and informatics, 2005,115: 153-173.
［4］Garde S, Hovenga E, Buck J, et al. Expressing clinical data sets with openEHR archetypes: a solid basis for ubiquitous computing ［J］. Int J Med Inform, 2007, 76(3):334-341.
［5］Spth MB, Grimson J. Applying the archetype approach to the database of a biobank information management system ［J］. Int J Med Inform, 2011,80（3）：205-226.
［6］Arikan S, Shannon T, Ingram D. Opereffa 2009［EB/OL］. http://opereffa.chime.ucl.ac.uk/introduction.jsf, 2009-05-14/2015-09-10.
［7］Freire S M. Performance of XML databases for epidemiological queries in archetype\|based EHRs
［C］//Freire SM, Sundvall E, Karlsson D, eds. Proceedings Scandinavian Conference on Health Informatics 2012. Link
ping: Linkping University Electronic Press, 2012:51-57.
［8］Madaan A, Chu W, Daigo Y, et al. Quasirelational query language interface for peristent standardized EHRs: using NoSQL Databases［M］//Databases in Networked Information Systems. Berlin: Springer Berlin Heidelberg, 2013:182-196.
［9］王利，闵灵通，吕旭东，等.基于openEHR的原型关系映射方法［J］.中国生物医学工程学报，2014，33(4):432-437.
［10］何彩升，邹赛德.数据仓库技术及其在医院信息管理中的应用［J］.计算机医学应用, 2003,16（8）：418-422.
［11］Leslie H, International developments in openEHR archetype and template［J］.HIM J,2008,37(1):38-39.
［12］李珍珍.基于openEHR的电子病历系统开发方法研究与实践［D］.杭州：浙江大学，2008.
［13］李明芳，刘红，姚敏.数据仓库方法论［J］.计算机应用与软件,2003,20(1):1-2.
［14］宋擒豹,杨向荣,沈钧毅.数据仓库技术研究［J］.计算机工程，2002, 28(1):125-127.
［15］李园，陈世平.MVC设计模式在ASP.NET平台中的应用［J］.计算机工程与设计,2009,30(13):3180-3184.
［16］高静，段会川.JSON数据传输效率研究［J］.计算机工程与设计,2011,32(7):2267-2270.
