DBMS meets DSMS - Towards a Federated Solution

Andreas Behrend, Dieter Gawlick, Daniela Nicklas


In this paper, we describe the requirements and benefits for integrating data stream processing with database management systems. Currently, these technologies focus on very different tasks; streams systems extract instances of patterns from streams of transient data, while database systems store, manage, provide access to, and analyze persistent data. Many applications, e.g., patient care, program trading, or flight supervision, however, depend on the functionality and operational characteristics of both types of systems. We discuss how to design a federated system which provides the benefits of both approaches.


  1. Abadi, Daniel J., Don Carney, Ugur Çetintemel, Mitch Cherniack, Christian Convey, Sangdon Lee, Michael Stonebraker, Nesime Tatbul, and Stan Zdonik. 2003. “Aurora: A New Model and Architecture for Data Stream Management.” The VLDB Journal 12 (2).
  2. Arasu, A., S. Babu, and J. Widom. 2006. “The CQL Continuous Query Language: Semantic Foundations and Query Execution.” The VLDB Journal 15 (2)
  3. Babcock, Brian, Shivnath Babu, Mayur Datar, Rajeev Motwani, and Jennifer Widom. 2002. “Models and Issues in Data Stream Systems.” In PODS'02, 1. Madison, Wisconsin.
  4. Biem, Alain, Eric Bouillet, Hanhua Feng, Anand Ranganathan, Anton Riabov, Olivier Verscheure, Haris Koutsopoulos, and Carlos Moran. 2010. “IBM Infosphere Streams for Scalable, Real-time, Intelligent Transportation Services.” In SIGMOD'10. ACM.
  5. Guerra, Diogo, Ute Gawlick, Pedro Bizarro, and Dieter Gawlick. 2011.“ An Integrated Data Management Approach to Manage Health Care Data.” In BTW, 596- 605.
  6. Gyllstrom, D., E. Wu, H. J Chae, Y. Diao, P. Stahlberg, and G. Anderson. 2007. “Sase: Complex Event Processing over Streams.” In Proceedings of the Third Biennial Conference on Innovative Data Systems Research, Asilomar.
  7. Kennedy, Oliver, Yanif Ahmad, and Christoph Koch. 2011. “DBToaster: Agile Views for a Dynamic Data Management System.” In Cidr, 284-295.
  8. Kx Systems. 2010. “Kdb+ White Paper.” http://kx.com/ papers/Kdb+_Whitepaper-2010-1005.pdf.
  9. Schüller, Gereon, Roman Saul, and Andreas Behrend. 2012. “AIMS: A Tool for the View-Based Analysis of Streams of Flight Data.” In SSDBM (accepted).
  10. StreamBase Systems. 2012. “StreamSQL Guide, StreamSQL Online Documentation.” http://streambase .com/developers/docs/latest/streamsql/index.html.

Paper Citation

in Harvard Style

Behrend A., Gawlick D. and Nicklas D. (2012). DBMS meets DSMS - Towards a Federated Solution . In Proceedings of the International Conference on Data Technologies and Applications - Volume 1: DATA, ISBN 978-989-8565-18-1, pages 157-162. DOI: 10.5220/0004122501570162

in Bibtex Style

author={Andreas Behrend and Dieter Gawlick and Daniela Nicklas},
title={DBMS meets DSMS - Towards a Federated Solution},
booktitle={Proceedings of the International Conference on Data Technologies and Applications - Volume 1: DATA,},

in EndNote Style

JO - Proceedings of the International Conference on Data Technologies and Applications - Volume 1: DATA,
TI - DBMS meets DSMS - Towards a Federated Solution
SN - 978-989-8565-18-1
AU - Behrend A.
AU - Gawlick D.
AU - Nicklas D.
PY - 2012
SP - 157
EP - 162
DO - 10.5220/0004122501570162