Development of a Query processing optimization model in electronic health records systems

Document Type : Original Article

Authors

library and information science department, Faculty of art, Alexandria university, Alexandria, Egypt

Abstract

As a primary data source, electronic health records provide great opportunities for healthcare service improvement. The success of EHR systems is measured by the accuracy and comprehensiveness of its outputs, as well as its role and support in decision making. Therefore, the study aims at evaluating the effectiveness of e-Dylphyn system, a blood bank management system used in Egypt, and its capability to manage the electronic health records of the unit’s patients.
The study was conducted in the regional center of blood transfer service in Alexandria. The queries and reports on patients’ data as well as statistics for decision making support were observed on system. The case study methodology was followed for evaluating the performance of the system and health informatics service in the center. Furthermore, the case study results were employed for optimizing queries in the system.
The study has concluded that system does not support EHR in an advanced way. It was also concluded that it does not provide integration for different secondary blood banks with the regional center. Therefore, the system cannot be reliable for data correlation or gathering detailed data on the center activity in delivering health care service. The most significant study result was the system’s query ability to generate a detailed report on inpatients volume and their categorization.
In conclusion, it is recommended to build a framework that depends on swift big data analysis to make good use of the enormous data stored in secondary blood banks.

Keywords