Comparative Analysis of the Performance of SQL and NOSQL DBMS
Abstract
NoSQL database management systems have been under examination by industry specialists for quite some time. However, at the moment there are very few works connected with this topic, and in particular - with the comparison of such systems with traditional relational DBMSs. As for the existing studies, some articles are plain overviews, some use a small number of records in tables as a workload or they only consider one environment for conducting experiments, which can give advantage to one of the comparison objects. This paper is concerned with PostgreSQL and MongoDB. The first system, despite being free and open-source software, is rapidly gaining popularity even in the corporate world, whereas the second one differs from a large number of NoSQL solutions in its meticulousness and support. In order to ensure the completeness of the comparison, the experiments were carried out in different environments and with different loads.
References
//www.strozzi.it/cgi-bin/CSA/tw7/I/en_US/nosql/Home%20Page (дата обращения: 15.06.2017).
2. Бэнкер К. MongoDB в действии. М.: ДМК Пресс, 2012.
3. MongoDB Production Deployments [Электронный ресурс]. URL: http://www.mongodb.org/about/
production-deployments (дата обращения: 15.06.2017).
4. Plattner H. A common database approach for OLTP and OLAP using an in-memory column database //
Proceedings of the 2009 ACM SIGMOD International Conference on Management of data. P. 1–2.
5. Abramova V. et al. Which NoSQL Database? A Performance, Overview // Open Journal of Databases
(OJDB), Vol. 1, Is. 2, 2014. Lubeck: RonPub. P. 17 ¨ –24.
6. Cattell R. Scalable SQL and NoSQL data stores // ACM SIGMOD Record, Vol. 39 Is. 4, December 2010.
NY: ACM New York. P. 12–27.
7. Parker Z. et al. Comparing NoSQL MongoDB to an SQL DB, Proceedings of the 51st ACM Southeast
Conference. NY: ACM New York, 2013.
8. Postgres Outperforms MongoDB and Ushers in New Developer Reality [Электронный ресурс]. URL:
http://www.enterprisedb.com/postgres-plus-edb-blog/marc-linster/postgres-outperforms-mongodband-ushers-new-developer-reality/
(дата обращения: 15.06.2017).
9. Data generator: free tool to generate test data. [Электронный ресурс]. URL: http://www.
yandataellan.com/ (дата обращения: 15.06.2017).
10. Release Notes for MongoDB 3.2 — MongoDB Manual 3.2 [Электронный ресурс]. URL: https://docs.
mongodb.org/manual/release-notes/3.2/#aggregation-framework-enhancements (дата обращения:
15.06.2017).
11. Overview. Postgres-XL [Электронный ресурс]. URL: http://www.postgres-xl.org/overview/ (дата об-
ращения: 15.06.2017).
12. ToroDB. 8KData [Электронный ресурс]. URL: https://www.8kdata.com/torodb (дата обращения:
15.06.2017).
13. Доклады конференции PgConfRussia 2016: CitusDB: расширение для масштабирования
PostgreSQL [Электронный ресурс]. URL: http://www.postgres-xl.org/overview/ (дата обращения:
15.06.2017).
14. Облачные серверы и хостинг Elastic Compute Cloud (EC2) — AWS [Электронный ресурс]. URL:
http://aws.amazon.com/ru/ec2/ (дата обращения: 15.06.2017).
15. Internet Engineering Task Force (IETF). The JavaScript Object Notation (JSON) Data Interchange
Format [Электронный ресурс]. URL: https://tools.ietf.org/html/rfc7159 (дата обращения:
15.06.2017).
16. JSON and BSON | MongoDB [Электронный ресурс]. URL: https://docs.mongodb.com/v3.0/reference/
bson-types/ (дата обращения: 15.06.2017).
17. Lerner R. M. At the forge: PostgreSQL, the NoSQL database // Linux Journal. 2014. № 247. P. 3–6.
18. PostgreSQL 9.6: Documentation: 9.6: JSON Types [Электронный ресурс]. URL: https://www.
postgresql.org/docs/9.6/static/datatype-json.html/ (дата обращения: 15.06.2017).
This work is licensed under a Creative Commons Attribution 4.0 International License.
