Search engine for discovering works of Art, research articles, and books related to Art and Culture
Javascript must be enabled to continue!
A Formal OLAP Algebra for NoSQL based Data Warehouses
View through CrossRef
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.
International Association for Educators and Researchers (IAER)
Title: A Formal OLAP Algebra for NoSQL based Data Warehouses
Description:
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.
Related Results
Querying data warehouses efficiently using the Bitmap Join Index OLAP Tool
Querying data warehouses efficiently using the Bitmap Join Index OLAP Tool
Data warehouse and OLAP are core aspects of business intelligence environments, since the former store integrated and time-variant data, while the latter enabl...
Physical database design in document stores
Physical database design in document stores
NoSQL is an umbrella term used to classify alternate storage systems to the traditional Relational Database Management Systems (RDBMSs). Among these, Document stores have gained po...
Graph data warehousing
Graph data warehousing
Over the last decade, we have witnessed the emergence of networks in a wide spectrum of application domains, ranging from social and information networks to biological and transpor...
Studi Literatur Komparasi SQL dan NoSQL dalam Pemilihan Basis Data Ideal untuk Skalabilitas Tinggi
Studi Literatur Komparasi SQL dan NoSQL dalam Pemilihan Basis Data Ideal untuk Skalabilitas Tinggi
This research compares SQL and NoSQL databases in terms of high scalability and data management efficiency. SQL, with its relational model and ACID principles, excels in data consi...
NoSQL databases: A survey
NoSQL databases: A survey
NoSQL data stores have introduced a new way of designing database systems to meet the recent needs of applications and services operating in areas such as the World Wide Web, Big D...
Domain kognitif dan pencapaian ungkapan algebra dalam kalangan pelajar Tingkatan Dua
Domain kognitif dan pencapaian ungkapan algebra dalam kalangan pelajar Tingkatan Dua
Algebra merupakan salah satu topik yang sukar dalam pembelajaran Matematik khususnya di peringkat Menengah Rendah. Permasalahan pelajar dalam topik Algebra sering dikaitkan dengan ...
Analysis of NoSQL Database Vulnerabilities
Analysis of NoSQL Database Vulnerabilities
The NoSQL DBMS offers efficient solutions for storing and analyzing big data. The NoSQL data model provides better flexibility, schema less model, efficient storage and access mech...
Modélisation NoSQL des entrepôts de données multidimensionnelles massives
Modélisation NoSQL des entrepôts de données multidimensionnelles massives
Les systèmes d’aide à la décision occupent une place prépondérante au sein des entreprises et des grandes organisations, pour permettre des analyses dédiées à la prise de décisions...