Journal of Internet Computing and Services (인터넷정보학회논문지)

Korean Society for Internet Information (한국인터넷정보학회)
권호 표지
DOI QR코드

DOI QR Code

Comparative Evaluation of Data Processing Performance between MySQL and Redis

MySQL과 Redis의 데이터 처리 성능 비교 평가

  • Hyeok Bang (Department of Information Security, The University of Suwon) ;
  • Seo-Hyeon Kim (Department of Information Communication, The University of Suwon) ;
  • Sanghoon Jeon (Department of Information Security, The University of Suwon)
  • 방혁 ;
  • 김서현 ;
  • 전상훈
  • Received : 2024.04.13
  • Accepted : 2024.05.13
  • Published : 2024.06.30
Download PDF
⟨ Previous Next ⟩

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.

최근 디지털 변화와 코로나19의 영향으로 온라인 활동이 급증함에 따라 대규모 데이터 처리와 유지보수의 중요성이 점점 커지고 있다. 이 연구는 데이터 저장 및 관리에 널리 사용되는 두 주요 데이터베이스 유형인 관계형 데이터베이스(RDBMS)와 비관계형 데이터베이스(NoSQL)의 성능을 비교 분석한다. 구체적으로, RDBMS의 대표 예인 MySQL과 NoSQL의 대표 예인 Redis를 사용하여 데이터 삽입, 조회, 삭제 기능의 수행 시간을 측정하고 평가했다. 실험 결과, Redis는 MySQL에 비해 데이터 삽입에서 약 5.84배, 조회에서는 약 6.61배, 삭제에서는 약 12.33배 빠른 성능을 보였다. 이 결과는 Redis가 특히 대규모 데이터 처리와 유지보수가 필요한 환경에서 뛰어난 성능을 제공함을 보여준다. 이에 따라 기업 및 온라인 서비스 제공자들은 Redis와 같은 NoSQL 데이터베이스를 선택함으로써 보다 효율적인 데이터 관리 솔루션을 확보할 수 있을 것이다. 본 연구가 데이터베이스 선택 시 데이터 처리 성능을 고려하는 데 중요한 참고 자료로 활용되기를 기대한다.

Keywords

Acknowledgement

본 연구는 2021년도 정부(교육부)의 재원으로 한국연구재단의 지원을 받아 수행된 기초연구사업임(No. 2021R1I1A1A0104094313)

References

  1. Yoon Ju Jeong, "Internet usage time has increased due to the covid-19... Messenger usage among people in their 70s is also 'worsening'," Yeonhap News, 2021. https://yna.co.kr/view/AKR20210303084400017
  2. Lisa Richwine, "Netflix says it has fixed outage that hit some in U.S., UK," Reuters, March 26, 2020. https://www.reuters.com/article/us-netflix-outages/netflix-says-it-has-fixed-outage-that-hit-some-in-u-s-uk-idUSKBN21C337/
  3. Humberto Farias, "From RDB to search engines... Choosing the DB that's right for you," CIOKorea, April 25, 2018. https://www.ciokorea.com/news/38041
  4. Jin Ok Jung, "NoSQL market growing 31.4% annually, reaching '$22.087 billion' by 2026," GTT KOREA, October 12, 2023. https://www.gttkorea.com/news/articleView.html?idxno=7092
  5. Bob Violino, "'From MongoDB to Couchbase'... Choosing NoSQL that's right for your company," CIOKorea, March 13, 2018. https://www.ciokorea.com/tags/2428/NoSQL/37551
  6. Chul-Ho Kim, Kyeong-Won Park, and Yong-Lak Choi, "Web Service Performance Improvement with the Redis," Journal of the Korea Institute of Information and Communication Engineering, Vol. 19, No. 9, pp. 2064-2072, 2006. http://dx.doi.org/10.4093/jkda.2006.30.2.87
  7. Cristian Andrei BARON, "NoSQL Key-Value DBs Riak and Redis," Database Systems Journal, Vol. 6, No. 4, pp. 3-10, March 3, 2015. https://www.dbjournal.ro/archive/22/22.pdf#page=4
  8. Hong-Jin Park, "A Study about Performance Evaluation of Various NoSQL Databases," Journal of the Korea Institute of Information and Communication Engineering 16-06, Vol. 9, No. 3, pp. 298-305, 2016. https://koreascience.kr/article/JAKO201621650894999.page
  9. Seon Pil Ko, "A Study on Comparative Performance Analysis of RDBMS and NoSQL for Large Data Processing," Domestic Master's Thesis Konkuk University Graduate School of Information and Communication, 2012. https://www.riss.kr/search/detail/DetailView.do?p_mat_type=be54d9b8bc7cdb09&control_no=336823cd83ad1281ffe0bdc3ef48d419&keyword=rdbms%20nosql
  10. Seung Hwan Lee, Jae Min Yun, Donghyun Kwon, Sung Hyun Lee, Dae Gyu Hwang, Ji Weon Kim, and Se Jin Park, "MongoDB, MySQL Performance Comparison for Blind Date App Development," Proceedings of KIIT Conference, pp.1063-1067, 2023. https://www.dbpia.co.kr/journal/articleDetail?nodeId=NODE11485680
  11. Satya Pasupuleti, "Understanding Schema in SQL," Hackernoon, June 15, 2023. https://hackernoon.com/understanding-schema-in-sql
  12. Manuel Silverio, "What Is a Relational Database?," Builtin, December 21, 2022. https://builtin.com/data-science/relational-database
  13. Peter Wayner, "8 Disadvantages of MySQL," CIOKorea, July 17, 2015. https://ciokorea.com/news/26043
  14. Denis Larionov, "NoSQL: System Design Cheat Sheet," Hackernoon, October 31, 2023. https://hackernoon.com/nosql-system-design-cheat-sheet
  15. Alex Williams, "NoSQL Database Types Explained: Column-Oriented Databases," TechTarget, September 22, 2021. https://www.techtarget.com/searchdatamanagement/tip/NoSQL-database-types-explained-Column-oriented-databases
  16. Matthew Tyson, "'Invitation to NoSQL' Introduction to MongoDB for Developers," IT World, July 7, 2021, https://itworld.co.kr/news/200094
  17. Alex Williams, "Key-Value Databases, Explained," KDnuggets, October 4, 2022. https://kdnuggets.com/2021/04/nosql-explained-understanding-key-value-databases.html
  18. Serdar Yegulalp, "Cloud Scale!... NoSQL Compared to SQL," CIOKorea, June 28, 2022. https://ciokorea.com/tags/1988/SQL/242074
  19. A. Bhushan, P. Rastogi, H. K. Sharma and M. E. Ahmed, "I/O and memory management: Two keys for tuning RDBMS," 2016 2nd International Conference on Next Generation Computing Technologies(NGCT), Dehradun, pp. 208-214, 2016. https://ieeexplore.ieee.org/abstract/document/7877416
  20. A. Bhushan, P. Rastogi, H. K. Sharma and M. E. Ahmed, "A Study about Performance Evaluation of Various NoSQL Databases," Journal of the Korean Society of Information, Electronics and Communication Technology Vol. 9, No. 3, pp. 298-305, 2016. https://www.dbpia.co.kr/journal/articleDetail?nodeId=NODE06696379
  21. Eun Ki Kim, "Research on Utilizing NoSQL by Comparison of Processing Large Scale Data in MongoDB and MySQL," Domestic Master's Thesis Soongsil University, 2016. https://www.dbpia.co.kr/journal/detail?nodeId=T14144757