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).