Autonomic care platform for optimizing query performance

BMC Medical Informatics and Decision Making

Research Article

Filip De Turck¹  Kristof Steurbaut¹  Johan Decruyenaere²  Steven Latré³ 

[1] Department of Information Technology, Ghent University - iMinds Gaston Crommenlaan 8 Bus 201, 9050, Gent, Belgium;Department of Intensive Care, Ghent University Hospital, De Pintelaan 185, 9000, Gent, Belgium;Department of Mathematics and Computer Science, University of Antwerp - iMinds, Middelheimlaan 1, 2020, Antwerp, Belgium;

关键词: Execution Time;    Control Loop;    Resource Description Framework;    Query Execution;    Average Execution Time;   

DOI  :  10.1186/1472-6947-13-120

 received in 2013-02-22, accepted in 2013-10-16,  发布年份 2013

来源: Springer

【 摘 要 】

BackgroundAs the amount of information in electronic health care systems increases, data operations get more complicated and time-consuming. Intensive Care platforms require a timely processing of data retrievals to guarantee the continuous display of recent data of patients. Physicians and nurses rely on this data for their decision making. Manual optimization of query executions has become difficult to handle due to the increased amount of queries across multiple sources. Hence, a more automated management is necessary to increase the performance of database queries. The autonomic computing paradigm promises an approach in which the system adapts itself and acts as self-managing entity, thereby limiting human interventions and taking actions. Despite the usage of autonomic control loops in network and software systems, this approach has not been applied so far for health information systems.MethodsWe extend the COSARA architecture, an infection surveillance and antibiotic management service platform for the Intensive Care Unit (ICU), with self-managed components to increase the performance of data retrievals. We used real-life ICU COSARA queries to analyse slow performance and measure the impact of optimizations. Each day more than 2 million COSARA queries are executed. Three control loops, which monitor the executions and take action, have been proposed: reactive, deliberative and reflective control loops. We focus on improvements of the execution time of microbiology queries directly related to the visual displays of patients’ data on the bedside screens.ResultsThe results show that autonomic control loops are beneficial for the optimizations in the data executions in the ICU. The application of reactive control loop results in a reduction of 8.61% of the average execution time of microbiology results. The combined application of the reactive and deliberative control loop results in an average query time reduction of 10.92% and the combination of reactive, deliberative and reflective control loops provides a reduction of 13.04%.ConclusionsWe found that by controlled reduction of queries’ executions the performance for the end-user can be improved. The implementation of autonomic control loops in an existing health platform, COSARA, has a positive effect on the timely data visualization for the physician and nurse.

【 授权许可】

Unknown   
© Steurbaut et al.; licensee BioMed Central Ltd. 2013. This article is published under license to BioMed Central Ltd. This is an Open Access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/2.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.