Application caching strategy based on in-memory using Redis server to accelerate relational data access
Uloženo v:
| Název: | Application caching strategy based on in-memory using Redis server to accelerate relational data access |
|---|---|
| Autoři: | Mulki Indana Zulfa, Ari Fadli, Arief Wisnu Wardhana |
| Zdroj: | Jurnal Teknologi dan Sistem Komputer, Vol 8, Iss 2, Pp 157-163 (2020) |
| Informace o vydavateli: | Institute of Research and Community Services Diponegoro University (LPPM UNDIP), 2020. |
| Rok vydání: | 2020 |
| Témata: | Electronic computers. Computer science, redis, 1. No poverty, 0202 electrical engineering, electronic engineering, information engineering, relational data, QA75.5-76.95, 02 engineering and technology, web application, in-memory database |
| Popis: | 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. |
| Druh dokumentu: | Article |
| ISSN: | 2338-0403 2620-4002 |
| DOI: | 10.14710/jtsiskom.8.2.2020.157-163 |
| Přístupová URL adresa: | https://jtsiskom.undip.ac.id/index.php/jtsiskom/article/download/13397/12583 https://doaj.org/article/8db9b85da50f4d60817efbda1532524b https://jtsiskom.undip.ac.id/index.php/jtsiskom/article/view/13397 https://jtsiskom.undip.ac.id/article/download/13397/12583 |
| Rights: | CC BY SA |
| Přístupové číslo: | edsair.doi.dedup.....d13d0344acba1e70f8152293e67e1c99 |
| Databáze: | OpenAIRE |
Nájsť tento článok vo Web of Science | Abstrakt: | 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. |
|---|---|
| ISSN: | 23380403 26204002 |
| DOI: | 10.14710/jtsiskom.8.2.2020.157-163 |