-
-
Graph Database design
-
-
Inspiration
New Technologies, unpredicted global pandemic, countless helpless Covid patients, etc, What can I do? The only thing I can do, besides sitting at home, is to build something to fight back, using the most advanced technologies, that's the reason I am trying to build a centralized website for medical organizations, pharmaceutical companies, doctors, patients to communicate the latest development on the drug development for coronavirus.
What it does
My health system is a full fledged health system for patients, doctors, hospital administors, medical researchers, to record, track,analyze medical data. you can use this system to register patient, make an appointment, assign doctors for the appointment, and also prescribe treatment, click patients to view patients list.
Our health system is also a good machine learning system. It can detect any discrepancies in the treatments based on knowledge based data. It immediately shows that antibiotics are appropriate for the fever, Remdesivir is of no use here, and the patient’s stroke does not have any treatment. Big data is much more helpful for collecting data to improve our system automatically.
How I built it
For most accessible for the maximum population on earth, I figured that a web site is the most convenient tool. Therefore I built a web site for this project.
The first step is ETL (Extract, Transform, Load). I integrated data from different sources, different formats, into a normalized central database.
After that, I use database first design model to convert all database tables, views, into c# entity objects.
The 3rd step is write c# code for all adding, listing, updating, deleting operations,
the final step is to build the whole website based on this model.
Challenges I ran into
First challenge is the Data integration, how to integrate different data from different sources, and normalized them
2nd challenge is the Accuracy vs Speed. Traditional OLTP keeps the data integrity but slow, NoSQL is fast but integrity broken down. I solve this dilemma in design, to use OLTP for ACID operations, while use NoSQL for reporting
3rd challenge is to make web pages more user friendly, I’m still working on user interface engineering to maximize usability and the user experience
Accomplishments that I'm proud of
My website is not a prototype, not a toy. It's a full fledged running application with huge real data collected. I hope some people will benefit from it
https://healthsystem.jackwu.us
What I learned
I learnt how to develop software for the best benefit of people fighting the global pandemic.
What's next for Big Data and Machine Learning in Health System
I will add more functionalities, and scale out.
Two more videos to share:
Functionalities:
- click the Studies page to insert new Studies, view existing Studies and search studies based on its
- click the Appointments page to make a new appointment, view and change existing appointments
- click the Diagnoses page to insert new Diagnose, view existing Diagnoses and their studies
- click the Check Treatments page to check whether you missing any treatment or wrong prescriptions
- I have collected almost all clinical studies for Covid-19, they perform clinical trials world wide, if you want to check all the studies in your country or city, just go to the Countries page or the Cities page, on the search box entering your country name or city name, then click the search, to find your country or city. You will see all the studies on your city, click each study name to see details about the study. If you have Covid-19 symptoms looking for new treatment, you can use my system to find the studies suitable to your location, age, gender, and symptoms
- and more and more .......
- click all the new Diagnostic Tests for Covid-19
- click all the new drugs for Covid-19
- click all the new Biological Interventions for Covid-19
- click all the new Procedures for Covid-19
- and more, just find yourself
Built With
- big-data
- mvc
- sql
- vs.net
Log in or sign up for Devpost to join the conversation.