• Journal of Internet Computing and Services
    ISSN 2287 - 1136 (Online) / ISSN 1598 - 0170 (Print)
    https://jics.or.kr/

Comparative Evaluation of Data Processing Performance between MySQL and Redis


Hyeok Bang, Seo-Hyeon Kim, Sanghoon Jeon, Journal of Internet Computing and Services, Vol. 25, No. 3, pp. 35-41, Jun. 2024
10.7472/jksii.2024.25.3.35, Full Text:
Keywords: Data, Relational Database Management System, Not only SQL

Abstract

As online activities have rapidly increased due to recent digital changes and the impact of COVID-19, the importance of large-scale data processing and maintenance is increasing. This study compares the performance of the two main types of databases widely used for data storage and management: Relational Database Management Systems (RDBMS) and Non-Relational Databases (NoSQL). Specifically, we measured and evaluated the execution time of data insertion, query, and deletion functions using MySQL, a representative example of RDBMS, and Redis, a representative example of NoSQL. The experimental results showed that Redis showed performance about 5.84 times faster in data insertion, 6.61 times faster in query, and 12.33 times faster in deletion than MySQL. These results demonstrate that Redis provides superior performance, especially in environments requiring large-scale data processing and maintenance. Therefore, companies and online service providers can choose NoSQL databases such as Redis to ensure more efficient data management solutions. We hope this study will be an essential reference when selecting a database based on data processing performance.


Statistics
Show / Hide Statistics

Statistics (Cumulative Counts from November 1st, 2017)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.


Cite this article
[APA Style]
Bang, H., Kim, S., & Jeon, S. (2024). Comparative Evaluation of Data Processing Performance between MySQL and Redis. Journal of Internet Computing and Services, 25(3), 35-41. DOI: 10.7472/jksii.2024.25.3.35.

[IEEE Style]
H. Bang, S. Kim, S. Jeon, "Comparative Evaluation of Data Processing Performance between MySQL and Redis," Journal of Internet Computing and Services, vol. 25, no. 3, pp. 35-41, 2024. DOI: 10.7472/jksii.2024.25.3.35.

[ACM Style]
Hyeok Bang, Seo-Hyeon Kim, and Sanghoon Jeon. 2024. Comparative Evaluation of Data Processing Performance between MySQL and Redis. Journal of Internet Computing and Services, 25, 3, (2024), 35-41. DOI: 10.7472/jksii.2024.25.3.35.