A Formal OLAP Algebra for NoSQL based Data Warehouses-Reference-Cited by-同舟云学术

A Formal OLAP Algebra for NoSQL based Data Warehouses

Published:2021-03-20 Issue:5 Volume:5 Page:154-161
ISSN:2516-029X
Container-title:Annals of Emerging Technologies in Computing
language:en
Short-container-title:AETiC

Author:

Banerjee Shreya,Bhaskar Sourabh,Sarkar Anirban,Debnath Narayan C.

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.

Publisher

International Association for Educators and Researchers (IAER)

Subject

Electrical and Electronic Engineering,General Computer Science

Reference14 articles.

1. Bicevska Z., and Oditis I. (2017). Towards NoSQL-based Data Warehouse Solution, In ICTE 2016, Procedia Computer Science, Riga Technical University, pp. 104-111, Latvia, doi: 10.1016/j.procs.2017.01.080.

2. Chevalier M., Malki M. El, Kopliku A., Teste O., and Tournier R. (2015). Benchmark for OLAP on NoSQL technologies comparing NoSQL multidimensional data warehousing solution. In 9th Int. Conf. on Research Challenges in Information Science (RCIS), IEEE, pp. 480-485, Athens, DOI: 10.1109/RCIS.2015.7128909.

3. Oditis I., Bicevska Z., Bicevskis J., and Karnitis G. (2018). Implementation of NoSQL-based Data Warehouses, Baltic Journal of Modern Computing. Riga. vol. 6, no. 1, pp. 45-55, DOI: 10.22364/bjmc.2018.6.1.04.

4. Hecht R., and Jablonski S. (2011). NoSQL evaluation: A use case oriented survey. In Cloud and Service Computing (CSC '11), IEEE Computer Society, pp. 336-341, Hong Kong, China, DOI: 10.1109/CSC.2011.6138544.

5. Xu J., Shi M., Chen C., Zhang Z., Fu J., and Liu C.H. (2016). ZQL: A Unified Middleware Bridging Both Relational and NoSQL Databases. In 14th Int. Conf. on Dependable, Autonomic and Secure Comp., 14th Int. Conf. on Pervasive Intelligence and Comp., 2nd Intl Conf. on Big Data intelligence and Comp. and Cyber ScienceandTechnologyCongress (DASC/ PiCom/ DataCom/ CyberSciTech), IEEE, pp. 730-737, Auckland, DOI: 10.1109/DASC-PICom-DataCom-CyberSciTec.2016.129.

Cited by 2 articles. 订阅此论文施引文献订阅此论文施引文献，注册后可以免费订阅5篇论文的施引文献，订阅后可以查看论文全部施引文献

1. Initial Optimization Techniques for the Cube Algebra Query Language;International Journal of Data Warehousing and Mining;2022-08-18

2. A Natural Language Interface to Relational Databases Using an Online Analytic Processing Hypercube;AI;2021-12-18