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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
AngularJS. https://angularjs.org
Spring Boot. https://projects.spring.io/spring-boot/
Spring JDBC. https://docs.spring.io/spring/docs/current/spring-framework-reference/html/jdbc.html
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)
Brewer, E.: Cap twelve years later: how the rules have changed. Computer 45(2), 23–29 (2012)
Brown, M.: Learning Apache Cassandra. Packt Publishing, Birmingham (2015)
Chandra, D.G.: BASE analysis of NoSQL database. Future Gener. Comput. Syst. 52, 13–21 (2015)
Chodorow, K., Dirolf, M.: MongoDB: The Definitive Guide, 1st edn. O’Reilly Media, Sebastopol (2010)
Choi, Y.L., Jeon, W.S., Yoon, S.H.: Improving database system performance by applying NoSQL. JIPS 10, 355–364 (2014)
Codd, E.F.: A relational model of data for large shared data banks. Commun. ACM 13(6), 377–387 (1970)
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
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)
Hewitt, E.: Cassandra: The Definitive Guide, 1st edn. O’Reilly Media, Sebastopol (2010)
Hobbs, T.: Basic Rules of Cassandra Data Modeling. http://www.datastax.com/dev/blog/basic-rules-of-cassandra-data-modeling
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)
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)
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)
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)
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)
NVidia Corporation: Db engines ranking. http://db-engines.com/en/ranking
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
Sullivan, D.: NoSQL for Mere Mortals. Addison-Wesley, Boston (2015)
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)
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)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights 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)