Comparative Analysis of Relational and Non-relational Databases in the Context of Performance in Web Applications

Conference paper
Part of the Communications in Computer and Information Science book series (CCIS, volume 716)

Abstract

This paper presents comparative analysis of relational and non-relational databases. For the purposes of this paper simple social-media web application was created. The application supports three types of databases: SQL (it was tested with PostgreSQL), MongoDB and Apache Cassandra. For each database the applied data model was described. The aim of the analysis was to compare the performance of these selected databases in the context of data reading and writing. Performance tests showed that MongoDB is the fastest when reading data and PostgreSQL is the fastest for writing. The test application is fully functional, however implementation occurred to be more challenging for Cassandra.

Keywords

Relational databases NoSQL MongoDB Cassandra 

References

  1. 1.
  2. 2.
  3. 3.
  4. 4.
    Boicea, A., Radulescu, F., Agapin, L.I.: MongoDB vs Oracle - database comparison. In: Proceedings of Third International Conference on Emerging Intelligent Data and Web Technologies (EIDWT), pp. 330–335 (2012)Google Scholar
  5. 5.
    Brewer, E.: Cap twelve years later: how the rules have changed. Computer 45(2), 23–29 (2012)CrossRefGoogle Scholar
  6. 6.
    Brown, M.: Learning Apache Cassandra. Packt Publishing, Birmingham (2015)Google Scholar
  7. 7.
    Chandra, D.G.: BASE analysis of NoSQL database. Future Gener. Comput. Syst. 52, 13–21 (2015)CrossRefGoogle Scholar
  8. 8.
    Chodorow, K., Dirolf, M.: MongoDB: The Definitive Guide, 1st edn. O’Reilly Media, Sebastopol (2010)Google Scholar
  9. 9.
    Choi, Y.L., Jeon, W.S., Yoon, S.H.: Improving database system performance by applying NoSQL. JIPS 10, 355–364 (2014)Google Scholar
  10. 10.
    Codd, E.F.: A relational model of data for large shared data banks. Commun. ACM 13(6), 377–387 (1970)MATHCrossRefGoogle Scholar
  11. 11.
    Gupta, S., Narsimha, G.: Efficient query analysis and performance evaluation of the NoSQL data store for bigdata. In: Satapathy, S.C., Prasad, V.K., Rani, B.P., Udgata, S.K., Raju, K.S. (eds.) Proceedings of the First International Conference on Computational Intelligence and Informatics. AISC, vol. 507, pp. 549–558. Springer, Singapore (2017). doi:10.1007/978-981-10-2471-9_53 CrossRefGoogle Scholar
  12. 12.
    Han, J., Haihong, E., Le, G., Du, J.: Survey on NoSQL database. In: 6th International Conference on Pervasive Computing and Applications (ICPCA), pp. 363–366 (2011)Google Scholar
  13. 13.
    Hewitt, E.: Cassandra: The Definitive Guide, 1st edn. O’Reilly Media, Sebastopol (2010)Google Scholar
  14. 14.
    Hobbs, T.: Basic Rules of Cassandra Data Modeling. http://www.datastax.com/dev/blog/basic-rules-of-cassandra-data-modeling
  15. 15.
    Jatana, N., Puri, S., Ahuja, M., Kathuria, I., Gosain, D.: A survey and comparison of relational and non-relational database. Int. J. Eng. Res. Technol. 1(6) (2012)Google Scholar
  16. 16.
    Lee, C.H., Zheng, Y.L.: SQL-to-NoSQL schema denormalization and migration: a study on content management systems. In: Proceedings of IEEE International Conference on Systems, Man, and Cybernetics (SMC), pp. 2022–2026 (2015)Google Scholar
  17. 17.
    Li, X., Ma, Z., Chen, H.: QODM: a query-oriented data modeling approach for NoSQL databases. In: Advanced Research and Technology in Industry Applications (WARTIA), pp. 338–345 (2014)Google Scholar
  18. 18.
    Li, Y., Manoharan, S.: A performance comparison of SQL and NoSQL databases. In: Proceedings of IEEE Pacific Rim Conference on Communications, Computers and Signal Processing (PACRIM), pp. 15–19 (2013)Google Scholar
  19. 19.
    Lourenço, J.R., Cabral, B., Carreiro, P., Vieira, M., Bernardino, J.: Choosing the right NoSQL database for the job: a quality attribute evaluation. J. Big Data 2, 1–26 (2015)CrossRefGoogle Scholar
  20. 20.
    NVidia Corporation: Db engines ranking. http://db-engines.com/en/ranking
  21. 21.
    Plechawska-Wójcik, M., Rykowski, D.: Comparison of relational, document and graph databases in the context of the web application development. In: Grzech, A., Borzemski, L., Świątek, J., Wilimowska, Z. (eds.) Information Systems Architecture and Technology: Proceedings of 36th International Conference on Information Systems Architecture and Technology – ISAT 2015 – Part II. AISC, vol. 430, pp. 3–13. Springer, Cham (2016). doi:10.1007/978-3-319-28561-0_1 Google Scholar
  22. 22.
    Sullivan, D.: NoSQL for Mere Mortals. Addison-Wesley, Boston (2015)Google Scholar
  23. 23.
    Truica, C.O., Radulescu, F., Boicea, A., Bucur, I.: Performance evaluation for crud operations in asynchronously replicated document oriented database. In: Proceedings of 20th International Conference on Control Systems and Computer Science, pp. 191–196 (2015)Google Scholar
  24. 24.
    Vokorokos, L., Uchnar, M., Lescisin, L.: Performance optimization of applications based on non-relational databases. In: International Conference on Emerging eLearning Technologies and Applications (ICETA), pp. 371–376 (2016)Google Scholar

Copyright information

© Springer International Publishing AG 2017

Authors and Affiliations

  1. 1.Institute of Computer ScienceLublin University of TechnologyLublinPoland

Personalised recommendations