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

Conference paper

DOI: 10.1007/978-3-319-58274-0_13

Part of the Communications in Computer and Information Science book series (CCIS, volume 716)
Cite this paper as:
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

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 

Copyright information

© Springer International Publishing AG 2017

Authors and Affiliations

  1. 1.Institute of Computer ScienceLublin University of TechnologyLublinPoland

Personalised recommendations