Towards an Integrated Approach to Monitor and Analyse Health Care Data using Relational Databases

Philip Schmiegelt, Jingquan Xie, Gereon Schüller, Andreas Behrend

Abstract

In modern patient monitoring systems a tremendous amount of data is gathered, stored, and analysed to support doctors in making important decisions in a timely manner. To this end, different types of data from different sources have to be processed such as sensor readings of patients vitals, meta-data like the age and weight of a patient, and historical data like performed treatments or therapies. Most of the data is low-level and has an intrinsically temporal nature which need to be preprocessed for doctors to find high-level information in an efficient way. In monitoring scenarios however, aside from the detection of critical situations of patients, medics are often interested in the phases in which their patients are most probably in. In this paper, we show how phase analysis can considerably reduce the syntactic complexity of continuous queries as provided by the Continuous Query Language (CQL). Such phases provide an advanced and higher level of abstraction enabling effective and intuitive formulation of queries comparing to classic CQL. This can greatly improve the development efficiency and reduce the maintenance complexity of patient monitoring system.

References

  1. Abadi, D. J., Carney, D., C¸etintemel, U., Cherniack, M., Convey, C., Lee, S., Stonebraker, M., Tatbul, N., and Zdonik, S. (2003). AURORA: a new model and architecture for data stream management. The VLDB Journal, 12(2):120-139.
  2. Cadonna, B., Gamper, J., and Böhlen, M. H. (2011). Sequenced Event Set Pattern Matching. pages 33-44, New York, NY, USA. ACM.
  3. Chen, J., DeWitt, D. J., Tian, F., and Wang, Y. (2000). NiagaraCQ: A Scalable Continuous Query System for Internet Databases. In SIGMOD, pages 379-390, New York, NY, USA. ACM.
  4. Gawlick, D., Ghoneimy, A., and Liu, Z. H. (2011). How to build a modern patient care application. In HEALTHINF, pages 427-432.
  5. Guerra, D., Gawlick, U., Bizarro, P., and Gawlick, D. (2011). An Integrated Data Management Approach to Manage Health Care Data. In BTW, pages 596-605.
  6. Krämer, J. and Seeger, B. (2004). PIPES - A Public Infrastructure for Processing and Exploring Streams. In SIGMOD, pages 925-926.
  7. Lehman, L., Kyaw, T., Clifford, G., and Mark, R. (2007). A Temporal Search Engine for a Massive MultiParameter Clinical Information Database. In Computers in Cardiology, 2007, pages 637 -640.
  8. Liu, Z. H., Behrend, A., Chan, E., Gawlick, D., and Ghoneimy, A. (2012). Kids - a model for developing evolutionary database applications. In DATA, pages 129-134.
  9. Luckham, D. (2002). The Power of Events: An Introduction to Complex Event Processing in Distributed Enterprise Systems. Addison-Wesley, 1st edition.
  10. Rozsnyai, S., Schiefer, J., and Roth, H. (2009). SARI-SQL: Event Query Language for Event Analysis. In CEC, pages 24-32.
  11. Schüller, G., Behrend, A., and Manthey, R. (2010). AIMS: An SQL-based System for Airspace Monitoring. In IWGS, pages 31-38, New York, NY, USA. ACM.
  12. Schüller, G., Schmiegelt, P., and Behrend, A. (2012). Supporting Phase Management in Stream Applications. In ADBIS, pages 332-345.
  13. Shortliffe, E. H. (1976). Computer-Based Medical Consultations: MYCIN. Annals of Internal Medicine, 85(6):831-831.
  14. Snodgrass, R. T., editor (1995). The TSQL2 Temporal Query Language. Kluwer.
Download


Paper Citation


in Harvard Style

Schmiegelt P., Xie J., Schüller G. and Behrend A. (2013). Towards an Integrated Approach to Monitor and Analyse Health Care Data using Relational Databases . In Proceedings of the International Conference on Health Informatics - Volume 1: HEALTHINF, (BIOSTEC 2013) ISBN 978-989-8565-37-2, pages 407-412. DOI: 10.5220/0004326204070412


in Bibtex Style

@conference{healthinf13,
author={Philip Schmiegelt and Jingquan Xie and Gereon Schüller and Andreas Behrend},
title={Towards an Integrated Approach to Monitor and Analyse Health Care Data using Relational Databases},
booktitle={Proceedings of the International Conference on Health Informatics - Volume 1: HEALTHINF, (BIOSTEC 2013)},
year={2013},
pages={407-412},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0004326204070412},
isbn={978-989-8565-37-2},
}


in EndNote Style

TY - CONF
JO - Proceedings of the International Conference on Health Informatics - Volume 1: HEALTHINF, (BIOSTEC 2013)
TI - Towards an Integrated Approach to Monitor and Analyse Health Care Data using Relational Databases
SN - 978-989-8565-37-2
AU - Schmiegelt P.
AU - Xie J.
AU - Schüller G.
AU - Behrend A.
PY - 2013
SP - 407
EP - 412
DO - 10.5220/0004326204070412