Combining Relational and NoSQL Database Systems for Processing Sensor Data in Disaster Management

  • Reinhard StumptnerEmail author
  • Christian Lettner
  • Bernhard Freudenthaler
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 9520)


In disaster and emergency management the integration of different kinds of sensor networks gains in importance and consequently more and more data becomes available. The upcoming NoSQL database systems are flexible and scalable data stores, but up to now lacking in connectivity to traditional data processing systems (data warehouses, business intelligence suites, etc.). Due to that in this work a combined relational and NoSQL data processing approach is proposed to reduce data volume and work load of the relational part and enable the integral solution to process huge amounts of data. In contrast to fully NoSQL-based data warehouse systems, this approach does not face compatibility and integrability issues.



The research leading to these results has received funding from the ERA-NET EraSME program under the Austrian grant agreement No. 836684, project “INDYCO - Integrated Dynamic Decision Support System Component for Disaster Management Systems” and has been supported by the COMET program of the Austrian Research Promotion Agency (FFG).


  1. 1.
    Cattell, R.: Scalable SQL and NoSQL Data Stores. SIGMOD Rec. 39(4), 12–27 (2011)CrossRefGoogle Scholar
  2. 2.
    Chai, H., Wu, G., Zhao, Y.: A document-based data warehousing approach for large scale data mining. In: Zu, Q., Hu, B., Elçi, A. (eds.) ICPCA 2012 and SWS 2012. LNCS, vol. 7719, pp. 69–81. Springer, Heidelberg (2013)CrossRefGoogle Scholar
  3. 3.
    Chodorow, K., Dirolf, M.: MongoDB - The Definitive Guide: Powerful and Scalable Data Storage. O’Reilly, Sebastopol (2010)Google Scholar
  4. 4.
    He, M. T. Gudyka: Build a Metadata-Driven ETL Platform by Extending Microsoft SQL Server Integration Services. SQL Server Technical Article. -, (2008)Google Scholar
  5. 5.
    Krishnan, K.: Data Warehousing in the Age of Big Data. Morgan Kaufmann Publishers Inc., San Francisco (2013)Google Scholar
  6. 6.
    Parker, Z. et al.: Comparing NoSQL MongoDB to an SQL DB. Proceedings of the 51st ACM Southeast Conference. pp. 5:1–5:6 ACM, Savannah, Georgia (2013)Google Scholar
  7. 7.
    Roijackers, J., Fletcher, G.H.L.: On bridging relational and document-centric data stores. In: Gottlob, G., Grasso, G., Olteanu, D., Schallhart, C. (eds.) BNCOD 2013. LNCS, vol. 7968, pp. 135–148. Springer, Heidelberg (2013)CrossRefGoogle Scholar
  8. 8.
    Stumptner, R., Freudenthaler, B., Krenn, M.: BIAccelerator – a template-based approach for rapid ETL development. In: Chen, L., Felfernig, A., Liu, J., Raś, Z.W. (eds.) ISMIS 2012. LNCS, vol. 7661, pp. 435–444. Springer, Heidelberg (2012)CrossRefGoogle Scholar
  9. 9.
    Veen, J.S., van der et al.: Sensor data storage performance: SQL or NoSQL, physical or virtual. In: Chang, R. (ed.) IEEE Cloud, pp. 431–438. IEEE (2012)Google Scholar
  10. 10.
    Ziebermayr, T. et al.: A proposal for the application of dynamic workflows in disaster management: a process model language customized for disaster management. In: Morvan, F. et al. (eds.) DEXA Workshops, pp. 284–288. IEEE Computer Society (2011)Google Scholar

Copyright information

© Springer International Publishing Switzerland 2015

Authors and Affiliations

  • Reinhard Stumptner
    • 1
    Email author
  • Christian Lettner
    • 1
  • Bernhard Freudenthaler
    • 1
  1. 1.Software Competence Center Hagenberg, Data Analysis SystemsHagenbergAustria

Personalised recommendations