Abstract

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.

 

Keywords: Data warehouse, Health sector, Decision support system
 
» HTML Fulltext    » PDF Fulltext    » doi: 10.19082/4661
BodegaNike

Current Issue

Volume 13, Issue 1, January-March 2021


The worldwide spread of COVID-19 as an emerging, rapidly evolving situation, and the dramatic need of urgent medicine or vaccine, has rapidly brought new hypotheses for pathophysiology and potential medicinal agents to the fore. It is crucial that the research community provide a way to publish this research in a timely manner.

 

To contribute to this important public health discussion, the Electronic Physician Journal is excited to announce a fast-track procedure to help researchers publish their articles on COVID-19 related subjects that fall under the broad definition of public health, internal medicine, and pharmacology. We are especially welcome to all hypotheses about the pathological basis of the COVID-19 infection and the possible characteristics of potential medicine and vaccine. Submit your manuscript here

 


 The  most recent editorial (June 2020)

Lessons from COVID-19 pandemic and the Morocco’s success story.

An editorial by Dr. Benksim Abdelhafid (Morocco)

Read more.


 

The 6th World Conference on Research Integrity (WCRI) is to be held on June 2-5, 2019 in Hong Kong.

The WCRI is the largest and most significant international conference on research integrity. Since the first conference in Lisbon in 2007, it has given researchers, teachers, funding agencies, government officials, journal editors, senior administrators, and research students opportunities to share experiences and to discuss and promote integrity in research. Read more:


 

TDR Clinical Research and Development Fellowships

Call for applications

Deadline for submission: 7 March 2019, 16:00 (GMT)

TDR provides fellowships for early- to mid-career researchers and clinical trial staff (e.g. clinicians, pharmacists, medical statisticians, data managers, other health researchers) in low- and middle-income countries (LMICs) to learn how to conduct clinical trials. Read more:


Meta-Analysis Workshops in New York, USA, and London, UK, in April and May 2019

Don't miss this exceptional opportunity to learn how to perform and report a Meta-analysis correctly. Two Meta-analysis workshops are organized in April and May 2019 by Dr. Michael Borenstein in New York, USA (April 08-10, 2019) and London, UK (May 27-29).

About the Instructor

Dr. Michael Borenstein, one of the authors of Introduction to Meta-Analysis, is widely recognized for his ability to make statistical concepts accessible to researchers as well as to statisticians. He has lectured widely on meta-analysis, including at the NIH, CDC, and FDA. Read more: