军事医学2017，Vol.41Issue(12)：1009-1012,4.DOI:10.7644/j.issn.1674-9960.2017.12.014
军人电子健康档案大数据即席查询统计子系统的设计与实现
Design and implementation of big data ad-hoc queries and statistics subsystem for miliary electronic health records
摘要
Abstract
Objective To improve the analysis efficiency and interactive experience of the Military Electronic Health Records System(MEHRS)and to realize quick response of ad-hoc queries and statistics in the MEHRS with big data columnar storage and processing technologies.Methods We carried out requirement analysis and functional design of the ad-hoc queries and statistics subsystem of the MEHRS,proposed a three-tier architecture which included the archive storage layer,statistical pretreatment layer and statistical application layer.After the selection and evaluation of big data processing technologies,CarbonData columnar storage was used to store preprocessed data and executed statistics with Spark SQL on the basis of medical business data modeling and preprocessing.Results Five testing tasks were executed on two million archives in the following two subsystems:one with modeless and non-preprocessed MongoDB storage,the other with modeled and preprocessed CarbonData storage.The latter could finish these tasks within seconds and was dozens of times more efficient than the former statistically.Conclusion This study designs and implements a big data technology proposal that satisfies the quick response of ad-hoc queries and statistics in the MEHRS, providing powerful and flexible technical support for big data statistical analysis.关键词
军人电子健康档案/即席查询统计/CarbonData列存储/SparkSQL交互式处理框架/病案系统,计算机化Key words
military electronic health records/ad-hoc queries and statistics of big data/CarbonData columnar storage format/Spark SQL interactive processing framework/medical records systems,computerized分类
医药卫生引用本文复制引用
迟晨阳,孟海滨,秦栋梁,钱诚,赵东升,毛华坚..军人电子健康档案大数据即席查询统计子系统的设计与实现[J].军事医学,2017,41(12):1009-1012,4.基金项目
军队后勤科研重大项目(AWS14R013) （AWS14R013）
