Penerapan Database Redis Sebagai Optimalisasi Pemrosesan Kueri Data Pengguna Aplikasi SIRESMA Berbasis Laravel: Implementation of the Redis Database as Optimization of User Data Query Processing for the Laravel-Based SIRESMA Application

Ilham Nur Ramadhan; Galuh Saraswati

doi:10.33050/tmj.v8i3.2152

Authors

Ilham Nur Ramadhan Universitas Dian Nuswantoro
Galuh Saraswati Dian Nuswantoro University

DOI:

https://doi.org/10.33050/tmj.v8i3.2152

Abstract

This research evaluates the use of the Redis database in the Laravel-based Application, SIRESMA API endpoint, to overcome the problem of data query processing unresponsiveness. The test result shows that the implementation of Redis has significantly improved the access speed of most API endpoint reponses, with a total response time improvement of around 6.74%. However, it should be noted that there are certain endpoints that experience performance degradation, which indicates that the use of Redis should be tailored to the characteristics of the data and application usage to obtain optimal results. Meanwhile, future research can consider more detailed query diagnosis tools and other alternatives to improve application performance.

References

A. W. Ramadhan, A. Susanto, and G. W. Saraswati, “Implementasi Digital Payment Gateway Midtrans Pada Sistem Agribisnis Di Temanggung (SIADIT),” J-SAKTI (Jurnal Sains Komputer dan Informatika), vol. 7, no. 1, pp. 95–107, 2023.

H. Matallah, G. Belalem, and K. Bouamrane, “Comparative study between the MySQL relational database and the MongoDB NoSQL database,” International Journal of Software Science and Computational Intelligence (IJSSCI), vol. 13, no. 3, pp. 38–63, 2021.

D. S. S. Wuisan and T. Mariyanti, “Analisa Peran Triple Helik dalam Mengatasi Tantangan Pendidikan di Era Industri 4.0,” Jurnal MENTARI: Manajemen, Pendidikan dan Teknologi Informasi, vol. 1, no. 2, pp. 123–132, Jan. 2023, doi: 10.34306/mentari.v1i2.258.

W. A. Nurasniar, “Employee Performance Improvement Through Competence and Organizational Culture with Work Motivation as A Mediation Variable,” APTISI Transactions on Management (ATM), vol. 6, no. 2, pp. 121–131, Nov. 2021, doi: 10.33050/atm.v6i2.1743.

Anggy Giri Prawiyogi and Aang Solahudin Anwar, “Perkembangan Internet of Things (IoT) pada Sektor Energi : Sistematik Literatur Review,” Jurnal MENTARI: Manajemen, Pendidikan dan Teknologi Informasi, vol. 1, no. 2, pp. 187–197, Jan. 2023, doi: 10.34306/mentari.v1i2.254.

I. Hidayat and P. O. Sutria, “Influence of Determined Tax Load, Tax Planning, and Profitability in Profit Management in The Company Manufacturing The Mining Sector, The Coal Sub Sector Listed on The Indonesia Stock Exchange Year,” APTISI Transactions on Management (ATM), vol. 7, no. 1, pp. 79–85, Feb. 2022, doi: 10.33050/atm.v7i1.1833.

Zulham, Z. Lubis, M. Zarlis, and M. R. Aulia, “Performance Analysis of Oil Palm Companies Based on Barcode System through Fit Viability Approach: Long Work as A Moderator Variable,” Aptisi Transactions on Technopreneurship (ATT), vol. 5, no. 1, pp. 40–52, Jan. 2023, doi: 10.34306/att.v5i1.288.

N. Lutfiani, P. A. Sunarya, S. Millah, and S. Aulia Anjani, “Penerapan Gamifikasi Blockchain dalam Pendidikan iLearning,” Technomedia Journal, vol. 7, no. 3, pp. 399–407, Dec. 2022, doi: 10.33050/tmj.v7i3.1958.

A. Ajredini, “Database Cashing in-memory with Redis NoSQL Databases”.

A. Maulana et al., PEMROGRAMAN WEB 101: MEMAHAMI DASAR-DASAR UNTUK MENGEMBANGKAN SITUS WEB. Get Press Indonesia, 2023.

Y. Sawitri, I. A. Yannaty, S. I. Widyastika, T. D. Harumsih, and H. F. Musyarofah, “Dampak penggunaan smartphone terhadap perkembangan anak usia dini,” in Prosiding Seminar Nasional LPPM UMP, 2019, pp. 691–697.

A. Fagerstrøm, N. Eriksson, and V. Sigurdsson, “Investigating the impact of Internet of Things services from a smartphone app on grocery shopping,” Journal of Retailing and Consumer Services, vol. 52, p. 101927, 2020.

