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.
Highlights
Modern Data Warehouses (DW) solutions demand to act more in internet-style than to enforce the user to act within predefined structures [1]
This paper proposed a universal On Line Analytical Processing (OLAP) interface for disparate NoSQL based DWs
The main contribution of the proposed work is to provide uniform precise syntax and semantics towards different OLAP operators and operations. These proposed formal specifications are independent of any physical level implementation
Summary
Received: 17th October 2020; Accepted: 15th November 2020; Published: 20th March 2021 Abstract: NoSQL solutions are started to be increasingly used in modern days’ Data Warehouses (DW). 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. 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. The proposed formal specifications are implemented in a document-oriented database using a suitable case study. The proposed approach aids efficient visualization techniques of data cubes over NoSQL based DWs
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have