Perbandingan Kemampuan Database NoSQL dan SQL dalam Kasus ERP Retail

Bhaswara, Faizal Anugrah; Sarno, Riyanarto; Sunaryono, Dwo

doi:10.12962/j23373539.v6i2.24031

Cited by 9 publications

(9 citation statements)

References 1 publication

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Service and delivery of information that is fast, efficient and precise is a high selling point. The trials carried out (Bhaswara et al, 2017) (Halimi et al, 2021) (Deari et al, 2018) (Győrödi et al, 2022) in conducting CRUD testing, NoSQL with MongoDB has better performance compared to RDBMS databases.…”

Section: Optimization Of Transaction Database Design With Mysql and M...mentioning

confidence: 99%

Optimization of Transaction Database Design with MySQL and MongoDB

Mumtahana

2022

SinkrOn

View full text Add to dashboard Cite

Database is one of the most important parts in running an application. Databases can be used to store data. However, in running an application, the selection of an appropriate database needs to be considered, so that the resulting information can be in accordance with user needs. In developing applications, more people use RDBMS design which has a very structured nature, but technological developments have introduced NoSQL as a database development method. In this research, MySQL and MongoDB databases will be tested in transaction processing. The tests carried out include comparisons of database designs, comparisons of defining table structures, comparisons of running time in the insert, update, delete, search processes. The test results show that MongoDB has a simpler table description structure than MySQL. The results of the running time test show that MongoDB has a faster running time difference than MySQL. In the insert process there is a time difference of 0.005625 sec, update 0.001688 sec, delete 0.00075 sec and search 0.006875 sec.

show abstract

Section: Optimization Of Transaction Database Design With Mysql and M...mentioning

confidence: 99%

Optimization of Transaction Database Design with MySQL and MongoDB

Mumtahana

2022

SinkrOn

View full text Add to dashboard Cite

show abstract

“…Permasalahan pengolahan data yang kompleks pada [8]. Database NoSQL lebih baik dibandingkan MySQL dalam proses transaksi CRUD [9]. Selain itu, NoSQL mendukung untuk dokumen JSON yang membuat integrasi data dalam beberapa jenis aplikasi lebih mudah dan lebih cepat [10].…”

Section: Pendahuluanunclassified

Rancang Bangun Sistem Identifikasi Arus Lalu Lintas pada Simpang Tiga Menggunakan Database NoSQL

Alkaff

Radam

Sugiantoro

2020

JuTISI

View full text Add to dashboard Cite

T-junction is one of the types of intersections that often results in congestion, and long queues. Therefore, it is necessary to identify the traffic flow to determine vehicles per hour, Passenger Car Unit (PCU) per hour, traffic fluctuations, vehicle composition, trip composition and traffic flow at peak hours at T-junction. The process of identifying traffic flow is complex and involves many variables. The process is currently still using Microsoft Excel which requires a lot of time and energy and allows for human error. Therefore, the purpose of this research is to design and build a traffic flow identification system at T-junction using NoSQL database. NoSQL is useful for complex data because NoSQL eliminates repetitive data. The results of this research are the traffic flow identification system at T-junction using NoSQL database which consists of vehicles per hour, PCU per hour, traffic fluctuations, vehicle composition, trip composition, and traffic flow during peak hours.

show abstract

“…Manfaat dari penelitian ini untuk mengetahui model manajemen basis data manakah yang paling efektif serta efisien untuk digunakan sehingga kedepannya dapat dijadikan sebagai acuan dalam penggunaan model basis data yang paling cocok dan tepat sesuai kebutuhan pengguna. Terdapat banyak penelitian terdahulu mengenai perbandingan performa serta pengukuran waktu respon kueri diantaranya: Studi perbandingan performansi antara MongoDB dan MySQL dalam lingkungan big data [5], Perbandingan performansi database MongoDB dan MySQL dalam aplikasi file multimedia berbasis web [6], Perbandingan kemampuan NoSQL dan SQL kasus ERP Retail [7]. Perbandingan penggunaan NoSQL MongoDB dan MySQL pada basis data forum komunikasi [8].…”

Section: Pendahuluanunclassified

