SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Data Warehouse Architecture

lyre avatar
lyre
18 diapositives · 2.2K Views · Jul 24, 2014

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.

Data Warehouse Architecture - slide 1
01 / 18Data Warehouse Architecture
1 / 17

Télécharger la présentation

Data Warehouse Architecture
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  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