A. R. Kurniawan, “Tantangan pengembangan pariwisata berbasis masyarakat pada era digital di Indonesia (Studi Kasus Pengembangan Pariwisata Berbasis Masyarakat di Pangalengan),” Tornare: Journal of Sustainable and Research, vol. 2, no. 2, p. 10, 2020.

M. D. Permatasari et al., “PENGEMBANGAN APLIKASI SISTEM INFORMASI RESIK BECIK (SIKECIK) BERBASIS WEB PADA RUMAH SAMPAH RESIK BECIK KELURAHAN KROBOKAN SEMARANG,” BUDIMAS: JURNAL PENGABDIAN MASYARAKAT, vol. 4, no. 2, pp. 595–599, 2022.

Q. Liu and H. Yuan, “A High Performance Memory Key-Value Database Based on Redis.,” J. Comput., vol. 14, no. 3, pp. 170–183, 2019.

J. Jansson, A. Vukosavljevic, and I. Catovic, “Performance comparison between multi-model, key-value and documental NoSQL database management systems.” 2021.

Q. Meng, K. Zhang, H. Pan, M. Yuan, and B. Ma, “Design and Implementation of Key-Value Database for Ship Virtual Test Platform Based on Distributed System,” in International Conference of Pioneering Computer Scientists, Engineers and Educators, Springer, 2023, pp. 109–123.

A. I. Sanka, M. H. Chowdhury, and R. C. C. Cheung, “Efficient high-performance FPGA-Redis hybrid NoSQL caching system for blockchain scalability,” Comput Commun, vol. 169, pp. 81–91, 2021.

R. Ceresnak, M. Kvet, and K. Matiasko, “Improved method of selecting data in a nonrelational database,” in 2021 International Conference on Information and Digital Technologies (IDT), IEEE, 2021, pp. 59–64.

R. Patel, “Data+ Education. Redis Is a Cache or More?,” EasyChair Preprint, vol. 88, 2021.

H. M. Elmatsani, “Desain Metode PrefetchCache untuk Peningkatan Kinerja Aplikasi Web,” Techno. Com, vol. 19, no. 2, pp. 147–156, 2020.

W. M. Sari, A. Amran, and H. O. L. Wijaya, “Penerapan E-Commerce Menggunakan Metode Extreme Programming Pada Umkm Kabupaten Muratara,” Jusikom: Jurnal Sistem Komputer Musirawas, vol. 5, no. 2, pp. 136–144, 2020.

D. Satria, PENGANTAR TEKNIK KOMPUTER: Konsep dan Prinsip Dasar. PT. Sonpedia Publishing Indonesia, 2023.

M. Maidiana, “Penelitian survey,” ALACRITY: Journal of Education, pp. 20–29, 2021.

K. McGlade, K. Hakkarainen, J. Jaaskelainen, and R. Roulston, “Implementing a digital authoring system in finnish medical and dental schools,” in EDULEARN21 Proceedings, IATED, 2021, pp. 7969–7974.

R. Chopade and V. Pachghare, “A data recovery technique for Redis using internal dictionary structure,” Forensic Science International: Digital Investigation, vol. 38, p. 301218, 2021.

O. M. A. AL-atraqchi, “A Proposed Model for Build a Secure Restful API to Connect between Server Side and Mobile Application Using Laravel Framework with Flutter Toolkits,” Cihan University-Erbil Scientific Journal, vol. 6, no. 2, pp. 28–35, 2022.

H. Samosir, T. A. Prasetyo, S. Lumbantobing, D. O. Naibaho, and C. R. T. Situmorang, “Website Development with Laravel and Scrum Method: A Study case of Stasiun Mebel Jepara Store Case,” in 2021 17th International Conference on Quality in Research (QIR): International Symposium on Electrical and Computer Engineering, IEEE, 2021, pp. 60–65.

F. P. PURWANTORO, “Pengembangan Sistem Presensi Untuk Work From Home (Wfh) Dan Work From Office (Wfo) Selama Pandemi Covid-19,” 2021.

V. Gopalakrishnan and C. Ramaswamy, “Patient opinion mining to analyze drugs satisfaction using supervised learning,” Journal of Applied Research and Technology, vol. 15, no. 4, pp. 311–319, Aug. 2017, doi: 10.1016/j.jart.2017.02.005.

U. Rahardja, M. A. Ngadi, R. Budiarto, Q. Aini, M. Hardini, and F. P. Oganda, “Education Exchange Storage Protocol: Transformation Into Decentralized Learning Platform,” Front Educ (Lausanne), vol. 6, Dec. 2021, doi: 10.3389/feduc.2021.782969.