Comparison of Database and Workload Types Performance in Cloud Environments

  • George Seriatos
  • George Kousiouris
  • Andreas Menychtas
  • Dimosthenis Kyriazis
  • Theodora Varvarigou
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 9511)


The rapid growth of unstructured data over the last few years, has led to the emergence of new database management systems. Traditional relational databases, despite their wide adoption and plethora of features, begin to show weaknesses when having to deal with very large amounts of data. Numerous types of databases have emerged in the Cloud domain, in order to exploit the elasticity of Cloud environments, while relaxing the typical ACID considerations and investigating trade-offs of the CAP theorem. The aim of this paper is to investigate how such offerings (MongoDB, Cassandra and HBase namely), based on these tradeoffs, behave when deployed in virtual environments (of the BONFIRE facility) and how they are measured against widely used benchmarks such as YCSB. The results may be helpful for potential adopters to choose from these offerings, based on their individual needs for specific workloads or query structures.


Cloud computing NoSQL Performance YCSB HBase MongoDB Cassandra Benchmarks 



This research has been co-financed by the European Union (European Social Fund – ESF) and Greek national funds through the Operational Program “Education and Lifelong Learning” of the National Strategic Reference Framework (NSRF) – Research Funding Program: Thales. Investing in knowledge society through the European Social Fund.


  1. 1.
    Digital Universe Infographic.IDC, December 2012.
  2. 2.
    Presto: Interacting with petabytes of data at Facebook. Lydia Chan, November 2013.
  3. 3.
  4. 4.
    List of NoSQL databases.
  5. 5.
    Han, J., et al.: Survey on NoSQL database. In: 2011 6th International Conference on Pervasive Computing and Applications (ICPCA), 26–28 October 2011, pp. 363–366 (2011). doi: 10.1109/ICPCA.2011.6106531
  6. 6.
    Cooper, B.F., et al.: Benchmarking cloud serving systems with YCSB. In: Proceedings of the 1st ACM Symposium on Cloud computing, pp. 143–154. ACM (2010)Google Scholar
  7. 7.
    Bonfire project Cloud testbeds.
  8. 8.
    Open Cloud Computing Interface Standard.
  9. 9.
    BlockCache 101.Nick Dimiduk. Accessed Sep 2014
  10. 10.
    Poess, M., Floyd, C.: New TPC benchmarks for decision support and web commerce. ACM SIGMOD Rec. 29(4), 64–71 (2000)CrossRefGoogle Scholar
  11. 11.
    Shi, Y., et al.: Benchmarking cloud-based data management systems. In: Proceedings of the Second International Workshop on Cloud Data Management (CloudDB 2010) (2010)Google Scholar
  12. 12.
    Hecht, R., Jablonski, S.: NoSQL evaluation: a use case oriented survey. In: Proceedings of the 2011 International Conference Cloud Service Computing, pp. 336–341 (2011)Google Scholar
  13. 13.
    Rahman, M.R., et al.: Toward a principled framework for benchmarking consistency. In: Proceedings of the Eighth USENIX Conference on Hot Topics in System Dependability. USENIX Association (2012)Google Scholar
  14. 14.
    Golab, W., et al: Analyzing consistency properties for fun and profit. In: PODC 2011: Proceedings of the 30th Annual ACM SIGACT-SIGOPS Symposium on Principles of Distributed Computing, pp. 197–206 (2011)Google Scholar
  15. 15.
    Van der Veen, J.S., et al.: Sensor data storage performance: SQL or NoSQL, physical or virtual. In: 2012 IEEE 5th International Conference on Cloud Computing (CLOUD). IEEE (2012)Google Scholar
  16. 16.
    Abadi, Daniel J.: Data management in the cloud: limitations and opportunities. IEEE Data Eng. Bull. 32(1), 3–12 (2009)Google Scholar
  17. 17.
    Iosup, A., et al: On the performance variability of production cloud services. In: 2011 11th IEEE/ACM International Symposium on Cluster, Cloud and Grid Computing (CCGrid). IEEE (2011)Google Scholar
  18. 18.
    Brewer, E.A.: Towards robust distributed systems. In: Symposium on Principles of Distributed Computing (2000)Google Scholar
  19. 19.
    Sakr, S., et al.: A survey of large scale data management approaches in cloud environments. IEEE Commun. Surv. Tutorials 13(3), 311–336 (2011)CrossRefGoogle Scholar

Copyright information

© Springer International Publishing Switzerland 2016

Authors and Affiliations

  • George Seriatos
    • 1
  • George Kousiouris
    • 1
  • Andreas Menychtas
    • 1
  • Dimosthenis Kyriazis
    • 1
  • Theodora Varvarigou
    • 1
  1. 1.National Technical University of AthensZografouGreece

Personalised recommendations