A Comparison of NoSQL and Relational Database Management Systems (RDBMS)

[{“box”:0,”content”:”

n

Year : August 23, 2023 | Volume : 01 | Issue : 01 | Page : 33-37

n

n

n

n

n

n

By

n

    n t

    [foreach 286]n

    n

    B.M. Rajesh, Divya Bharathi C., Pavithra R.

  1. [/foreach]

    n

n

n

    [foreach 286] [if 1175 not_equal=””]n t

  1. Assistant Professor, Student, Student, Department of Information Technology, Dr. NGP Arts and Science College, Coimbatore, Department of Information Technology, Dr. NGP Arts and Science College, Coimbatore, Department of Information Technology, Dr. NGP Arts and Science College, Coimbatore, Tamil Nadu, Tamil Nadu, Tamil Nadu, India, India, India
  2. n[/if 1175][/foreach]

n

n

Abstract

nThe new aspirant is a non-relational abstracts abundance which is widely deployed in large website environments where there is less reliance on relational databases, leading to enhanced performance in the field of data retrieval. NoSQL are additionally accepted as non-relational databases adulation relational databases and are now acclimated by the world’s bigger organizations such as Facebook, Amazon, and Google. Both models are acceptable in specific areas and for specific applications. Depending on what issues are to be apparent by the company, it will actuate the best of a database archetypal to be adopted. Some organizations, however, adopt to accomplish use of an amalgam database which is the aggregate of both NoSQL and relational databases contrarily referred to as multimodel database. The aspect of this cardboard is to emphasize the importance this almost new technology and acutely appearance its architecture. NOSQL aegis appearance will be compared with the better-known relational databases for bigger understanding. This analysis will accredit affluence of best for those who accept the charge for such databases or facilitate the best to embrace the trending convenance of combining both in the same application to create a hybrid database.

n

n

n

Keywords: SQL, database, XML, JSON, BLOB

n[if 424 equals=”Regular Issue”][This article belongs to International Journal of Data Structure Studies(ijdss)]

n

[/if 424][if 424 equals=”Special Issue”][This article belongs to Special Issue under section in International Journal of Data Structure Studies(ijdss)][/if 424][if 424 equals=”Conference”]This article belongs to Conference [/if 424]

n

n

n

How to cite this article: B.M. Rajesh, Divya Bharathi C., Pavithra R. A Comparison of NoSQL and Relational Database Management Systems (RDBMS) ijdss August 23, 2023; 01:33-37

n

How to cite this URL: B.M. Rajesh, Divya Bharathi C., Pavithra R. A Comparison of NoSQL and Relational Database Management Systems (RDBMS) ijdss August 23, 2023 {cited August 23, 2023};01:33-37. Available from: https://journals.stmjournals.com/ijdss/article=August 23, 2023/view=0/

nn


nn

Full Text

n[if 992 equals=”Open Access”] [else] nvar fieldValue = “[user_role]”;nif (fieldValue == ‘indexingbodies’) {n document.write(”);n }nelse if (fieldValue == ‘administrator’) { document.write(”); }nelse if (fieldValue == ‘ijdss’) { document.write(”); }n else { document.write(‘ ‘); }n [/if 992] [if 379 not_equal=””]n

Browse Figures

n

n

[foreach 379]n

n[/foreach]n

nn

n

n[/if 379]n

n

References

n[if 1104 equals=””]n

  1. Zaki Asadulla. NOSQL Databases: New Millennium Database for Big Data, Big Users, Cloud Computing and Its Security Challenges. Int J Res Eng Technol. 2014; 03(3): 403–409. 10.15623/ijret.2014.0315080.
  2. Moniruzzaman ABM, Hossain, Syed A. NoSQL Database: New Era of Databases for Big data Analytics – Classification, Characteristics and Comparison. Int J Database Theor Appl. 2013; 6(4): 1–14.
  3. Manoj V. Comparative Study of NoSQL Document, Column Store Databases and Evaluation of Cassandra. Int J Database Manag Syst. 2014; 6(4): 11–26. 10.5121/ijdms.2014.6402.
  4. Leavitt N. Will NoSQL databases live up to their promise? Computer. 2010; 43(2): 12–14.
  5. Ajayi OM. Architecture perspective of NoSQL: user experience and scalability of cassandra and MongoDB. Thesis. Finland: Turku university of applied sciences; 2014.
  6. Nayak A, Poriya A, Poojary D. Type of NOSQL databases and its comparison with relational databases. Int J Appl Inf Syst. 2013 Mar; 5(4): 16–9.
  7. Batra S, Tyagi C. Comparative analysis of relational and graph databases. Int J Soft Comput Eng (IJSCE). 2012 May; 2(2): 509–12.
  8. Lawrence R. Integration and Virtualization of Relational SQL and NoSQL Systems including MySQL and MongoDB. 2014 IEEE International Conference on Computational Science and Computational Intelligence, Las Vegas, NV, USA. 2014 Mar; 285–290.
  9. Mason T, Lawrence R. Dynamic database integration in a JDBC driver. In International Conference on Enterprise Information Systems. 2005 May 24; 2: 326–333. SCITEPRESS.
  10. Gašpar D, Mabić M, Krtalić T. Integrating Two Worlds: Relational and NoSQL. In Central European Conference on Information and Intelligent Systems; Faculty of Organization and Informatics Varazdin. 2017; 11–18.
  11. Brewer Eric. Towards robust distributed systems. PODC’00: Proceedings of the 19th annual ACM symposium on Principles of distributed computing. 2000 Jul. 10.1145/343477.343502.
  12. Mohamed Mohamed A, Altrafi Obay G, Ismail Mohammed O. Relational Vs. NoSQL databases: A survey. Int J Comput Inf Technol (IJCIT). 2014; 03(3): 598–601.
  13. Okman L, Gal-Oz N, Gonen Y, Gudes E, Abramov J. Security issues in nosql databases. In 2011 IEEE 10th International Conference on Trust, Security and Privacy in Computing and Communications. 2011 Nov 16; 541–547.
  14. Pore SS, Pawar SB. Comparative study of SQL & NoSQL databases. International Journal of Advanced Research in Computer Engineering & Technology (IJARCET). 2015 May 5; 4(5): 1747–53.
  15. Priyanka A. A review of nosql databases, types and comparison with relational database. International Journal of Engineering Science and Computing (IJESC). 2016 May; 6(5): 4963–6.
  16. Yin S, Ray I. Relational database operations modeling with UML. In 19th IEEE International Conference on Advanced Information Networking and Applications (AINA’05) (AINA papers). 2005 Mar 28; 1: 927–932.

nn[/if 1104][if 1104 not_equal=””]n

    [foreach 1102]n t

  1. [if 1106 equals=””], [/if 1106][if 1106 not_equal=””],[/if 1106]
  2. n[/foreach]

n[/if 1104]

nn


nn[if 1114 equals=”Yes”]n

n[/if 1114]

n

n

Regular Issue Subscription Review Article

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

Volume 01
Issue 01
Received August 8, 2023
Accepted August 19, 2023
Published August 23, 2023

n

n

n

[if 1190 not_equal=””]n

Editor

n

[foreach 1188]n

n[/foreach]

n[/if 1190] [if 1177 not_equal=””]n

Reviewer

n

[foreach 1176]n

n[/foreach]

n[/if 1177]

n

n

n

n function myFunction2() {n var x = document.getElementById(“browsefigure”);n if (x.style.display === “block”) {n x.style.display = “none”;n }n else { x.style.display = “Block”; }n }n document.querySelector(“.prevBtn”).addEventListener(“click”, () => {n changeSlides(-1);n });n document.querySelector(“.nextBtn”).addEventListener(“click”, () => {n changeSlides(1);n });n var slideIndex = 1;n showSlides(slideIndex);n function changeSlides(n) {n showSlides((slideIndex += n));n }n function currentSlide(n) {n showSlides((slideIndex = n));n }n function showSlides(n) {n var i;n var slides = document.getElementsByClassName(“Slide”);n var dots = document.getElementsByClassName(“Navdot”);n if (n > slides.length) { slideIndex = 1; }n if (n (item.style.display = “none”));n Array.from(dots).forEach(n item => (item.className = item.className.replace(” selected”, “”))n );n slides[slideIndex – 1].style.display = “block”;n dots[slideIndex – 1].className += ” selected”;n }n n function myfun() {n x = document.getElementById(“editor”);n y = document.getElementById(“down”);n z = document.getElementById(“up”);n if (x.style.display == “none”) {n x.style.display = “block”;n }n else {n x.style.display = “none”;n }n if (y.style.display == “none”) {n y.style.display = “block”;n }n else {n y.style.display = “none”;n }n if (z.style.display == “none”) {n z.style.display = “block”;n }n else {n z.style.display = “none”;n }n }n function myfun2() {n x = document.getElementById(“reviewer”);n y = document.getElementById(“down2”);n z = document.getElementById(“up2”);n if (x.style.display == “none”) {n x.style.display = “block”;n }n else {n x.style.display = “none”;n }n if (y.style.display == “none”) {n y.style.display = “block”;n }n else {n y.style.display = “none”;n }n if (z.style.display == “none”) {n z.style.display = “block”;n }n else {n z.style.display = “none”;n }n }n”}]