Performance evaluation for CRUD operations in asynchronously replicated document oriented database

TL;DR

This paper evaluates the performance of CRUD operations in asynchronously replicated document-oriented NoSQL databases, comparing them with relational databases to assess scalability and efficiency in distributed environments.

Contribution

It provides a comparative analysis of CRUD operation performance in MongoDB, CouchDB, and Couchbase under asynchronous replication, highlighting their scalability and efficiency.

Findings

NoSQL databases show different performance profiles under asynchronous replication.

Distributed environments impact CRUD operation execution times.

Relational databases are included for performance benchmarking.

Abstract

NoSQL databases are becoming increasingly popular as more developers seek new ways for storing information. The popularity of these databases has risen due to their flexibility and scalability needed in domains like Big Data and Cloud Computing. This paper examines asynchronous replication, one of the key features for a scalable and flexible system. Three of the most popular Document-Oriented Databases, MongoDB, CouchDB, and Couchbase, are examined. For testing, the execution time for CRUD operations for a single database instance and for a distributed environment with two nodes is taken into account and the results are compared with tests outcomes obtained for three relational database management systems: Microsoft SQL Server, MySQL, and PostgreSQL.