Database Functionalities for Evolving Monitoring Applications

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


Databases are able to store, manage, and retrieve large amounts and a broad variety of data. However, the task of understanding and reacting to the data is often left to tools or user applications outside the database. As a consequence, monitoring applications are often relying on problem-specific imperative code for data analysis, scattering the application logic. This usually leads to island solutions which are hard to maintain, give raise to security and performance problems due to the separation of data storage and analysis. In this paper, we identify missing database functionalities which overcome these problems by allowing data processing on a higher level of abstraction. Such functionalities would allow to employ a database system even for the complex analysis tasks required in evolving monitoring scenarios.


  1. Behrend, A., Dorau, C., and Manthey, R. (2009). Sql triggers reacting on time events: An extension proposal. ADBIS.
  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. Chan, E. S., Behrend, A., Gawlick, D., Ghoneimy, A., and Liu, Z. H. (2012). Towards a synergistic model for managing data, knowledge, processes, and social interaction. SDPS.
  4. Das, S. and Srinivasan, J. (2009). Database technologies for rdf. Reasoning Web. Semantic Tech. for Inf. Systems.
  5. Davis, R., Shrobe, H., and Szolovits, P. (1993). What is a knowledge representation? AI magazine, 14(1):17.
  6. Eom, S. B., Lee, S. M., Kim, E., and Somarajan, C. (1998). A survey of decision support system applications (1988-1994). Journal of the Operational Research Society.
  7. Karvounarakis, G., Ives, Z. G., and Tannen, V. (2010). Querying data provenance. Proceedings of the 2010 ACM SIGMOD.
  8. Kawamoto, K., Houlihan, C. A., Balas, E. A., and Lobach, D. F. (2005). Improving clinical practice using clinical decision support systems: a systematic review of trials to identify features critical to success. Bmj, 330(7494):765.
  9. Krämer, J. and Seeger, B. (2004). PIPES - A Public Infrastructure for Processing and Exploring Streams. SIGMOD.
  10. Liu, Z. H., Behrend, A., Chan, E., Gawlick, D., and Ghoneimy, A. (2012). Kids - a model for developing evolutionary database applications. DATA.
  11. Rozsnyai, S., Schiefer, J., and Roth, H. (2009). SARI-SQL: Event Query Language for Event Analysis. CEC.
  12. 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. HealthInf.
  13. Schüller, G., Schmiegelt, P., and Behrend, A. (2012). Supporting Phase Management in Stream Applications. In ADBIS, pages 332-345.
  14. Shortliffe, E. H. (1976). Computer-Based Medical Consultations: Mycin. Artificial intelligence series. America Elsevier Publishing Company, Inc.
  15. Simmhan, Y. L., Plale, B., and Gannon, D. (2005). A survey of data provenance in e-science. ACM Sigmod Record, 34(3):31-36.
  16. Snodgrass, R. T., editor (1995). The TSQL2 Temporal Query Language. Kluwer.
  17. Wieringa, R. J. (2003). Design Methods for Reactive Systems: Yourdon, Statemate and the UML. Morgan Kaufmann Publishers.

Paper Citation

in Harvard Style

Schmiegelt P., Xie J., Schüller G. and Behrend A. (2013). Database Functionalities for Evolving Monitoring Applications . In Proceedings of the 2nd International Conference on Data Technologies and Applications - Volume 1: DATA, ISBN 978-989-8565-67-9, pages 88-96. DOI: 10.5220/0004491000880096

in Bibtex Style

author={Philip Schmiegelt and Jingquan Xie and Gereon Schüller and Andreas Behrend},
title={Database Functionalities for Evolving Monitoring Applications},
booktitle={Proceedings of the 2nd International Conference on Data Technologies and Applications - Volume 1: DATA,},

in EndNote Style

JO - Proceedings of the 2nd International Conference on Data Technologies and Applications - Volume 1: DATA,
TI - Database Functionalities for Evolving Monitoring Applications
SN - 978-989-8565-67-9
AU - Schmiegelt P.
AU - Xie J.
AU - Schüller G.
AU - Behrend A.
PY - 2013
SP - 88
EP - 96
DO - 10.5220/0004491000880096