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.
