Browse > Article
http://dx.doi.org/10.5626/JOK.2016.43.12.1385

Performance Comparison of PostgreSQL and MongoDB using YCSB  

Kim, Kisung (Bitnine)
Publication Information
Journal of KIISE / v.43, no.12, 2016 , pp. 1385-1395 More about this Journal
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).
Keywords
NoSQL; big data; document store; relational database; PostgreSQL;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Eric A. Brewer, "Towards robust distributed systems (abstract)," Proc. of the nineteenth annual ACM symposium on Principles of distributed computing, pp. 7, 2000.
2 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.
3 Yishan Li, Sathiamoorthy Manoharan, "A performance comparison of SQL and NoSQL databases," IEEE Pacific Rim Conference, pp. 15-19, 2013.
4 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.
5 Zachary Parker, Scott Poe, and Susan V. Vrbsky, "Comparing NoSQL MongoDB to an SQL DB," Proc. of the 51st ACM Southeast Conference, 2013.
6 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.
7 Joonho Kwon, "The recent trend of NoSQL databases," Korea Information Processing Society Review, Vol. 22, No. 4, 2015. (in Korean)
8 Michael Stonebraker, "New opportunities for New SQL," Communications of the ACM, Vol. 55, No. 11, pp. 10-11, 2012.   DOI
9 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.
10 Benchmarking Top NoSQL Databases, white paper. END POINT, 2015.
11 Dan Pritchett, "BASE: An acid alternative," Queue, Vol. 6, No. 3, pp. 48-55, May 2008.   DOI
12 Pramod J. Sadalage and Martin Fowler. NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Addison-Wesley Professional, 2012.
13 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.
14 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.