e-Blood

The project consisted of migrating and normalizing medical data collected at 24 Regional Blood Donation and Hematology Center facilities into the e-Blood system.

Client:

Industry:

Technologies:

5.6 million

personal files

5.2 million

donors

8 million

addresses

The area of activity of the e-Health Centre (CeZ) is the development of health care information systems. The National Health Fund (NFZ) is a state-run universal health care system.

What was the business need?

24 facilities (Regional Blood Donation and Hemorrhage Centers) used several different systems for daily operations. They did not exchange information with each other and had many non-standardized processes and dictionaries.

Each facility was tasked with managing information on people who donated blood and underwent laboratory testing. In addition, they had to keep records of blood samples and materials collected (donated to hospitals). The law requires employees of the Centers to create and store such information. However, with each facility having an individual system, data often gets lost, duplicated, or impossible to verify.

Another obstacle to proper functioning was the fact that information on donors or patients were not properly completed, often fudged, and did not have a standardized structure. This caused a lack of central reports and a disorder in hospitals, making it impossible in critical situations to verify inventories and order blood for patients in need.

The client needed a solution that would integrate all the systems of the 24 facilities into one central IT unit that would oversee the flow of information and make data available to all Centers.

What was the challenge?

Operations on multi-million-dollar datasets (more than 6 million records) and great responsibility in transforming personal and medical data.

The information stored in the facilities had been a permanent part of the databases
for more than 20 years. The first task was to gather data from various systems and databases, which, as it turned out, had no fixed structure. Some databases were also encrypted, making the job more difficult and lengthy.

It was necessary to integrate with the data provider and develop a process for extracting and decrypting the data.

Since the current systems were not working properly, blood donor or patient data had no validation. Names, phone numbers, addresses, or PESEL numbers were impossible to verify.

The biggest challenge was sorting out the data relevant to the Polish health service. Incorrect blood markings, phenotypes, or migration errors could cause catastrophic consequences for patients waiting for help.

What was the solution?

Lots of consultations, data analysis, and making the client and facilities aware of the chaos we are dealing with.

  1. We created a system that could obtain data from all regional units.
  2. Test migrations were successfully performed for most of the provided data.
  3. Scripts were implemented to transform the data to the e-Blood model throughout the expected range of migrations.
  4. An application for transforming information in the form of XML files into an intermediate database the structure was created, which made it possible to perform the migration process to the e-Blood structure on the collections.

Data migration in the e-Blood project involves taking data from source systems (different structures and different database engines such as DB2, Gupta, PostgreSQL) and then, with analytical support, normalizing the data for input into the common new model of the emerging e-Blood application.

What did the client get?

  • Centralization of all medical data on blood donation, which allowed a smooth flow of information between facilities across the country.
  • Arrangement of information and the ability to correctly issue authorizations for honorary blood donors.

  • Reduction of data migration time from several hours to 1.5 hours.
  • Additional technical and technological capabilities offered to the client by expanding knowledge in optimizing database engines.

  • Accelerated working time for operators of the Regional Blood Donation and Hematology Center.

Are you interested in our services?

If you are interested in custom software design and development services, please contact our experts.

Together we will assess which of the SOFTIQ team’s competencies will support your project.

See also

Large Family Card

Customer: Ministry of Family and Social Policy
Industry: Services
An application for entering, verifying applications, and issuing decisions on granting the Large Family Card.

GIS – Chief Sanitary Inspectorate

Customer: GIS – Chief Sanitary Inspectorate
Industry: Services
Design and implementation of the various modules of the government's SEPIS (State Sanitary Inspection Record System).

ACM – Aflos & Crew Management

Customer: Aflos & Crew Management B.V.
Industry: Industry
Aflos & Crew Management B.V. is a Dutch company specialising in the recruitment and management of crews for inland shipping.
Szukasz zespołu IT do swojego projektu? Sprawdź, jak wybrać najlepszy modelu współpracy i odpowiedniego partnera! Pobierz e-book