The single data warehouse repository simply could not support any and all analytics anymore. A new architectural concept called the Extended Data Warehouse architecture (XDW) has taken the place of the single repository idea. It accommodates the new forms and volumes of data, the need for different sub-environments for varying analytical requirements, and the immensely innovative technologies available today.
In this paper, we focus on the DWA and how it has evolved over the years since its introduction. The XDW architecture is then described, in which the need to maintain the data warehouse is documented while adding new components and capabilities to extend the analytical capabilities. This section also discusses the appropriate usage of
appliances within the XDW. The rest of the paper covers the benefits from implementing the DWA, the selection considerations for them and what the future holds for them.