Response Times Comparison of MongoDB and PostgreSQL Databases in Specific Test Scenarios

Abstract

Today, phones, tablets, commercial software, and many different devices are constantly generating data. These produced data should be accessed later on, such as software in business processes or business intelligence. Therefore, these generated data must be stored. There are many popular ways to store data constantly growing in size. All these options come with certain advantages and disadvantages. In this study, a performance comparison will be made between the PostgreSQL database, which is one of the relational databases used for data storage for many years, and the MongoDB database, which is one of the document databases, which has become increasingly popular in recent years, in certain test scenarios. In addition, the properties of relational databases and document databases are given. As a result of the study, similar data and test scenarios created in two databases and different test scenarios in terms of performance were examined, and response times were compared. © 2022, ICST Institute for Computer Sciences, Social Informatics and Telecommunications Engineering.