Decision support system for health care resources allocation
Keywords:
Data warehouse, Health sector, Decision support systemAbstract
Background: A study about healthcare resources can improve decisions regarding the allotment and mobilization of medical resources and to better guide future investment in the health sector.
Aim: The aim of this work was to design and implement a decision support system to improve medical resources allocation of Bejaia region.
Methods: To achieve the retrospective cohort study, we integrated existing clinical databases from different Bejaia department health sector institutions (an Algerian department) to collect information about patients from January 2015 through December 2015. Data integration was performed in a data warehouse using the multi-dimensional model and OLAP cube. During implementation, we used Microsoft SQL server 2012 and Microsoft Excel 2010.
Results: A medical decision support platform was introduced, and was implemented during the planning stages allowing the management of different medical orientations, it provides better apportionment and allotment of medical resources, and ensures that the allocation of health care resources has optimal effects on improving health.
Conclusion: In this study, we designed and implemented a decision support system which would improve health care in Bejaia department to especially assist in the selection of the optimum location of health center and hospital, the specialty of the health center, the medical equipment and the medical staff.
References
Wagstaff A. Poverty and health sector inequalities. Bull World Health Organ. 2002; 80(2): 97-105. PMID:
, PMCID: PMC2567730.
Ross J. The use of economic evaluation in health care: Australian decision makers' perceptions. Health
Policy. 1995; 31(2): 103-10. doi: 10.1016/0168-8510(94)00671-7, PMID: 10141251.
ANDI: National Agency for Investment Development of Algeria. Available from:
http://www.andi.dz/index.php/fr/secteur-de-sante.
Dedić N, Stanier C. An Evaluation of the Challenges of Multilingualism in Data Warehouse Development.
th International Conference on Enterprise Information Systems. 2016; 1: 196-206. doi:
5220/0005858401960206.
Inmon WH. Building the Data Warehouse. 2nd edition. New York: John Wiley and Sons; 1996.
Shah SP, Huang Y, Xu T, Yuen MM, Ling J, Ouellette BF. Atlas–a data warehouse for integrative
bioinformatics. BMC bioinformatics. 2005; 6: 34. doi: 10.1186/1471-2105-6-34. PMID: 15723693,
PMCID: PMC554782.
Zhang X, Ding L, Elke A, Rundensteiner EA. Parallel multisource view maintenance. VLDB. 2004; 13(1):
-48. doi: 10.1007/s00778-003-0086-0.
Surajit CH, Dayal U. An overview of data warehousing and OLAP technology. ACM. 1997; 26(1): 65-74.
doi: 10.1145/248603.248616.
Sebaa A, Tari A. Self-Maintainable Views Group in P2P Environment. American Academic & Scholarly
Research Journal. 2014; 6(4): 186.
Golfarelli M. From User Requirements to Conceptual Design in Data Warehouse Design – a Survey. In:
Data Warehouse Design and Advance Engineering Applications: Methods for Complex Construction.
IRMA International. 2010; 1-16. doi: 10.4018/978-1-60566-756-0.ch001.
Peter R, Coronel C, Morris S. Database systems: design, implementation and management. 10th ed.
Cengage Learning: Wadsworth Publ; 2013.
Lightstone SS, Teorey TJ, Nadeau T. Physical Database Design: the database professional's guide to
exploiting indexes, views, storage, and more. Morgan Kaufmann. 2010. ISBN:13-9-78-0-12-369-389-1.
Ewen EF, Medsker CE, Dusterhoft LE. Data warehousing in an integrated health system: building the
business case. ACM. 1998: 47-53. doi: 10.1145/294260.294271.
Kuo MH, Sahama T, Kushniruk AW, Borycki EM, Grunwell DK. Health big data analytics: current
perspectives, challenges and potential solutions. International Journal of Big Data Intelligence. 2014; 1(1- 2): 114-26. doi: 10.1504/IJBDI.2014.063835.
Sumathi S, Esakkirajan S. Fundamentals of relational database management systems. Studies in
Computational Intelligence. 2007. ISBN: 978-3-540-48397-7.
Kerkri EM, Quantin C, Allaert FA, Cottin Y, Charve P, Jouanot F, et al. An approach for integrating
heterogeneous information sources in a medical data warehouse. J Med Syst. 2001; 25(3): 167-76. doi:
1023/A:1010728915998. PMID: 11433546.
Guérin E, Marquet G, Burgun A, Loréal O, Berti-Equille L, Leser U, et al. Integrating and warehousing
liver gene expression data and related biomedical resources in GEDAW. In: International Workshop on
Data Integration in the Life Sciences. 2005: 158-74. doi: 10.1007/11530084-14.
Pedersen TB, Jensen CS. Research issues in clinical data warehousing. In: Scientific and Statistical
Database Management. IEEE. 1998: 43-52. doi: 10.1109/SSDM.1998.688110.
Pavalam SM, Jawahar M, Akorli FK. Data warehouse based Architecture for Electronic Health Records for
Rwanda. In: Education and Management Technology (ICEMT). IEEE. 2010: 253-5. doi:
1109/ICEMT.2010.5657660.
Banek M, Tjoa AM, Stolba N. Integrating different grain levels in a medical data warehouse federation. In :
International Conference on Data Warehousing and Knowledge Discovery. Springer-Berlin, Heidelberg.
: 185-94. doi: 10.1007/11823728_18.
Olive F, Gomez F, Schott AM, Remontet L, Bossard N, Mitton N. [Critical analysis of French DRG based
information system (PMSI) databases for the epidemiology of cancer: a longitudinal approach becomes
possible]. Rev Epidemiol Sante Publique. 2011; 59(1): 53-8. doi: 10.1016/j.respe.2010.09.001. PMID:
Sebaa A, Tari A, Ramtani T, Ouhab A. DW RHSB: A Framework for Optimal Allocation of Health Care
are Resources. International Journal of Computer Science, Communication & Information Technology.
; 2(1): 12-7.
Published
Issue
Section
License
Copyright (c) 2020 KNOWLEDGE KINGDOM PUBLISHING
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
