Abstract:
The volume (petabyte to terabyte), variety (unstructured, structured and hybrid), but also 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 were 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 which are included in the main categories such as security, technologies and
so on. Also this study includes 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 study on relational databases and
NoSQL databases for online information systems should be done, according to our
recommendation.
