Comparison between relational and NOSQL databases

Kosovare Sahatqija, Jaumin Ajdari, Xhemal Zenuni, Bujar Raufi, Florije Ismaili

2018 · 59 citations · 13 references

Concepts

TL;DR

Relational databases, the traditional DBMS, guarantee data integrity and transaction consistency, but the rapid growth of data has led to the emergence of NoSQL systems that also support CRUD operations while offering different trade‑offs. This study compares the advantages and disadvantages of relational and NoSQL databases in terms of their features and characteristics. The authors conduct a qualitative analysis of both database types, reviewing recent literature to evaluate their respective strengths and weaknesses.

Abstract

The relational database is provided from the traditional DBMS, which ensures the integrity of data and consistency of transactions. For many software applications, these are the principles of a proper DBMS. But in the last few years, witnessing the velocity of data growth and the lack of support from traditional databases for this issue, as a solution to it, the NoSQL (Not Only SQL) databases have appeared. These two kinds while being used for the same purposes (create, retrieve, update and manage data) they both have their own advantages and disadvantages over each other. The purpose of this study is to try and compare the research question of what are the pros and cons for each of these database' features and characteristics? This paper is a qualitative research, based on detailed and intensive analysis of the two database types, through use and comparison of some published materials during last few years.

References

13