A survey on RDBMS and NoSQL Databases MySQL vs MongoDB

Palanisamy, Sowndarya; SuvithaVani, P.

doi:10.1109/iccci48352.2020.9104047

Cited by 16 publications

(10 citation statements)

References 2 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…They represent solutions of different scenarios and coexistence within companies. [12] This paper compares the concepts of NoSQL and Relational databases then their limitations. And address the advantages and types of NoSQL databases.…”

Section: Related Studymentioning

confidence: 99%

“…Durability: A completed transaction's modifications must be retained, An ACID-compliant database ensures that only successful transactions are completed, which provides data integrity for the database as well as the ability to recover from system failures. [12]…”

Section: The Acid Propertiesmentioning

confidence: 99%

“…This resulted in the introduction of a new technology known as NoSQL among commercial organizations and businesses. [12] 5 NoSQL Database…”

Section: Challenges Faced By Relational Databasementioning

confidence: 99%

See 2 more Smart Citations

NoSQL: Will it be an alternative to a relational database? MySQL vs MongoDB comparison

alyasiri¹,

Sahi²,

AL-Khafaji³

2022

Proceedings of 2nd International Multi-Disciplinary Conference Theme: Integrated Sciences and Technologies, IMDC-IST 2021, 7-9

View full text Add to dashboard Cite

NoSQL databases and related technologies are rapidly evolving and are commonly used in a variety of scenarios (consistency, availability, partition tolerance), and this has sparked controversy in the database world in several, so this paper aims to shed light on the characteristics that determine the use of databases. By discussing the challenges and studying the differences in depth and trying to answer the question related to the future use of the database, we started by discussing both relational and non-relational databases, shortcomings, and challenges, then we chose a model of both types, and we studied the differences in practice in the query process by installing database servers, it is an important part of the data handling process. We also discussed the popularity of the two models adopted for several considerations and concluded that non-relational databases, despite the challenges, tend to be the first choice soon.

show abstract

Section: Related Studymentioning

confidence: 99%

Section: The Acid Propertiesmentioning

confidence: 99%

See 1 more Smart Citation

NoSQL: Will it be an alternative to a relational database? MySQL vs MongoDB comparison

alyasiri¹,

Sahi²,

AL-Khafaji³

2022

Proceedings of 2nd International Multi-Disciplinary Conference Theme: Integrated Sciences and Technologies, IMDC-IST 2021, 7-9

View full text Add to dashboard Cite

show abstract

“…A number of developers of NoSQL systems to implement this shortcoming implement additional functionality. An example of such a DBMS is MongoDB [10][11], which fully supports distributed ACID transactions. This one of the most popular systems shows quite high performance results and has integration with a large number of programming languages.…”

Section: Analysis Of Recent Research and Publicationsmentioning

confidence: 99%

Research of Acid Transaction Implementation Methods for Distributed Databases Using Replication Technology

Mazurova

Naboka

Shirokopetleva

2021

ITSSI

View full text Add to dashboard Cite

Today, databases are an integral part of most modern applications designed to store large amounts of data and to request from many users. To solve business problems in such conditions, databases are scaled, often horizontally on several physical servers using replication technology. At the same time, many business operations require the implementation of transactional compliance with ACID properties. For relational databases that traditionally support ACID transactions, horizontal scaling is not always effective due to the limitations of the relational model itself. Therefore, there is an applied problem of efficient implementation of ACID transactions for horizontally distributed databases. The subject matter of the study is the methods of implementing ACID transactions in distributed databases, created by replication technology. The goal of the work is to increase the efficiency of ACID transaction implementation for horizontally distributed databases. The work is devoted to solving the following tasks: analysis and selection of the most relevant methods of implementation of distributed ACID transactions; planning and experimental research of methods for implementing ACID transactions by using of NoSQL DBMS MongoDB and NewSQL DBMS VoltDB as an example; measurements of metrics of productivity of use of these methods and formation of the recommendation concerning their effective use. The following methods are used: system analysis; relational databases design; methods for evaluating database performance. The following results were obtained: experimental measurements of the execution time of typical distributed transactions for the subject area of e-commerce, as well as measurements of the number of resources required for their execution; revealed trends in the performance of such transactions, formed recommendations for the methods studied. The obtained results allowed to make functions of dependence of the considered metrics on loading parameters. Conclusions: the strengths and weaknesses of the implementation of distributed ACID transactions using MongoDB and VoltDB were identified. Practical recommendations for the effective use of these systems for different types of applications, taking into account the resources consumed and the types of requests.

show abstract

“…Saat ini terdapat dua tipe basis data yang biasa digunakan yaitu basis data relasional dan basis data yang bersifat non relasional, (Palanisamy & Suvithavani, 2020). Pada era dimana hampir semua organisasi berlomba-lomba untuk mengadopsi teknologi pengolahan data besar atau yang biasa disebut sebagai Big Data, banyak data yang bentuknya tidak terstruktur dengan ukuran data yang sangat besar yang berasal dari berbagai macam sumber, (Patel, 2019).…”

Section: Pendahuluanunclassified

Evaluasi Penggunaan Prometheus dan Grafana Untuk Monitoring Database Mongodb

Ramadoni

Amirudin²,

Fahmi³

et al. 2021

JIP

View full text Add to dashboard Cite

Sebuah basis data dituntut untuk selalu dalam keadaan optimal, karena hal tersebut merupakan faktor penting dalam sebuah Sistem Informasi Manajemen. Untuk menjaga sebuah sistem basis data agar selalu optimal tentu saja dibutuhkan mekanisme monitoring yang dapat memberikan informasi kepada pihak yang berkepentingan sehingga setiap kejadian dapat terpantau, sehingga apabila diperlukan sebuah tindakan preventif maupun korektif dapat segera dilakukan. Pemilihan perangkat monitoring perlu mempertimbangkan beberapa faktor seperti fleksibilitas, kemampuan untuk diintegrasikan dengan sistem yang lain. Prometheus dan Grafana adalah kombinasi yang bagus untuk melakukan monitoring pada sistem basis data, tidak hanya terbatas pada sistem sebuah basis data MongoDB, kemampuan Prometheus untuk menyimpan basis data dalam bentuk time series memungkinkan Prometheus untuk menyimpan data dalam jumlah besar. Sedangkan tampilan visualisasi Grafana yang bisa dikustomisasi membuka peluang untuk kita membuat visualisasi dan mendapatkan visibilitas sesuai dengan kebutuhan. Penggunaan Prometheus dan Grafana yang bersifat opensource juga menjadi pilihan untuk mengurangi biaya karena tidak membutuhkan lisensi untuk penggunaannya bahkan di lingkungan komersial sekalipun.

show abstract

A survey on RDBMS and NoSQL Databases MySQL vs MongoDB

Cited by 16 publications

References 2 publications

NoSQL: Will it be an alternative to a relational database? MySQL vs MongoDB comparison

NoSQL: Will it be an alternative to a relational database? MySQL vs MongoDB comparison

Research of Acid Transaction Implementation Methods for Distributed Databases Using Replication Technology

Evaluasi Penggunaan Prometheus dan Grafana Untuk Monitoring Database Mongodb

Contact Info

Product

Resources

About