Integrated Document-based Electronic Health Records Persistence Framework

Aya Gamal, Sherif Barakat, Amira Rezk
2021 International Journal of Advanced Computer Science and Applications  
Electronic health record systems work beyond just recording patients' health data. They have multiple secondary functionalities, such as data reporting and clinical decision support. As each of these systems' workloads has contradictory different needs, managing a multipurpose electronic health record is a challenge. This paper proposes a unified healthcare data framework that can simplify health information system infrastructure. It investigates the suitability of the documentbased NoSQL
more » ... tence mechanism, storing electronic health records data as a design choice for managing varied complexity ad hoc queries used in operational business intelligence. The performance of the most popular two document-based NoSQL back-ends, Couchbase Server and MongoDB, is compared according to the size of the database and query execution time. Results showed that while MongoDB can execute simple singledocument queries nearly in milliseconds. It does not provide satisfactory response time for unplanned complex queries spanning multiple documents. By utilizing its analytics services and multi-dimensional scaling architecture, Couchbase Server multi-node cluster outperforms the response times of MongoDB for both simple and complex healthcare data access patterns. The primary advantage of the proposed tightly coupled EHRs processing framework is its flexibility to manage workload according to changing requirements.
doi:10.14569/ijacsa.2021.0121017 fatcat:doy3afttv5gzbovsa3nmj4tm2y