Abstract
These days, NoSQL (Not only SQL) databases are being used as a deployment tool for Data Warehouses (DW) due to its support for dynamic and scalable data modeling capabilities. Yet, decision-makers have faced several challenges to accept it as a major choice for implementation of their DW. The most significant one among those challenges is a lack of common conceptual model and a systematic design methodology for different NoSQL databases. The objective of this paper is to resolve these challenges by proposing an ontology based formal conceptual model for NoSQL based DWs. These proposed concepts are capable of realizing the cube concepts for visualization of multi-dimensional data in NoSQL based DW solutions. In this context, two strategies are specified, implemented and illustrated using a case study for devising of the proposed conceptual model.
Highlights
Over the last few years, NoSQL databases have achieved strong popularity
In [1], [9,10,11] authors have described a conceptual model for NoSQL based On Line Analytical Processing (OLAP) systems that can be mapped towards either Column or Document oriented Data Warehouses (DW) using a set of rules
Proposed conceptual model is consisting of group of constructs, relationships and a number of significant properties to unify conceptual level representations of different NoSQL based DW solutions
Summary
Received: 17th October 2020; Accepted: 17th November 2020; Published: 20th March 2021 Abstract: These days, NoSQL ( SQL) databases are being used as a deployment tool for Data Warehouses (DW) due to its support for dynamic and scalable data modeling capabilities. The most significant one among those challenges is a lack of common conceptual model and a systematic design methodology for different NoSQL databases. The objective of this paper is to resolve these challenges by proposing an ontology based formal conceptual model for NoSQL based DWs. The objective of this paper is to resolve these challenges by proposing an ontology based formal conceptual model for NoSQL based DWs These proposed concepts are capable of realizing the cube concepts for visualization of multi-dimensional data in NoSQL based DW solutions. In this context, two strategies are specified, implemented and illustrated using a case study for devising of the proposed conceptual model
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Free) 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
