Expediting assessments of database performance for streams of respiratory parameters

Comput Biol Med. 2018 Sep 1:100:186-195. doi: 10.1016/j.compbiomed.2018.05.028. Epub 2018 Jun 1.

Abstract

A new methodology is proposed to compare database performance for streams of patient respiratory data from patients in an intensive care unit. New metrics are proposed through which databases may be compared both for this and similar streaming applications in the domain of the Internet of Things. Studies are reported using simulated patient data for four freely available databases. The statistical technique of non-parametric bootstrapping is used to minimise the total running time of the tests. We report mean values and bias corrected and accelerated confidence intervals for each metric and use these to compare the databases. We find that, among the four databases tested, ScaleDB is an optimum database technology when handling between 200 and 800 patients in this application, while PostgreSQL performs best outside of this range. Comparing the non-parametric bootstrapping method to a complete set of tests shows that the two approaches give results differing by a few percent.

Keywords: Database; ICU; IoT; Metrics; Performance; Respiration.

Publication types

  • Comparative Study
  • Research Support, Non-U.S. Gov't

MeSH terms

  • Critical Care / methods*
  • Databases, Factual*
  • Humans
  • Intensive Care Units
  • Respiratory Mechanics*