Skip to main content
SpringerLink
Log in

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

  • Conference paper
  • First Online:
Beyond Databases, Architectures and Structures. Towards Efficient Solutions for Data Analysis and Knowledge Representation (BDAS 2017)

Part of the book series: Communications in Computer and Information Science ((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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. AngularJS. https://angularjs.org

  2. Spring Boot. https://projects.spring.io/spring-boot/

  3. Spring JDBC. https://docs.spring.io/spring/docs/current/spring-framework-reference/html/jdbc.html

  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. Brewer, E.: Cap twelve years later: how the rules have changed. Computer 45(2), 23–29 (2012)

    Article  Google Scholar 

  6. Brown, M.: Learning Apache Cassandra. Packt Publishing, Birmingham (2015)

    Google Scholar 

  7. Chandra, D.G.: BASE analysis of NoSQL database. Future Gener. Comput. Syst. 52, 13–21 (2015)

    Article  Google Scholar 

  8. Chodorow, K., Dirolf, M.: MongoDB: The Definitive Guide, 1st edn. O’Reilly Media, Sebastopol (2010)

    Google Scholar 

  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. Codd, E.F.: A relational model of data for large shared data banks. Commun. ACM 13(6), 377–387 (1970)

    Article  MATH  Google Scholar 

  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

    Chapter  Google Scholar 

  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. Hewitt, E.: Cassandra: The Definitive Guide, 1st edn. O’Reilly Media, Sebastopol (2010)

    Google Scholar 

  14. Hobbs, T.: Basic Rules of Cassandra Data Modeling. http://www.datastax.com/dev/blog/basic-rules-of-cassandra-data-modeling

  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. 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. 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. 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. 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)

    Article  Google Scholar 

  20. NVidia Corporation: Db engines ranking. http://db-engines.com/en/ranking

  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. Sullivan, D.: NoSQL for Mere Mortals. Addison-Wesley, Boston (2015)

    Google Scholar 

  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. 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 

Download references

Author information

Authors and Affiliations

  1. Institute of Computer Science, Lublin University of Technology, Nadbystrzycka 36B, 20-618, Lublin, Poland

    Konrad Fraczek & Malgorzata Plechawska-Wojcik

Authors
  1. Konrad Fraczek
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Malgorzata Plechawska-Wojcik
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Malgorzata Plechawska-Wojcik .

Editor information

Editors and Affiliations

  1. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    Stanisław Kozielski

  2. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    Dariusz Mrozek

  3. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    Paweł Kasprowski

  4. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    Bożena Małysiak-Mrozek

  5. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    Daniel Kostrzewa

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Springer International Publishing AG

About this paper

Cite this paper

Fraczek, K., Plechawska-Wojcik, M. (2017). Comparative Analysis of Relational and Non-relational Databases in the Context of Performance in Web Applications. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures and Structures. Towards Efficient Solutions for Data Analysis and Knowledge Representation. BDAS 2017. Communications in Computer and Information Science, vol 716. Springer, Cham. https://doi.org/10.1007/978-3-319-58274-0_13

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-58274-0_13

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-58273-3

  • Online ISBN: 978-3-319-58274-0

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation