Integrated Healthcare Database Systems: A Review of Data Warehousing, Storage, and Integration Strategies
DOI:
https://doi.org/10.58776/ijitcsa.v3i2.181Keywords:
PHR, EMR, Data Warehouse, Healthcare, Wearable TechnologyAbstract
This paper provides a comprehensive review of current database systems and data warehousing technologies within the healthcare sector, emphasizing their roles in supporting forecasting and analytics. The objective is to describe, analyze, and evaluate the key features of these systems, particularly focusing on the essential functions of data storage and data integration in managing complex healthcare data environments. Recognizing that efficient data storage is fundamental to effective database management, the paper examines prevalent challenges within current healthcare systems, including issues related to data infrastructure, security, and interoperability. It further investigates how these challenges impact the reliability and accessibility of data crucial for informed decision-making. In addition to highlighting the difficulties, this review delves into the benefits and drawbacks of various data integration strategies. It discusses how advanced integration techniques can enhance data accuracy, streamline real-time access, and bolster analytical capabilities, while also addressing potential risks such as integration complexity and security vulnerabilities. By synthesizing the latest trends and research in database management, this paper aims to offer valuable insights for healthcare practitioners, IT professionals, and researchers. Ultimately, it seeks to guide the development of more secure, efficient, and resilient data management strategies that can better support healthcare analytics and forecasting in an increasingly data-driven industry.
References
. H. Santoso, “Implementation of sanctions for health facilities that have not implemented Electronic Medical Records (EMR),” Journal La Sociale, vol. 5, no. 1, pp. 174–180, Feb. 2024. doi:10.37899/journal-la-sociale.v5i1.1011.
. D. M. R. West, "Sizing up big data," Nature Medicine, vol. 25, no. 1, pp. 22–23, Jan. 2019, doi: 10.1038/s41591-019-0703-0.
. A. Jha, C. DesRoches, E. Campbell, K. Donelan, and T. Ferris, "Use of Electronic Health Records in U.S. Hospitals," New England Journal of Medicine, vol. 360, no. 16, pp. 1628–1638, Apr. 2009, doi: 10.1056/NEJMsa0900592.
. D. M. R. West, "Electronic Medical Records: Promises and Problems," Issues in Technology Innovation, vol. 5, pp. 1–14, May 2012, doi: 10.2139/ssrn.2049396.
. K. D. Mandl, P. Szolovits, and I. S. Kohane, "Public standards and patients' control: how to keep electronic medical records accessible but private," BMJ, vol. 322, no. 7281, pp. 283–287, Feb. 2001, doi: 10.1136/bmj.322.7281.283.
. E. Carini et al., "The Impact of Digital Patient Portals on Health Outcomes, System Efficiency, and Patient Attitudes: Updated Systematic Literature Review," Journal of Medical Internet Research, vol. 23, no. 9, p. e26189, Sep. 2021, doi: 10.2196/26189.
. S. A. Ajami and M. Bagheri-Tadi, "Barriers for adopting electronic health records (EHRs) by physicians," Acta Informatica Medica, vol. 21, no. 2, pp. 129–134, 2013, doi: 10.5455/aim.2013.21.129-134.
. J. Walker, E. Pan, D. Johnston, J. Adler-Milstein, D. W. Bates, and B. Middleton, "The value of health care information exchange and interoperability," Health Affairs, vol. 24, no. Suppl 1, pp. W5-10–W5-18, 2005, doi: 10.1377/hlthaff.w5.10.
. Y.-T. Park and D. Han, "Current Status of Electronic Medical Record Systems in Hospitals and Clinics in Korea," Healthcare Informatics Research, vol. 23, no. 3, pp. 189–198, Jul. 2017, doi: 10.4258/hir.2017.23.3.189.
. Y. Park, "Factors Affecting Electronic Medical Record System Adoption in Small Korean Hospitals," Healthcare Informatics Research, vol. 20, no. 1, pp. 26–33, Jan. 2014, doi: 10.4258/hir.2014.20.1.26.
. J. Adler-Milstein and A. Jha, "No evidence found that hospitals are using new electronic health records to increase Medicare reimbursements," Health Affairs, vol. 33, no. 7, pp. 1271–1277, Jul. 2014, doi: 10.1377/hlthaff.2014.0179.
. S. A. Ajami and M. Bagheri-Tadi, "Barriers for adopting electronic health records (EHRs) by physicians," Acta Informatica Medica, vol. 21, no. 2, pp. 129–134, 2013, doi: 10.5455/aim.2013.21.129-134.
. D. M. R. West, "Electronic Medical Records: Promises and Problems," Issues in Technology Innovation, vol. 5, pp. 1–14, May 2012, doi: 10.2139/ssrn.2049396.
. M. Lee and H. Lee, "Adoption of Cloud Computing in Small and Medium Hospitals: Challenges and Solutions," Healthcare Informatics Research, vol. 21, no. 3, pp. 223–230, Jul. 2015, doi: 10.4258/hir.2015.21.3.223.
. S. Uslu, A. Stausberg, and M. Hübner, "Security Challenges in Healthcare IT: A Review of the Literature," Journal of Medical Systems, vol. 44, no. 2, pp. 1–9, Feb. 2020, doi: 10.1007/s10916-019-1502-1.
. J. Kim and D. Im, "Data Recovery Strategies in Healthcare Systems: Ensuring Continuity and Integrity," Journal of Biomedical Informatics, vol. 58, pp. 1–7, Dec. 2015, doi: 10.1016/j.jbi.2015.09.003.
. D. Lacher, "Why Medical Records are 10 Times More Valuable Than Credit Card Info," LinkedIn, Jan. 2023. [Online]. Available: https://www.linkedin.com/pulse/why-medical-records-10-times-more-valuable-than-card-lacher-cissp
. J. Jung, "Security Challenges in Small and Medium-Sized Hospitals," Healthcare Informatics Research, vol. 25, no. 3, pp. 200–210, Jul. 2019, doi: 10.4258/hir.2019.25.3.200.
. J. Kim and D. Im, "Data Recovery Strategies in Healthcare Systems: Ensuring Continuity and Integrity," Journal of Biomedical Informatics, vol. 58, pp. 1–7, Dec. 2015, doi: 10.1016/j.jbi.2015.09.003.
. M. Lee and H. Lee, "Adoption of Cloud Computing in Small and Medium Hospitals: Challenges and Solutions," Healthcare Informatics Research, vol. 21, no. 3, pp. 223–230, Jul. 2015, doi: 10.4258/hir.2015.21.3.223.
. F. Alharbi, A. Atkins, and C. Stanier, "Understanding the Determinants of Cloud Computing Adoption in Saudi Healthcare Organisations," Complex & Intelligent Systems, vol. 2, no. 3, pp. 155–171, Sep. 2016, doi: 10.1007/s40747-016-0021-9.
. Statista, "Number of connected wearable devices worldwide from 2016 to 2022," Statista Research Department, 2021. [Online]. Available: https://www.statista.com/statistics/487291/global-connected-wearable-devices/ [Accessed: Oct 6, 2024].
. S. Sreemathy, K. S. S. Kumar, and S. S. S. Kumar, "Overview of ETL Tools and Talend-Data Integration," International Journal of Advanced Research in Computer and Communication Engineering, vol. 9, no. 5, pp. 1–5, May 2020, doi: 10.17148/IJARCCE.2020.951.
. K. Hoffmann et al., "Data integration between clinical research and patient care: A framework for context-depending data sharing and in silico predictions," PLOS ONE, vol. 18, no. 5, p. e0279285, May 2023, doi: 10.1371/journal.pone.0279285.
. J. Wang, "Clinical Data Warehousing: A Scoping Review," Journal of the Society for Clinical Data Management, vol. 1, no. 1, pp. 1–10, 2023, doi: 10.47912/jscdm.320.
. Y. Kim et al., "Real-time automatically updated data warehouse in healthcare: A case study," Healthcare Informatics Research, vol. 27, no. 4, pp. 293–301, Oct. 2021, doi: 10.4258/hir.2021.27.4.293.
. M. Smith and L. Jones, "Healthcare Big Data Warehouse in the Cloud," International Journal of Cloud Computing, vol. 4, no. 2, pp. 45–52, 2016.
. J. Lee, S. Shim, and H. Im, "Challenges in Standardizing Hospital Information Systems: A Case Study," Journal of Healthcare Informatics, vol. 15, no. 2, pp. 123–130, 2009.
. S. Paul et al., "Weakly Supervised Information Extraction from Inscrutable Handwritten Document Images," arXiv preprint arXiv:2306.06823, Jun. 2023. [Online]. Available: https://arxiv.org/abs/2306.06823.
. X. P. Gao, Y. Y. Xu, and D. H. Liu, "Investigation and Analyses of Problems in Standardization of 'NO.1 Military Project'," Hospital Administration Journal of Chinese PLA, vol. 30, no. 4, pp. 45–50, 2009.
. H. Bangotra, N. Kumar, M. Sood, and R. Buyya, "Internet of Wearable Things (IoWT): Concept, architecture, applications, and research issues," Computer Networks, vol. 177, p. 107315, Nov. 2020, doi: 10.1016/j.comnet.2020.107315.
. C. S. Hong et al., "Security and privacy of wearable health devices: A review," Healthcare Informatics Research, vol. 28, no. 1, pp. 13–25, Jan. 2022, doi: 10.4258/hir.2022.28.1.13.
. J. Xu et al., "Enabling health data sharing with privacy preservation using blockchain and federated learning," IEEE Transactions on Industrial Informatics, vol. 18, no. 1, pp. 296–305, Jan. 2022, doi: 10.1109/TII.2021.3061534.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Bikash Ram Suman
This work is licensed under a Creative Commons Attribution 4.0 International License.
Attribution 4.0 International
You are free to:
- Share — copy and redistribute the material in any medium or format for any purpose, even commercially.
- Adapt — remix, transform, and build upon the material for any purpose, even commercially.
- The licensor cannot revoke these freedoms as long as you follow the license terms.
Under the following terms:
- Attribution — You must give appropriate credit , provide a link to the license, and indicate if changes were made . You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
- No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
Notices:
You do not have to comply with the license for elements of the material in the public domain or where your use is permitted by an applicable exception or limitation .
No warranties are given. The license may not give you all of the permissions necessary for your intended use. For example, other rights such as publicity, privacy, or moral rights may limit how you use the material.
