Research On Design And Optimization Of Electronic Health Archive Data Storage Based On MongoDB

In the new stage of the new century,the party has given a new historical mission to our army,as well as a new historical requirement of “able to fight,able to win”,which makes our army an informatisation army from a mechanization one.It's an infrastructure of military health management to build up the military electronic health record system.It also plays a vital role in maintaining and promoting soldiers' health,and keeping the battle effectiveness.Building up military electronic health record should be focused in the construction of informational medical service.The project of electronic health record has been an important job from the "Eleventh Five-Year Plan",when the National Science and Technology started a national supported project called "The Construction and Application of Chinese Citizens' Healthcare Management Information System".In the "Thirteenth Five-Year Plan" period,China government put forward a plan about building up three basic databases of Electronic Health Record,Electronic Medical Record,National Population Data Resources.There's also a summary arrangement and deployment for Military Electronic Health Record and Healthcare Management Information System in the Eleventh Five-Year Plan of Military Medical and Health-care conference.As above,the establishment of Military Electronic Health Record,is the basic road to follow the international information process,is an inevitable requirement of combining the military EHR and citizen EHR,is the necessary mean to protect the health of all out PLAs,is the only way to follow up the development of international information.This research topic is from "Military Electronic Health Record and Healthcare Management System" of logistics research projects.The research will first analysis the schemas of accessing EHR data,then choose a proper database which can handle the semi-structured data and can store flexible and scalable contents,finally design the prototype of data model,implement and optimize the storage APIs for EHR system.The purpose of this research is to provide a technical foundation of the military EHR,especially for the storage part.It will also ensure the feasibility,reliability and extensibility of the system.This article analyzes the development of EHR and the relational concepts and theories by means of literature research,comparative analysis,systematic analysis,investigation and empirical research.By discuss about the selection of database technology,the demand analysis,the designing and optimizing of model schemas,the designing and evaluating of the program,this article takes a comprehensive discussion of the military EHR about how to save and what the schemas should be like.This research solves the problem of data storage during the develop of the military EHR system.It meets the demand of access to the EHR data by different roles such as leaders of military health service,responsible military doctor,medical staff,soldiers and officers etc.The result of the research will also contribute to the citizen's EHR system theoretically and practically.1.Selection of Database TechnologySince military electronic health record collects data from different database sources,contains complicated data relationships,has flexible contents,it's not suitable to store the EHR data using the traditional ways and databases with fixed mode.What's more,there is a lot of data with semi-structured or unstructured contained by the military EHR,it's difficult to handle these data with relational database.After comparing and analyzing several NoSQL databases,we found an open-sourced document database,MongoDB would be proper to the need.So we choose MongoDB as the basic database for the storage system.2.Demand Analysis of Accessing DatabaseWhile implementing the storage system with MongoDB,the logical model and physical model should be designed by the attributes of the EHR and the access demands.The attributes and access demands are decided by the application of military EHR.The military EHR system is an integrated information system designed for multiple roles invoking the EHR business.It provides reading and writing approaches to the EHR data from different aspects.This system contains two roles of maintenance which are super administrators and administrators,four roles of users which are leaders of military health service,responsible military doctor,medical staff,soldiers and officers.Except administrators,the other five roles will access the EHR database in different aspects.When we consider these five roles from perspective of database,we summarize them into three operations as insert,update and query.The logic of insert and update operations which are relatively simple don't need a further summary.But the query operation,with some simple statistics,which invokes several fields and relationships between business,needs a further summary.We conclude three functions,which are count,group and select,and three degrees limiting them,which are from recognition,disease and time span for the query operations.All query operations will be covered by these functions and degrees.3.Design and Optimize Model SchemasSince concepts of EHR vary from time,current business never shows what it will be like in the future.As time passes,what the EHR contains will be more completed,which requires an evaluating ability for the data structure and storage schemas of the health record.The semi-structured health record makes a stricter demand in designing the data model.In this project,we make an EHR generating system,which helps administrators in EHR system make their own models according to demands.What we research is made by this system too.In order to handle different business models in EHR data model,we design a direct storage model,which means documents in MongoDB is one-to-one corresponded to what in EHR.To improve the query performance about statistics,an optimized storage model has also been created,which did effectively improve the efficiency of the query operations.4.Design and Evaluate the ProgramAfter designing and optimizing the database,we implement these models in program and relative APIs for the EHR application.We then evaluate the efficiency with test cases.The result shows the optimized storage model has better performance in most data scales.For larger scale,it is no worse than the origin one.This storage system has been applied to the military EHR system,the model implemented improves the performance in query operations obviously.Now the military EHR system has been piloted in several hospitals of Southern Theater Command and PLA Rocket force.It has made great effects.The pilot project lays a solid foundation the popularize to the whole army.This research is part of the military EHR project.It made a meaningful attempt in schema design.It had practical application value.We hope it's valued for the relative research.