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

Joseph Owuondo
DOI: https://doi.org/10.2139/ssrn.4548519
2023-01-01
SSRN Electronic Journal
Abstract:The advancement in data storage systems and novel data types has made organizations 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 of deploying hybrid relational database management systems and NoSQL systems while developing better electronic health records (EHR) systems within health facilities alongside the 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 an 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 clear visualization of patients’ geographical locations, medical facilities, and the physical location of the physicians. Integrating these database systems within the healthcare arena was instrumental in compelling application systems to adhere to the HIPAA EHR standards without compromising performance and scalability.
What problem does this paper attempt to address?