Talk to an expert

About the case study

Affiliated with the University of Toronto, The Hospital for Sick Children (SickKids) is Canada’s most research-intensive hospital and largest centre dedicated to the improvement of children’s health in the country. By staffing professionals from all disciplines within both health care and research.


section1
The auto industry is evolving

The auto industry is evolving. How vehicles are bought, sold and financed is also changing. One constant: the industry and its various markets continue to trust Canadian Black Book insight and its innovative delivery systems to make the right business decisions faster.

About the case study

https://dev.translucentcomputing.com/wp-content/uploads/2022/09/section1.png

Affiliated with the University of Toronto, The Hospital for Sick Children (SickKids) is Canada’s most research-intensive hospital and largest centre dedicated to the improvement of children’s health in the country. By staffing professionals from all disciplines within both health care and research.

The auto industry is evolving

The auto industry is evolving. How vehicles are bought, sold and financed is also changing. One constant: the industry and its various markets continue to trust Canadian Black Book insight and its innovative delivery systems to make the right business decisions faster.

Overview

Industry

Industry

Automotive Industry

Companysize

Company size

50 to 500

Location

Location

Toronto – Ontario

Keystats

Key stats

  • • 400M ES documents

    • 30-40 properties in each ES document mapping

    • 15B data elements imported

    • 40 import asynchronous jobs (run time: 5 m to 30 h)

    • Jobs combined paper mapping, electronic file, and a database dump

ProjectAreas

Project Areas

Full Digital Transformation

  • • Microservices

    • DevOps

    • Machine Learning

Combine process and cloud native development

Let us help you too Let's talk
canadian

The Challenge

SickKids decommissioned an electronic medical chart application (CIMS) which ran in the Neonatal, Pediatric and Cardiac Intensive Care Units since 1999.

The hospital now requires the migration of billions of records from CIMS to a new system that will allow physicians and researchers to find, examine and analyze this complex data.

Data defragmentation
Data defragmentation

CIMS data was stored in multiple file sources, including flat text files, mapping text files, b-tree file structures, and oracle database data extracts with over 1000 tables.

dataVolume
Data volume

Billions of records stored over 20 years for over 50,000 patients needed to be reindexed in a new system with novel requirements such as sub-second searching, data analytics, reporting and metrics.

mappings
Mappings

Manual cross mapping between text files, b-tree records, and database extract:

icon file1000’s of text files
icon file50,000+ Patients
icon file400,000,000+ Patients raw data
icon file2,000,000,000+ eletrônic chart inputs
infoStructure
Infostructure

Only single VM was available to process and import all data. TC ES exports had to fine tune the ES to make sure the system would import data without running out of memory which was a challenge to accomplish.

The hospital now requires the migration of billions of records from CIMS to a new system that will allow physicians and researchers to find, examine and analyze this complex data.

  • Data defragmentation

    Data defragmentation

    CIMS data was stored in multiple file sources, including flat text files, mapping text files, b-tree file structures, and oracle database data extracts with over 1000 tables.

  • dataVolume

    Data volume

    Billions of records stored over 20 years for over 50,000 patients needed to be reindexed in a new system with novel requirements such as sub-second searching, data analytics, reporting and metrics.

  • mappings

    Mappings

    Manual cross mapping between text files, b-tree records, and database extract:

    icon file1000’s of text files
    icon file50,000+ Patients
    icon file400,000,000+ Patients raw data
    icon file2,000,000,000+ eletrônic chart inputs
  • infoStructure

    Infostructure

    Only single VM was available to process and import all data. TC ES exports had to fine tune the ES to make sure the system would import data without running out of memory which was a challenge to accomplish.

The Solution

The Solution

Digital Transformation

MICROSERVICES | DEVOPS | MONITORING

iconcheck

See how we indexed, analyzed and transformed half a billion records of Neonatal Intensive Care Unit data for Sick Kids Hospital.

Given the complexity of the challenge Translucent broke up the project in to 4 phases:

TC Consultants carefully mapped out the whole system in 40+ excel import files that combine layouts, labels and groups from a flat file, complex cross functional lookups between text files and DB lookups

Is your company still using hand tools?

These import files were the bases for system import

TC engineers created asynchronous importers that executed up to 30 hours

Is your company still using hand tools?

The importer used the mappings and DB data dump from the old system to construct ES documents

Careful testing was done by TC team to match the old system with the new system.

Is your company still using hand tools?

SK team is now using the system for searching patients for data lookups.

SK Research team is using the system to chart, graph and data mind the system.

Kibana is one of tools used for dashboards.

Given the complexity of the challenge Translucent broke up the project in to 4 phases:
  • Is your company still using hand tools?

    1. Mapping

    TC Consultants carefully mapped out the whole system in 40+ excel import files that combine layouts, labels and groups from a flat file, complex cross functional lookups between text files and DB lookups

    These import files were the bases for system import

    mapping
  • #

    2. Importing

    TC engineers created asynchronous importers that executed up to 30 hours

    The importer used the mappings and DB data dump from the old system to construct ES documents

    data_process
  • Is your company still using hand tools?

    3. Testing

    Careful testing was done by TC team to match the old system with the new system.

    testing
  • #

    4. Searching and Analytics

    SK team is now using the system for searching patients for data lookups.

    SK Research team is using the system to chart, graph and data mind the system.

    Kibana is one of tools used for dashboards.

TheResults

The Results

A new Electronic Medical Chart Platform based on data transformation, mapping and migration of billions of charts inputs from legacy electronic medical chart application (CIMS).

New electronic charts allow physicians and researchers to find 20 years of historical patient data with sub second searching, analytics and reporting.

A new Electronic Medical Chart Platform
The Digital Transformation

The Digital Transformation is the newv Industrial Revolution. Is your company still using hand tools?

we'll find a solution for you