Jurnal Teknologi dan Sistem Komputer · 2020 · 14 citations · 13 references
ComputingComputer ScienceData ManagementDatabasesStorage SystemsCachingCaching StrategiesDatabase ManagementQuery ProcessingRelational Data ModelRelational DatabasesData Cache BehaviorData CachingDatabase CachingIn-memory CachingJoinJoin ProcessingQuery Performance OptimizationRelational Database Systems
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.
13
In-Memory Big Data Management and Processing: A Survey
Hao Zhang, Gang Chen, Beng Chin Ooi et al. · IEEE Transactions on Knowledge and Data Engineering · 2015 · 419 citations · Full text
Database Research: Are We at a Crossroad? Reflection on NoSQL
Maria Indrawan · 2012 · 62 citations