A systematic review of relational databases and NOSQL databases

Abstract

The volume (petabyte to a terabyte), variety (unstructured, structured, and hybrid), and velocity of the digital world are all increasing quickly. The standard DBMS, which provides the Relational Database (RDB), guarantees the consistency of transactions and the integrity of the data. These are the standards for a good DBMS, which are applicable to numerous software programs. However, NoSQL (Not Only SQL) databases have emerged in recent years as a response to the problem after traditional databases failed to address the speed at which data was growing. These two types have different benefits and drawbacks from one another despite being used for the same tasks (creating, retrieving, updating, and managing data). This study used a systematic review technique to collect data from previously published studies. The data were collected from reputable publishers, and these data were evaluated independently to compare the RDB and NoSQL. Confidentiality, data integrity, auditing, authentication, customer interaction, Big Data technologies, Cloud technologies, complexity, performance, cost, and variety are the main differing attributes that are included in the main categories such as security, technologies, and so on. In addition, this study includes the benefits and drawbacks of RDB and NoSQL as well. Especially, RDBMS pay more attention to data consistency than NoSQL databases do. As a result, NoSQL creates a lot more vulnerability than RDBMS. NoSQL databases should use an external technique to conduct and ensure database security because they have a lot of experience with the expansion of big data and can easily handle a massive rise in data. Given the expansion and development of NoSQL database systems, its potential is vast. The majority of contemporary software and applications rely on the web, and over the coming years, the amount of data that needs to be stored is likely to rise significantly. These reasons suggest that NoSQL databases will develop significantly over the next few years, expand, and eventually find ways to address their security concerns. Furthermore, the discussion deeply analyses the comparison between RDB and NoSQL. Due to the restrictions caused by the scarcity of publications in online sources and also the lack of open access possibilities, this work was severely suppressed. Likewise, this study's principal weakness was the dearth of newly published studies. More studies on relational databases and NoSQL databases for online information systems should be done, according to our recommendation.