A Comprehensive Health Electronic Record System with MySQL RDMS, QGIS Database and Mongo DB

Abstract

The advancement in data storage systems and novel data types has made organizations to stop relying on the use of simple client/server I.T infrastructure and leverage more on multiple categories of database systems to keep heterogeneous data. The study exploits the benefits around deploying hybrid relational database management systems and NoSQL systems while developing better electronic health records (EHR) systems within health facilities alongside facility decision support system (FDSS). More particularly, GIS, MySQL and Mongo DB databases were integrated to enhance EHR systems alongside offering improve clinical decision support. The study adopted experimental design to develop the Electronic Health Records System using GIS, MySQL and Mongo DB software to create the database. Findings revealed that the atomicity, consistency, isolation and durability feature typical of relational database management systems guaranteed data security, integrity, ease of access and efficient transaction processing. Mongo database offered the system a more precise internal data structure and solid scalability along with simplified mapping of application objects to the underlying database design. The GIS database enabled a clear visualization of patients’ geographical locations, medical facilities, and the physical location of the physicians. Integrating these database systems within the health care arena was instrumental in compelling application systems to adhere to the HIPAA EHR standards without compromising performance and scalability.