What Is Data Warehouse Architecture?
Data warehouse architecture is a design that encapsulates all the facets of data warehousing for an enterprise environment. Data warehousing is the creation of a central domain to store complex, decentralized enterprise data in a logical unit that enables data mining, business intelligence, and overall access to all relevant data within an organization. Data warehouse architecture is inclusive of all reporting requirements, data management, security requirements, band width requirements, and storage requirements. When creating a data warehouse architecture, it is important to break the architecture into specific domains that are joined into a holistic final design. This design should be considered the blue print for the enterprise data architecture. In particular, several primary areas should be developed when considering data warehouse architecture. These areas are source system access, staging area process, data enrichment process, data architecture, business intelligence process, an
