Application caching strategy based on in-memory using Redis server to accelerate relational data access
Open Access
- 20 March 2020
- journal article
- Published by Institute of Research and Community Services Diponegoro University (LPPM UNDIP) in Jurnal Teknologi dan Sistem Komputer
- Vol. 8 (2), 157-163
- https://doi.org/10.14710/jtsiskom.8.2.2020.157-163
Abstract
Utilization of an in-memory database as a cache can overcome relational database latency problems in a web application, especially when using a lot of join queries. This study aims to model the academic relational data into Redis compatible data and analyze the performance of join queries usage to accelerate access to relational data managed by RDBMS. This study used academic data to calculate student GPA that is modeled in the RDBMS and Redis in-memory database (IMDB). The use of Redis as an in-memory database can significantly increase Mysql database system performance up to 3.3 times faster to display student data using join query and to shorten the time needed to display GPA data to 52 microseconds from 61 milliseconds.Keywords
Funding Information
- Kementerian Riset, Teknologi, Dan Pendidikan Tinggi Republik Indonesia
This publication has 17 references indexed in Scilit:
- Performance Comparison of Data Mining Classification Algorithms for Early Warning System of Students Graduation TimelinessJurnal Teknologi dan Sistem Komputer, 2018
- A performance evaluation of in-memory databasesJournal of King Saud University - Computer and Information Sciences, 2017
- Performance comparison of caching strategy on wordpress multisitePublished by Institute of Electrical and Electronics Engineers (IEEE) ,2017
- A comparative study of relational database and key-value database for big data applicationsPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2017
- A middle layer solution to support ACID properties for NoSQL databasesJournal of King Saud University - Computer and Information Sciences, 2016
- R-memcached: A reliable in-memory cache for big key-value storesTsinghua Science and Technology, 2015
- Data Caching Techniques in Web ApplicationPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2014
- Database Research: Are We at a Crossroad? Reflection on NoSQLPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2012
- Caching Dynamic Web Content: Designing and Analysing an Aspect-Oriented SolutionLecture Notes in Computer Science, 2006
- Brewer's conjecture and the feasibility of consistent, available, partition-tolerant web servicesACM SIGACT News, 2002