Journal of KIISE (정보과학회 논문지)

Korean Institute of Information Scientists and Engineers (한국정보과학회)
권호 표지
DOI QR코드

DOI QR Code

Performance Comparison of PostgreSQL and MongoDB using YCSB

YCSB를 사용한 PostgreSQL과 MongoDB 성능 비교 분석

  • Received : 2016.07.26
  • Accepted : 2016.09.08
  • Published : 2016.12.15
⟨ Previous Next ⟩

Abstract

In the era of Big Data, NoSQL databases provide solutions for problems, circumventing the limitations of traditional relational databases by using new architectures and data model. Contrary to relational database products, the range of the features architectures, and limitations of NoSQL databases is very broad. Thus, choosing the right database products requires more considerations and difficulties. The advent of NoSQL does not only promote the abundance of NoSQL products, but also stimulates the relational database realm to expand their features beyond the relational model. In order to understand NoSQL trends more accurately, here we discuss and compare NoSQL databases with relational databases. We also present the newest features associated with NoSQL in one of the most advanced open-source relational databases, PostgreSQL. To discuss future directions for PostgreSQL we analyzed the performance of NoSQL and PostgreSQL by conducting experiments using the NoSQL benchmark tool (YCSB).

빅데이터와 함께 등장한 NoSQL은 기존 관계형 데이터베이스로는 해결하기 힘든 문제를 새로운 아키텍처와 데이터 모델로 해결하고자 한다. 관계형 데이터베이스와는 달리 NoSQL 데이터베이스는 기능과 아키텍처 그리고 한계점이 제품마다 다르기 때문에 NoSQL 데이터베이스를 선택하기 위해서는 많은 고려사항이 필요하다. 이렇게 데이터베이스의 선택의 폭이 넓어진 만큼 선택의 어려움은 더욱 증가했다고 볼 수 있다. 또한 NoSQL 데이터베이스의 발전은 기존의 관계형 데이터베이스의 기능을 확장하는 데도 기여했다. 본 논문에서는 NoSQL 데이터베이스를 보다 정확히 이해하기 위해 관계형 데이터베이스와 비교 분석하고 오픈 소스 관계형 데이터베이스인 PostgreSQL의 최신 NoSQL 관련 기능에 대해 알아본다. 또한 NoSQL 데이터베이스 벤치마크(YCSB)를 사용해 NoSQL과 PostgreSQL의 성능을 비교하고 앞으로의 발전 방향에 대해서 논한다.

Keywords

Acknowledgement

Grant : PostgreSQL 기반의 오픈소스 DBMS 연구 및 개발

Supported by : 중소기업청

References

  1. Pramod J. Sadalage and Martin Fowler. NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Addison-Wesley Professional, 2012.
  2. Avrilia Floratou, Nikhil Teletia, David J. DeWitt, Jignesh M. Patel, and Donghui Zhang, "Can the elephants handle the NoSQL onslaught?," Proc. of the VLDB Endowment, Vol. 5, No. 12, pp. 1712-1732, Aug. 2012.
  3. Michael Stonebraker, Samuel Madden, Daniel J. Abadi, Stavros Harizopoulos, Nabil Hachem, and Pat Helland, "The end of an architectural era," Proc. of the 33rd international conference on Very large data bases, pp. 1150-1160, 2007.
  4. Dan Pritchett, "BASE: An acid alternative," Queue, Vol. 6, No. 3, pp. 48-55, May 2008. https://doi.org/10.1145/1394127.1394128
  5. Eric A. Brewer, "Towards robust distributed systems (abstract)," Proc. of the nineteenth annual ACM symposium on Principles of distributed computing, pp. 7, 2000.
  6. Robin Hecht, Stefan Jablonski, "NoSQL evaluation: A use case oriented survey," Proc. of the 2011 International Conference on Cloud and Service Computing, pp. 336-341, 2011.
  7. Yishan Li, Sathiamoorthy Manoharan, "A performance comparison of SQL and NoSQL databases," IEEE Pacific Rim Conference, pp. 15-19, 2013.
  8. Andrea Gandini, Marco Gribaudo, William J. Knottenbelt, Rasha Osman, and Pietro Piazzolla, "Performance Evaluation of NoSQL Databases," Proc. of computer performance engineering: 11th European workshop, pp. 16-29, 2014.
  9. Zachary Parker, Scott Poe, and Susan V. Vrbsky, "Comparing NoSQL MongoDB to an SQL DB," Proc. of the 51st ACM Southeast Conference, 2013.
  10. Alexandru Boicea, Florin Radulescu, and Laura Ioana Agapin, "MongoDB vs Oracle -- Database Comparison," Proc. of the Fourth International Conference on Emerging Intelligent Data and Web Technologies, pp. 330-335, 2012.
  11. Joonho Kwon, "The recent trend of NoSQL databases," Korea Information Processing Society Review, Vol. 22, No. 4, 2015. (in Korean)
  12. Michael Stonebraker, "New opportunities for New SQL," Communications of the ACM, Vol. 55, No. 11, pp. 10-11, 2012. https://doi.org/10.1145/2366316.2366319
  13. Brian F. Cooper, Adam Silberstein, Erwin Tam, Raghu Ramakrishnan, and Russell Sears, "Benchmarking Cloud Serving Systems with YCSB," Proc. of the 1st ACM symposium on Cloud computing, pp. 143-154, 2010.
  14. Benchmarking Top NoSQL Databases, white paper. END POINT, 2015.