 NoSQL-based approach in data warehousing and OLAP cube computationAbdelhak Khalil and Mustapha Belaissaoui International Journal of Information and Decision Sciences, 2023, vol. 15, issue 4, 408-430 Abstract: Over the last few years, Not only SQL (NoSQL) databases are gaining increasingly significant ground and are considered as the future of data storage. In this paper, we are interested in implementing NoSQL-OLAP systems by defining mapping rules from the multidimensional conceptual level to logical key-value model, and providing a set of online analysis operators. We consider two different approaches in order to implement a big data warehouse within key value stores. The first one uses SQL-like table structure layered on top of the key-value schema, the second one uses a simple key-value pair structure. Then we provide aggregation operators (Map-Reduce Cube and Bit-Encoded Cube) for key value models in order to perform OLAP cube computation. We implemented OLAP operator using Oracle NoSQL database and LevelDB, and we conducted experiments on a fictional data warehouse produced by an existing benchmark that considers NoSQL models. Thus, results showed clearly the performance of OLAP implementations under NoSQL key value stores in terms of efficiency and scalability. Keywords: OLAP; data warehouse; NoSQL; big data; cube model. (search for similar items in EconPapers) Downloads: (external link) Related works: Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text Persistent link: https://EconPapers.repec.org/RePEc:ids:ijidsc:v:15:y:2023:i:4:p:408-430 Access Statistics for this article More articles in International Journal of Information and Decision Sciences from Inderscience Enterprises Ltd |
Is your work missing from RePEc? Here is how to contribute.
Questions or problems? Check the EconPapers FAQ or send mail to .
EconPapers is hosted by the
School of Business at Örebro University.