Analysis of Data Warehouse Architectures: Modeling and Classification

Abstract

With decades of development and innovation, data warehouses and their architectures have been extended to a variety of derivatives in various environments to achieve different organisations' requirements. Although there are some ad-hoc studies on data warehouse architecture (DWHA) investigations and classifications, limited research is relevant to systematically model and classify DWHAs. Especially in the big data era, data is generated explosively. More emerging architectures and technologies are leveraged to manipulate and manage big data in this domain. It is therefore valuable to revisit and investigate DWHAs with new innovations. In this paper, we collect 116 publications and model 73 disparate DWHAs using Archimate, then 9 representative DWHAs are identified and summarised into a "big picture". Furthermore, it proposes a new classification model sticking to state-of-the-art DWHAs. This model can guide researchers and practitioners to identify, analyse and compare differences and trends of DWHAs from componental and architectural perspectives.

Strategies for Leveraging Big Data and Analytics for Business Development: A Comprehensive Review Across Sectors

“…al., 2020, Gagalova, et. al., 2020, Yang, Ge & Helfert, 2019. Statistical analysis involves applying statistical methods to data to uncover patterns, trends, and relationships.…”

Aggregation of multidimensional data for the decision support process for the management of microgrids with renewable energy sources

“…A data warehouse is a domain-specific, integrated, nonvolatile data set that changes over time and supports the ability to manage decision-making [3]. It includes five main components: data sources, data extraction processes, central repository, data marts, and data access and analysis tools [4].…”