No abstract

No abstract

NoSQL solutions are started to be increasingly used in modern days’ Data Warehouses (DW). However, business analysts face challenges when performing On Line Analytical Processing (OLAP) queries on these NoSQL systems. The lack of uniform representation of various OLAP operations over different types of NoSQL based DWs is one of them. In addition, deficiency of precise semantics in OLAP operations create obstacles to effective query interpretation over distinct types DWs. This paper is aiming to deal with aforementioned challenges. Formal and rigorous specification are represented in this paper for different kinds of OLAP operators and operations. These precise specifications are capable to analyse business queries. Further, the proposed formal specifications are implemented in a document-oriented database using a suitable case study. In addition, the proposed approach aids efficient visualization techniques of data cubes over NoSQL based DWs.

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.

No abstract