Maximizing Bigdata Retrieval: Block as a Value for NoSQL over SQL

Document Type

Conference Proceeding

Publication Date


Publication Title

Proceedings of the 2022 IEEE/ACM International Conference on Advances in Social Networks Analysis and Mining, ASONAM 2022

First Page



BigData, Block as a Value, NoSQL, Relational Database

Last Page



This paper presents NoSQL Over SQL Block as a Value Database (NOSD), a system that speeds up data retrieval time and availability in very large relational databases. NOSD proposes a Block as a Value model (BaaV). Unlike a relational database model where a relation is R(K, A1,A2, An), with a key attribute K and a set of attributes of the relation: A1, A2, An, BaaV represents a relation R(K, r1, r2, rn) with a key attribute K and a set of n relations called blocks. Each r contains a set of its own attributes denoted as r(k, a1,a2, an) with a key attribute k and a set of n attributes. The relations r1, r2, rn in R are related through foreign key relationships to a super relation R with primary key K. The BaaV model is then denoted in a keyed block format R K, B, where K is a key to a block of values B of partial relations implemented on NoSQL databases and replicating existing large relational database systems. As opposed to conventional systems such as Zidian, Google's Spanner, SparkSQL and Simple Buttom-Up (SBU) which implement SQL over NoSQL and replicate data into different nodes, NOSD implements NoSQL over SQL and uses Lucene functionality on NoSQL to enhance data retrieval costs. Experimenting with our proposed model, we demonstrated the performance of NOSD under the following conditions to prove its novelty (a) scan free queries, and (b) bounded queries on NoSQL databases. We showed that NOSD (a) performs excellently than ordinary relational databases (b) guarantees no scans for no scan queries (c) allows parallelization in query execution, and (d) can be deployed into existing SQL databases with guaranteed horizontal scalability, data retention and accurate autonomous data replication. Using existing benchmark systems, we demonstrated that NOSD outperforms existing SQL databases, SQL over NoSQL systems and is novel in ensuring that existing large SQL database systems utilize the functionalities of NoSQL databases without data loss. A1, A2, An