DOI QR코드

DOI QR Code

A Study about Performance Evaluation of Various NoSQL Databases

다양한 NoSQL 데이터베이스의 성능 평가 연구

  • Park, Hong-Jin (School of Computer, Information and Communication Engineering, SangJi University)
  • 박홍진 (상지대학교 컴퓨터정보공학부)
  • Received : 2016.06.14
  • Accepted : 2016.06.21
  • Published : 2016.06.30

Abstract

Various NoSQL databases are more excellent to process a large amount of big data than existing relational databases such as MySQL, PostgreSQL and Oracle. Among widely used NoSQL databases, performance of HBase, Cassandra, MongoDB and Redis was comparatively assessed. For distributed processing of a large amount of data, 12 servers were connected through switching hub and Ubuntu was installed as operating system. As for benchmark tool, YCSB was applied. Read and update ratios changed from 50% and 50%, 95% and 5% and finally, 100% and 0% and each of them was assessed as 200,000 commands developed into 1,200,000 commands for each case. Cassandra was most excellent with transaction processing per second while MongoDB was most excellent with the number of processes carried out per unit time.

대용량의 데이터를 처리하기 위해서는 기존 관계형 데이터베이스인 MySQL, PostgreSQL, Oracle등 보다 NoSQL 데이터베이스가 우수함을 나타내고 있다. 본 논문은 일반적으로 널리 사용되고 있는 NoSQL 데이터베이스 중 HBase, Cassandra, MongoDB, Redis의 성능을 비교 평가한다. 본 논문에서 대용량의 데이터를 분산 처리하기 위해 서버 12대를 스위칭 허브를 통해 연결하였으며 운영체제로 우분투를 설치하였다. 벤치마킹 도구로는 YCSB를 이용하였으며, read, update를 각각 50%, 50%, 두 번째로는 95%, 5%, 마지막으로는 100%, 0%로 3가지로 변경하였고, 200,000번에서 1,200,000 까지 명령어를 수행하여 비교 평가하였다. 초당 트랜젝션 처리는 Cassandra가 가장 우수하였고, 단위 시간당 프로세스 수행 처리 개수는 MongoDB가 우수함을 보였다.

Keywords

References

  1. Jing Han, "Survey on NoSQL database", Proceedings of the International Conference on Pervasive Computing and Applications (ICPCA), 2011.
  2. Ameya Nayak, Anil Poriya, Dikshay Poojary, "Type of NOSQL Databases and its Comparison with Relational Databases", International Journal of Applied Information Systems, Vol. 5, No. 4, Mar. 2013.
  3. Rick Cattell, "Scalable SQL and NoSQL data stores", ACM SIGMOD, Vol. 39, Issue 4, Dec. 2010.
  4. Barbierato, E., Gribaudo, M., Iacono, M., "Performance evaluation of NoSQL big-data applications using multi-formalism models", Vol. 37, Future generations computer systems, 2014.
  5. Jorge Bernardino, "NoSQL databases: MongoDB vs cassandra", Proceedings of the International Conference on Computer Science and Software Engineering, 2013.
  6. A. Gandini, M. Gribaudo, W. J. Knottenbelt, R. Osman, P. Piazzolla, "Performance Evaluation of NoSQL Databases", No. 8721, Lecture Notes in Computer Science, 2014.
  7. Bogdan George Tudorica, "A comparison between several NoSQL databases with comments and notes", Proceedings of the International Conference on Networking in Education and Research, 2011.
  8. Mehul Nalin Vora, "Hadoop-HBase for large-scale data", Proceedings of the International Conference on Computer Science and Network Technology, 2011.
  9. Guoxi Wang, Jianfeng Tang, "The NoSQL Principles and Basic Application of Cassandra Model", Proceedings of the International Conference on Computer Science & Service System, 2012.
  10. https://www.mongodb.com/
  11. http://www.redis.io/

Cited by

  1. HL7 FHIR 기반 의료 데이터 처리 시스템에서 YCSB를 통한 RDBMS와 MongoDB의 성능 분석 연구 vol.21, pp.8, 2016, https://doi.org/10.9717/kmms.2018.21.8.934