A Comparative Analysis of Materialized Views Selection and Concurrency Control Mechanisms in NoSQL Databases

Abstract

Abstract-Increasing resource demands require relational databases to scale. While relational databases are well suited for vertical scaling, specialized hardware can be expensive. Conversely, emerging NewSQL and NoSQL data stores are designed to scale horizontally. NewSQL databases provide ACID transaction support; however, joins are limited to the partition keys, resulting in restricted query expressiveness. On the other hand, NoSQL databases are designed to scale out linearly on commodity hardware; however, they are limited by slow join performance. Hence, we consider if the NoSQL join performance can be improved while ensuring ACID semantics and without drastically sacrificing write performance, disk utilization and query expressiveness. This paper presents the Synergy system that leverages schema and workload driven mechanism to identify materialized views and a specialized concurrency control system on top of a NoSQL database to enable scalable data management with familiar relational conventions. Synergy trades slight write performance degradation and increased disk utilization for faster join performance (compared to standard NoSQL databases) and improved query expressiveness (compared to NewSQL databases). Experimental results using the TPC-W benchmark show that, for a database populated with 1M customers, the Synergy system exhibits a maximum performance improvement of 80.5% as compared to other evaluated systems.

Recovery and Concurrency Challenging in Big Data and NoSQL Database Systems

“…On the other side, the study now discuses the concurrency control that addressed as challenged area in the NOSQL. According to [4], they handled concurrency control issue in NOSQL DBMS by applying the Synergy system technique. The main purpose of proposing the synergy system is to improve performance in NOSQL databases using Materialized views (MVs) and a specialized system for concurrency control based on the top.…”

“…Organizations now a day are mainly founded on the NoSQL database and this lead to the need of protecting the data used and highlighted that there is a huge gap in data fortification. As for concurrency in the NoSQL systems it has been highlighted that the existing concepts of concurrency control don't work well with scaling even though the traditional techniques can be used it still reduces the performance of NoSQL systems [4]. Even though the concept of replication in big data NoSQL helps a lot in the process of recovery but yet a more robust recovery and backup approach is still needed.…”

ProRes: Proactive re-selection of materialized views

“…Selection of materialized views is a challenging task for designing advanced database applications such as Analytical Databases [23], Autonomous Databases [2], Semantic Databases [21], Cloud Databases [9] and NoSQL Databases [56]. The idea of using materialized views to satisfy the quality-of-service of databases does not date from today, but since forty years [33].…”