Maximizing Bigdata Retrieval: Block as a Value for NoSQL over SQL
Document Type
Conference Proceeding
Publication Date
1-1-2022
Publication Title
Proceedings of the 2022 IEEE/ACM International Conference on Advances in Social Networks Analysis and Mining, ASONAM 2022
First Page
556
Keywords
BigData, Block as a Value, NoSQL, Relational Database
Last Page
563
Abstract
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
DOI
10.1109/ASONAM55673.2022.10068692
ISBN
9781665456616
Recommended Citation
Gidado, Abdulrauf and Ezeife, C. I.. (2022). Maximizing Bigdata Retrieval: Block as a Value for NoSQL over SQL. Proceedings of the 2022 IEEE/ACM International Conference on Advances in Social Networks Analysis and Mining, ASONAM 2022, 556-563.
https://scholar.uwindsor.ca/computersciencepub/63