Expediting assessments of database performance for streams of respiratory parameters. (1st September 2018)

• Record Type: Journal Article
• Authors: Gillan, Charles J.; Novakovic, Aleksandar; Marshall, Adele H.; Shyamsundar, Murali; Nikolopoulos, Dimitrios S.
• Is Part Of: Computers in biology and medicine. Volume 100(2018)
• Page Start: 186
• Page End: 195
• Publication Date: 2018-09-01
• Subjects: Database -- Metrics -- Performance -- ICU -- Respiration -- IoT; Medicine -- Data processing -- Periodicals; Biology -- Data processing -- Periodicals; 610.285
• DOI: 10.1016/j.compbiomed.2018.05.028
• Languages: English
• ISSNs: 0010-4825

Abstract

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.