OPTIMALISASI DATABASE TRANSAKSI TELEKOMUNIKASI DENGAN NOSQL MEMCACHED

  • Riki Ramdani Saputra Universitas Budi Luhur
DOI: https://doi.org/10.35957/jatisi.v10i1.3228

Abstract

Nowadays, more people depend on telecommunication access; therefore, providers are required to be able to provide convenience in providing services. Those including transaction services that can be carried out from various telecommunication facilities. These issues causing the transaction table to have a very-heavy workload because it is accessed from various applications, both web-based applications and smartphone applications. With the large number of transactions through web-based applications, it is required for the efficiency of the web transaction method in accessing the database. With the presence of the noSql method, the results of data calls (query) from the client can be stored on the server memory as temporary storage (cache). The goal is to make the transaction website remains responsive, even though it is accessed a lot and having repeated data calls (queries).  By using the memcached method, transaction database performance can be suppressed by up to 5%.

References

[1] S. Kulvinder, and S. Ajit, “Memcached DDoS Exploits: Operations, Vulnerabilities, Preventions and Mitigations,” in IEEE 3rd International Conference on Computing, Communication and Security (ICCCS), 2018, doi: 10.1109/CCCS.2018.8586810.
[2] A. Fadli dkk, “Analisis Perbandingan Unjuk Kerja Database SQL dan Database NoSQL Untuk Mendukung Era Big Data,” Jurnal Nasional Teknik Elektro, vol. 9, no. 3, 2018, doi: 10.25077/jnte.v9n3.774.2020.
[3] A. Talha Kabakus, and R. Kara, “A performance evaluation of in-memory databases,” Journal of King Saud University – Computer and Information Sciences., vol. 29 pp. 520–525, 2017, doi: 10.1016/j.jksuci.2016.06.007.
[4] I. Daniel dkk, “Database Tuning in Hospital Applications Using Table Indexing and Query Optimization,” Jurnal Pendidikan Tambusal, 2022, vol. 6, no. 1, pp. 1960-1967.
[5] Mishra. N dkk, “Memcached: An experimental study of ddos attacks for the wellbeing of iot applications,” Sensors, vol.21, no. 23, 2021, doi: 10.3390/s21238071.
[6] Ghigoff. Y, “Accelerating Memcached using Safe In-kernel Caching and Pre-stack Processing,” in 18th USENIX Symposium on Networked Systems Design and Implementation Proceedings, 2021.
[7] Nishtala. R, “Scaling Memcache at Facebook,” in USENIX Symposium on Networked Systems Design and Implementation, 2013.
[8] Carra. D, and Michiardi. P “Memory Partitioning in Memcached: An Experimental Performance Analysis,” in IEEE International Conference on Communications (ICC), 2014. doi : 10.1109/ICC.2014.6883477.
[9] Kusuma. M, dan Eng. M, “Metode-Metode Optimasi Memcached sebagai NoSQL Key-value Memory Cache,” JISKA (Jurnal Informatika Sunan Kalijaga), vol. 3, no. 3, pp. 14-24, 2019, doi : 10.14421/jiska.2019.33-02.
[10] Gunawan R, “Pengukuran Query Respon Time Pada Nosql Database Berbasis Document Stored,” Jurnal Universitas Siliwangi, 2018, vol. 4, no. 2, pp. 100–103.
[11] Erwin. A dkk, “Perbandingan Kinerja Database NoSql Dengan Database Sql Server Pada Pemesanan Tiket Pesawat Online,” Indonesian Journal of Applied Informatics, 2020, vol. 4, no. 2.
[12] Rahmanto. A, Setia Budi. Agung, dan Primananda. R, “Implementasi Self-Tuning Pada Database Dengan Menggunakan Metode Nesterov Accelerated Gradient,” Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, 2021, vol. 5, no. 5, pp. 1907-1913.
[13] Rakhmawati. N dkk, “Benchmarking Mysql And Nosql Database On Egovbench Application,” Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, 2019, pp. 18-23, doi : 10.30818/jitu.2.1.2080.
[14] Kriestanto. D, and Benden Arnado. A, “Implementasi Website Pencarian Kos Dengan Nosql,” Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, 2019, vol. 2, no. 2, doi : 10.26798/jiko.v2i2.66.
[15] Chang. B dkk, “Integration and optimization of multiple big data processing platforms,” Engineering Computations, 2016, vol. 3, no. 6, pp. 1680-1704 doi : 10.1108/EC-08-2015-0247.
[16] Makris. A dkk, “Integration and optimization of multiple big data processing platforms,” Elsevier B.V., 2016, vol. 33, no. 6, pp. 1680-1704 doi : 10.1016/j.procs.2016.08.284.
Published
2023-03-21
Issue
Vol 10 No 1 (2023): JATISI (Jurnal Teknik Informatika dan Sistem Informasi)
Section
Articles
Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

Lisensi Creative Commons
JATIS oleh http://jurnal.mdp.ac.id/index.php/jatisi disebarluaskan di bawah Lisensi Creative Commons Atribusi-BerbagiSerupa 4.0 Internasional.