1 / 18

Data Warehouse Architecture

Data Warehouse Architecture. By: Harrison Reid. Outline. What is a Data Warehouse Architecture Five Main Data Warehouse Architectures Factors That Affect Choosing A Data Warehouse Architecture Summary Bibliography. What is a Data Warehouse Architecture.

lyre
Download Presentation

Data Warehouse Architecture

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Data Warehouse Architecture By: Harrison Reid

  2. Outline • What is a Data Warehouse Architecture • Five Main Data Warehouse Architectures • Factors That Affect Choosing A Data Warehouse Architecture • Summary • Bibliography

  3. What is a Data Warehouse Architecture • Primarily based on the business processes of a business enterprise • Conceptualization of how the data warehouse is built

  4. Five Main Data Warehouse Architectures • Independent Data Marts • Data Mart Bus Architecture • Hub-and-Spoke • Centralized Data Warehouse • Federated Architecture

  5. Independent Data Marts • Data marts that are independent of each other • Often created by organization units • Inconsistent data definitions and different dimensions and measures

  6. Independent Data Marts Diagram Source systems Staging area Independent data marts (atomic/summarized data) End-user access and applications

  7. Data Mart Bus Architecture • Creation starts with a business requirements analysis for a specific process such as orders, deliveries, customer calls, or billing. • One mart is created for a single business process • Additional marts are developed using the conformed dimensions of the first mart

  8. Data Mart Bus Architecture Diagram Dimensionalized data marts linked by conformed dimensions (atomic/summarized data) Source systems Staging area End-user access and applications

  9. Hub-and-Spoke • Developed after an enterprise-level analysis of data requirements • Focused on building a scalable and maintainable infrastructure • Developed in an iterative manner • Dependent data marts obtain the data from the warehouse • Consist of a centralized hub that accepts requests from multiple applications that are connected through spokes

  10. Hub-and-Spoke Diagram Source systems Staging area Normalized relational warehouse (atomic data) End-user access and applications Dependent data marts (summarized/some atomic data)

  11. Centralized Data Warehouse • Similar to the hub-and-spoke architecture except there are no dependent data marts • Contains atomic-level data, some summarized data, and logical dimensional view of the data • Queries and applications access data

  12. Centralized Data Warehouse Diagram Normalized relational warehouse (atomic/some summarized data) Source systems Staging area End-user access and applications

  13. Federated Architecture • Leaves existing decision-support structures in place • Shares information among a number of different systems • Data is either logically or physically integrated • Shared keys • Global metadata • Distributed queries

  14. Federated Architecture Diagram Existing data warehouses, data marts, and legacy systems Logical/physical integration of common data elements End user access and applications

  15. Factors That Affect Choosing A Data Warehouse Architecture • Information Interdependence between Organizational Units • Upper Management’s Information Needs • Urgency of Need for a Data Warehouse • Nature of End-User Tasks • Constraints on Resources

  16. Factors That Affect Choosing A Data Warehouse Architecture • Strategic View of the Data Warehouse Prior to Implementation • Compatibility with Existing Systems • Perceived Ability of the In-House IT Staff • Technical Issues • Social/Political Factors

  17. Summary • The Data Mart Bus, Hub-and-Spoke, and Centralized Architectures are the most used • Many factors affect the choice of a Data Warehouse Architecture • Some Data Warehouse Architectures can be implemented on existing systems

  18. Bibliography

More Related