Sinkron : Jurnal dan Penelitian Teknik Informatika
Vol. 7 No. 3 (2022): Article Research Volume 7 Number 3, July 2022

Optimization of Transaction Database Design with MySQL and MongoDB

Hani Atun Mumtahana (Universitas PGRI Madiun, Indonesia)



Article Info

Publish Date
13 Jul 2022

Abstract

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.

Copyrights © 2022






Journal Info

Abbrev

sinkron

Publisher

Subject

Computer Science & IT

Description

Scope of SinkrOns Scientific Discussion 1. Machine Learning 2. Cryptography 3. Steganography 4. Digital Image Processing 5. Networking 6. Security 7. Algorithm and Programming 8. Computer Vision 9. Troubleshooting 10. Internet and E-Commerce 11. Artificial Intelligence 12. Data Mining 13. Artificial ...