Comparative Study and Analysis of Federated and Non-federated Data Warehouse Architecture

Abstract

Data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis. A data warehouse houses standardized, consistent, clean and integrated form of data sourced from various operational systems in use in the organization, structured in a way to specially address the reporting and analytic requirements. In this paper we performed a comparative analysis of federated vs other architectures to find their usefulness in business. We investigated thoroughly the advantages and disadvantages to clearly distinguish the various organizationally implemented data warehouse architectures.