Dean Yergens
  • Home
    • Calendar
    • Resume
    • Publications
  • Software
    • Synthesis >
      • Current Version
      • Synthesis Tutorials
    • RMail
    • Meta Data Repository
    • Patient-X
    • WebReports
    • HealthSim Calendar Gadget
    • MT4Health
    • Amazon ISBN 2 BibTex
    • ForestRanger
    • Alberta Sepsis Network
    • R Code
  • Global Health
    • Software
    • Philippines
    • Malawi
    • Zambia
    • Kenya
    • World Health Organization
    • Verbal Autopsy
    • Space Medicine
  • Computer Science
    • Robotics
    • Data Management
    • GPU Parallel Processing
    • Machine Learning
    • Visualization
    • Operating Systems
    • Programming Languages
    • Software Engineering
    • Simulations
    • Computer Configurations
    • Single Board Computers
    • IEEE RSS Feed
    • Glossary
    • Commercial Software Blog
  • Health Sciences
    • AI Walkthrough
    • Canadian Health System Books
    • Microsimulation
    • Graph Databases (Neo4J)
    • Administrative Data
    • CCHS Overview
    • Literature Reviews >
      • Newspaper Literature Reviews
      • Open Access
      • Statistics Utilization
      • Topic Modeling
      • Utilizing R for Literature Reviews
    • Statistics >
      • RMedicine (RClub) >
        • Blog
        • Forums
    • Health Informatics >
      • DataMergeR
      • Dashboards
      • Academic Software Development
      • Critical Care Systems
      • Patient Flow >
        • Patient Flow Simulations
        • Systems
      • HL7
    • Online Courses
    • Public Health Documentaries
    • Summer Institutes
    • WHO Internships
    • Conferences
  • Collection
    • Hardware
    • Software
    • Looking for
    • Analog Computers
    • Old Monitor Projects
    • Computer Books and Software
    • 3D Models
    • FrostByte
    • New Devices Vintage Computers
    • Floppy Music
    • History of Workstations
  • Other
    • Future Projects
    • Home Automation
    • Animatronics
    • Raspberry Pi
    • Deaner.AI
    • CANMAR
    • EpiComics
    • The Art of Deaner
    • LED Cube 8x8x8
    • Ambient Devices
    • EasyButton
    • African Art
    • Movie Posters
    • Wildlife Photography
    • Coursera
    • Neat Companies
  • Blog

DataMergeR


ICU DataMergeR 

ICU DataMergeR - is a program that assembles large datasets into the 1 patient : 1 row format (1:1).

The dataset is assembled based upon days - such as Day 1, 2, 3, 7, 14, 21

Currently DataMergeR can assemble the following tables:
  • Admissions (1 patient : 1 row)
  • Labs (1 patient : n row)
  • Fluids (1 patient : n row)
  • Vitals (1 patient : 1 row per day)
  • Nursing (1 patient : 1 row per day)
  • TISS (1 patient : 1 row per day)
  • Treatments (1 patient : 1 row per day)


Datasets:

DataMergeR handles the following types of datasets:

1 patient : 1 row (i.e. Admissions table)

1 patient : n row (i.e. Labs, Fluids table)
  • This data needs to be aggregated on a daily basis
  • Aggregation - there are 10 standard aggregation types that can be done is SQL: (count, mean, SD, variance, mode, median, lower quartile, upper quartile, min, max)

1 patient : 1 row per day (i.e. Vitals, Nursing, TISS, Treatments)

Performance:
  • Takes about 90 seconds to assemble 1 Patients worth of data (Day 1, 2, 3, 7, 14, 21)


Outstanding Tasks/Issues:

1 patient : 1 time spanning row (i.e. Pharmacy, Microbiology, Radiology)


First 24 hours, 24-48 hours, 48-72 hours
This would only affect Labs and Pharmacy


Increase/Decrease Values


Performance (how to optimize)





Clinic DataMergeR

Clinic DataMergeR - is a program that assembles clinic data (where the results may be recorded over days, weeks or months).  It then assembles the data into a 1 patient : 1 row format (1:1).