We, Egyptians, as a developing country, don't have a well established one private communication channel among all country hospitals, so there is always a delay in reporting last updates; However, this period fast and easy communication among all the health sectors is crucial, and many remote hospitals suffers from shortages and can't request supplies easily, and With the expectation that the number of COVID-19 patients will increase exponentially over the next period, We decided to harness our computer science knowledge to help our beloved country, and all the developing countries, to find a fast and ready to impact solution.

What it does

The product aims to create a Centralized Hospital System that creates a communication channel between the Ministry of Health and Hospitals. It is intended to provide daily updates to the Ministry of Health of the status of each hospital from the counts of patients to number of free beds and available supplies. In addition, it is aimed to provide a method for hospitals to request medical supplies to deal with possible shortages. This system is intended to run in parallel to already existing systems to decrease time needed for integration.

How I built it

We utilized MERN stack due to various reasons, first, for the backend Nodejs offers a very high IO performance compared to competitors and this project doesn't involve CPU intensive tasks in addition to the rapid development that can be done in Nodejs and the flexibilty offered by MongoDB in changing database design. Secondly, for the frontend we used Reactjs to design the frontend features. As for our timeline we first refined our problem and how we intend to solve it technically, then we split the tasks into backend tasks and frontend tasks. From the second day on wards we split the tasks into milestones to be able to track our progress. We then started rapidly developing the system while making sure to re-check our direction after each milestone until completion

Challenges I ran into

  1. Each hospital is using a different ERP system. So, As a team we decided that our product should not replace existing systems as a “One size fits all” model will not work across all the departments in a hospital. Moreover, it will require a lot of time to migrate from existing systems to new one. We also believe that it is better to not try to integrate with existing systems at the moment as this emergency system is put in place to handle the crisis we can face soon. The process of integrating with existing systems will require understanding the architecture of each hospital and create separate middleware. We believe that this is too time consuming and will lead to privacy concerns. That is the reason why at the moment we are trying to provide the minimum amount of information that the Ministry of Health needs to create a plan of action based on data while mitigating possible privacy concerns.

  2. We needed to get the daily final numbrr of patients/supplies for each hospital, while we only stored the current counts so we had to use “CRON jobs”. Building "CRON jobs" to be run periodically to be able to graph the number of patients progression with each day and in choosing the update time of these jobs, for the jobs we utilized Javascripts setInterval and setTimeout methods.

Accomplishments that I'm proud of

in just 2 days we as a team managed to build a a fully functioning application that is ready to be used by the government, we are proud that we cut time off our lives to help the health sector of our beloved country.

What I learned

Beside, all the technical challenges we have faced and managed to reach a solution for, we have learned how to work efficiently in a very short time, managed our time. and also realized that giving all our effort and knowledge to help the public is priceless.

What's next for Centralized Health system

  1. build a middleware that maps all the currently working ERPs in different hospitals to our database system
  2. Apply more data analytics on the collected database for each country which will be country specific and helps them independently to gain insights of their own Covid-19 cases.
  3. Open a channel for public donors to all the hospitals suffering from shortages.
Share this project: