Affiliation:
1. Department of Informatics and Computer Science, Escuela Politécnica Nacional, Quito 170525, Ecuador
2. Department of Software and Computing Systems, University of Alicante, 03690 Alicante, Spain
Abstract
The growing importance of data analytics is leading to a shift in data management strategy at many companies, moving away from simple data storage towards adopting Online Analytical Processing (OLAP) query analysis. Concurrently, NoSQL databases are gaining ground as the preferred choice for storing and querying analytical data. This article presents a comprehensive, systematic mapping, aiming to consolidate research efforts related to the integration of OLAP with NoSQL databases in Big Data environments. After identifying 1646 initial research studies from scientific digital repositories, a thorough examination of their content resulted in the acceptance of 22 studies. Utilizing the snowballing technique, an additional three studies were selected, culminating in a final corpus of twenty-five relevant articles. This review addresses the growing importance of leveraging NoSQL databases for OLAP query analysis in response to increasing data analytics demands. By identifying the most commonly used NoSQL databases with OLAP, such as column-oriented and document-oriented, prevalent OLAP modeling methods, such as Relational Online Analytical Processing (ROLAP) and Multidimensional Online Analytical Processing (MOLAP), and suggested models for batch and real-time processing, among other results, this research provides a roadmap for organizations navigating the integration of OLAP with NoSQL. Additionally, exploring computational resource requirements and performance benchmarks facilitates informed decision making and promotes advancements in Big Data analytics. The main findings of this review provide valuable insights and updated information regarding the integration of OLAP cubes with NoSQL databases to benefit future research, industry practitioners, and academia alike. This consolidation of research efforts not only promotes innovative solutions but also promises reduced operational costs compared to traditional database systems.
Reference48 articles.
1. Agrawal, D., Das, S., and El Abbadi, A. (2011, January 21–24). Big Data and cloud computing: Current state and future opportunities. Proceedings of the International Conference on Extending Database Technology, Uppsala, Sweden.
2. Hai, B., Quix, C., and Jarke, M. (2021). Data lake concept and systems: A survey. arXiv.
3. A review data cube analysis method in big data environment;Ghazali;ARPN J. Eng. Appl. Sci.,2015
4. Golfarelli, M., and Rizzi, S. (2017). From Star Schemas to Big Data: 20 Years of Data Warehouse Research—A Comprehensive Guide through the Italian Database Research over the Last 25 Years, Springer.
5. Data Warehousing and OLAP over Big Data: A Survey of the State-of-the-art, Open Problems and Future Challenges;Cuzzocrea;Int. J. Bus. Process Integr. Manag.,2015