Itransition developed a custom defibrillator database that provides medical professionals with up-to-date information on defibrillators’ availability and location.
Custom database development for a healthcare charity
Our customer is a European healthcare charity and research organization. From the start, they have been raising funds to cure patients with cardiovascular diseases, conduct research, as well as nurture the population’s awareness of the heart and circulatory conditions in order to prevent them. The organization also provides advisory support to help people understand their conditions and choose optimal treatment programs via multiple channels, including a dedicated website, booklets, and a 24/7 helpline.
The organization believes that using a defibrillator is a lifesaving measure when used by those who witness an out-of-hospital-cardiac-arrest (OHCA) or notices an affected person. Still, there are two critical barriers limiting the use of publicly available defibrillators: people know neither how a defibrillator works nor where defibrillators are located. As a result, the devices are underutilized while they could save many lives.
Having studied the situation in their country, our customer revealed a disturbing fact: emergency and medical service representatives were also unaware of defibrillators’ locations.
While every ambulance service was responsible for mapping the location of defibrillators within their own jurisdictions, there were several barriers to actually doing so:
With all these challenges in mind, our customer decided to go for custom database development and create a unified information hub on defibrillators. This would be used by medical service professionals to provide the exact location of the nearest defibrillator to people who happen to be near a person during an OHCA. Such a solution would facilitate urgent defibrillation and contribute to the increase in OHCA survival rates.
Itransition offered their experience in healthcare software development to carry out the project.
The delivered solution is a custom defibrillator database that provides up-to-date information about publicly available defibrillators. The solution was designed as a mobile-friendly web application.
The system serves three groups of users, with each group having their own tailored interface and access permissions:
The solution offers the following capabilities:
Once a user registers a defibrillator, they can provide details on a defibrillator’s location (e.g., the building floor and open hours) and availability, as well as access type (public or restricted, etc.). Users can also log maintenance checks and their outcomes for defibrillator guardians to set a defibrillator status as “in service” or “out of service”. Guardians can also retire a device, stopping its use and maintenance.
The web application contains the dashboard for administrators to see the current state of both operational and out-of-service defibrillators, as well as devices used within the last week during OHCAs. The dashboard also provides information on defibrillators that have been out of service for more than a week, two weeks, and a month.
Administrators can view reports on all defibrillators and download them as PDF files. They can also access reports in the accounts of all the guardians within their medical service area.
The system maintains the communication log and presents all location details in a structured way. It also supports different types of notifications, including email alerts, reminders, and warnings.
To facilitate data exchange and maintenance, Itransition’s team implemented the following features:
To ensure data interoperability, Itransition set up regular data synchronization directly between the central defibrillator database and the local ambulance services’ Computer-aided dispatch (CAD) systems. The synced data is accessible to ambulance service dispatchers via the interactive map that localizes every OHCA and the nearest available defibrillator in real time.
The delivered solution consists of three main parts:
Microsoft Azure was used to host all the solution components. All the web services are hosted in the Azure App Service. The data is stored in the Azure SQL-based database. We utilized Azure Table and Azure Blob as a replicated and encrypted storage of binary data, such as images. Our team used REST API to integrate the solution with the CAD system.
We leveraged Azure Application Insights, Azure Alerts, and Azure Monitor to automate the processing of all the operational metrics in the solution. Azure Data Factory hosts long-running background tasks.
Azure Active Directory B2C enables user registration, account management, and authentication, including password reset, optional two-factor authentication, and multi-factor authentication for advanced security. This cloud service comes packed with machine learning algorithms to analyze login patterns and minimize the risk of hacking.
We used the Azure Service Bus queues to set up notifications. Messages are put on the Service Bus queue and then delivered to Azure Functions that push notifications through the appropriate gateway. Azure Functions pick up email notification messages, compose emails, and send them via the Mailjet SMTP gateway. Azure Functions are also responsible for the asynchronous processing of uploaded batch data.
We used Azure DevOps Services to configure CI/CD processes.
As part of this custom database development, Itransition integrated the solution with the following third-party services:
At the start of the custom database development, we held an initial workshop with the customer to:
Our development team collaborated with the customer ongoingly, reviewing requirements and prioritizing backlog items. At the end of each iteration, we carried out sprint retrospectives where we identified areas for improvement.
By the end of this custom database development project, Itransition’s team delivered a comprehensive solution that is critical for healthcare professionals to save lives during OHCAs. With this solution, the customer established the new national standards of defibrillator management and maintenance.
The solution combines data on nearly 100,000 defibrillators accessible throughout the country, therefore providing medical service professionals with comprehensive up-to-date information on the defibrillators available within their local area.
Healthcare cloud computing has gained momentum amidst the 2020 pandemic. But is it a steady trend or a temporary solution? Read on to learn more.
AR in healthcare is making headlines by transforming invasive procedures, ADT processes, medical training, and post-discharge support for patients.
We discuss several approaches to healthcare data security during the pandemic and offer some tips to ensure it. Read on to learn more.
Maximus Inc. leverages Itransition’s expertise to handle their insurance management platform development.
Expedia teamed up with Itransition to revamp the Expedia Affiliate Network solution to redeem the leading position and boost revenues.
We take a look at varied healthcare mobile apps, connected devices, and overall industry trends to shape the mobile healthcare roadmap.
Learn about the role of online analytical processing OLAP in a data warehouse and how it helps organizations to improve their decision-making.