Enhancement of database access performance by improving data consistency in a non-relational database system (NoSQL)

Adam A. E. Alflahi,Mohammed A. Y. Mohammed,Abdallah Alsammani
2023-08-27
Abstract:This study aims to enhance data consistency in NoSQL databases, traditionally designed with BASE properties, as opposed to the strong consistency guaranteed by ACID principles in RDBMS. We introduce a comprehensive four-stage server-side model engineered explicitly for MongoDB. This model covers transaction management, bifurcation of read and write transactions, assessment of transaction readiness, and transaction execution via a specialized locking algorithm. Utilizing the Yahoo Cloud Services Benchmark (YCSB), particularly for update-heavy workloads (A, B, and F), our model exhibited significant improvements. Specifically, the average throughput, read, and update latencies improved to 2864.726 ms, 32806.275 ms, and 51845.629 ms, respectively, from the baseline metrics of 2914.110 ms, 26510.930 ms, and 32457.662 ms. These results demonstrate the efficacy of our proposed model in enhancing consistency not only in document-based NoSQL databases like MongoDB but also in other NoSQL database variants, including key-value, graph, and wide-column stores.
Databases
What problem does this paper attempt to address?
The paper aims to address the issue of data consistency in NoSQL databases. Specifically, NoSQL databases are typically designed with BASE properties (Basically Available, Soft state, Eventually consistent), whereas traditional Relational Database Management Systems (RDBMS) ensure ACID properties (Atomicity, Consistency, Isolation, Durability), providing stronger data consistency. The paper proposes a server-side four-phase model optimized specifically for MongoDB. This model includes transaction management, read-write transaction separation, transaction preparedness assessment, and transaction execution through a dedicated locking algorithm. Researchers utilized the Yahoo Cloud Services Benchmark (YCSB) tool to benchmark update-intensive workloads (A, B, and F). The results showed significant improvements in average throughput, read latency, and update latency after implementing the proposed model. Furthermore, the model is not only applicable to document-based NoSQL databases like MongoDB but may also be suitable for other types of NoSQL databases, such as key-value stores, graph databases, and wide-column stores. In summary, the main objective of the paper is to enhance data consistency in NoSQL databases by introducing a new transaction processing mechanism, thereby improving data reliability in commercial cloud storage environments while maintaining the flexibility and scalability of NoSQL databases.