Analisis Perbandingan Performansi Waktu Respons Kueri antara MySQL PHP 7.2.27 dan NoSQL MongoDB

Tavares

Rangkoly

Bawan

et al. 2020

JurTI

View full text Add to dashboard Cite

– Currently now, every function of the governmental and private agencies are required to manage the system work properly, effectively, and certainly efficient in terms of both time and system flexibility. Not a few have used the use of basic management data to help maximize the work system that is being run. This research will be carried out by examining the performance when answering queries between 2 commonly used management database systems, namely the My Structured Query Language (MySQL) relational database and Not-Only SQL (NoSQL) MongoDB non-relational database tested on the Aspiration and Information Service System of Oebufu Village (SELMA) with the number of data records (50, 100, 500, 1000, 5000, 10000, 100000). The examiner is carried out on the Data Manipulation Language (DML) query, which is inserting, update, delete, and select functions in adding, modifying, and displaying data in the database. Testing is also carried out on the agreement function, namely Counting (COUNT), Total in 1 table (SUM), Average (AVG )functions as well as the AND OR liaison operator as well as testing data import and export. The research aims to provide the results of a performance comparison analysis between MySQL and MongoDB NoSQL query respond database to find out which one is more good for use. The results can be proven that the two databases have different speeds in response performance comparisons in each model test, where NoSQL MongoDB is proven to be superior in every transaction tested model, starting from DML queries and function aggregate testing, import-export of data tables, and intermediate operator function, but weak in comparing select queries to display data with a runtime difference of 1.95.Keywords: Database, Query Respond Time, MySQL, NoSQL, MongoDB. Abstrak - Saat ini, setiap fungsi kerja instansi kepemerintahan maupun swasta dituntut untuk dapat mengelola sistem kerja secara tepat, efektif dan tentunya efisien baik dari segi waktu maupun flexibilitas sistem. Tidak sedikit yang telah menggunakan pemanfaatan manajemen basis data dalam membantu memaksimalkan sistem kerja yang tengah dijalankan. Penelitian ini akan dilakukan pengujian kinerja waktu respond query diantara 2 sistem manajemen basis data yang telah umum digunakan yaitu database relasional My Structured Query Language (MySQL) dan database non-relasional Not-Only SQL (NoSQL) MongoDB yang diujikan pada Sistem Layanan Aspirasi dan Informasi Kelurahan Oebufu (SELMA) dengan banyak record data (50, 100, 500, 1000, 5000, 10000, 100000). Adapun pengujian dilakukan pada query Data Manipulation Language (DML) yaitu pada fungsi insert, update, delete dan select dalam menambah, mengubah, menghapus serta menampilkan data pada database. Pengujian juga dilakukan terhadap agregat fuction yaitu pada fungsi Counting (COUNT), Total dalam 1 tabel (SUM), Average (AVG) juga pada operator penghubung AND OR serta pengujian import dan export data. Penelitian bertujuan memberikan hasil analisis perbandingan kinerja waktu respond query diantara MySQL dan NoSQL MongoDB untuk mengetahui basis data mana yang lebih unggul untuk digunakan. Hasilnya dapat dibuktikan bahwa kedua database tersebut memiliki kecepatan waktu yang berbeda dalam perbandingan kinerja respon kueri pada setiap model pengujian, dimana NoSQL MongoDB terbukti lebih unggul, mulai dari pengujian query DML, pengujian agregat fuction, impor-export data serta fungsi operator penghubung, namun lemah dalam pemrosesan query select untuk menampilkan data dengan jumlah selisih waktu respon 1,95s.Kata kunci: Basis Data, Query Respond Time, MySQL, NoSQL, MongoDB

show abstract

Perbandingan Kemampuan Database NoSQL dan SQL dalam Kasus ERP Retail

Cited by 9 publications

References 1 publication

Optimization of Transaction Database Design with MySQL and MongoDB

Optimization of Transaction Database Design with MySQL and MongoDB

Rancang Bangun Sistem Identifikasi Arus Lalu Lintas pada Simpang Tiga Menggunakan Database NoSQL

Analisis Perbandingan Performansi Waktu Respons Kueri antara MySQL PHP 7.2.27 dan NoSQL MongoDB

Contact Info

Product

Resources

About