Data Warehouse Architecture - PowerPoint - PowerPoint

Document Sample
Data Warehouse Architecture - PowerPoint - PowerPoint Powered By Docstoc
					Data Warehouse Architecture
Buildings and architecture
       What is architecture?
• Study of structure
• Old as human society and modern as
  exploration of the solar system (Richtin)
• High level abstract blue print
• A framework for design and development
  of a system
 Reference & system architecture
• Architecture as a method or style of
  building
• Architecture as an end product
• Example?
Westminster   Cologne
St Peter’s Basilica   St Paul’s Cathedral
    The Major Data Warehouse
          Architectures
•   Independent data marts
•   Hub and spoke architecture
•   Data mart bus architecture
•   Federated data warehouse
              Independent data mart
                   architecture

                                                                          End user
                                                                           access/
                                                                         applications




                       Data staging

                                                Independent data marts
     Data sources




•Developed independently.
•No conformed dimensions (i.e., does not have the same categories and labels
for data elements in data marts which would allow data across data marts to be
combined).
•Built to a business unit or functional area.
    Hub and spoke architecture

                                                                                  End user
                                                                                   access/
                                                                                 applications

                                     Central data store




                               ODS
                Data staging
                                                          Dependent data marts
Data sources


    •Key spokesperson: Bill Inmon (1992, 1998, 2001).
    •Detailed enterprise oriented view of data.
    •Built in iterative manner subject area by subject area.
    •Dependent data marts to support user needs for dimensional data.
     Data mart bus architecture

                                                                                  End user
                                                                                   access/
                                                                                 applications




                         Data staging


      Data sources                                      Architected data marts


•Key spokesperson: Ralph Kimball (1996, 1999).
•First data mart built as proof of concept.
•Built sequentially according to master suite of conformed dimensions and fact
tables, resulting in logically integrated marts.
•Conformed dimensions provide capability to access data across architected
marts.
              Federated architecture
                         Data mart
                                          Data staging


                                                                                 End user
                                                                                  access/
                                                                                applications

                                                         Federated data store
        Data stores




                         Data warehouse




•Key spokesperson: Doug Hackney (2000, 2002).
•Combines data in an organization’s existing data warehousing environment.
•Characterized by combing key metrics and measures in existing data marts,
data warehouses and legacy systems.
Data Warehouse Architecture
        Selection
The Sears Tower
       •The tallest building in North
       America.
       •Currently 10,000 people work
       daily.
       •“Reflects the strength of
       Chicago and America”
       (source: the official site for
       Sears Towers).
The Bank of China Tower
           •The headquarters for the Bank
           of China in Hong Kong.
           •Structure adaptations to the
           high wind loads caused by
           Hong Kong typhoons.
           • “Built to create a structure that
           would represent the aspirations
           and culture of the Chinese
           people” (source: the official site
           for the Bank of China).
                   Architecture selection

      Architecture selection factors
Information interdependence
Upper management’s information needs
Urgency of need
View of the data warehouse             Data warehouse architectures
Compatibility with existing systems    Independent data mart
Nature of end user tasks               Data mart bus architecture
Resource constraints                   Hub and spoke architecture
Perceived ability of the IT staff      Federated

Source of sponsorship
Expert influence

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:52
posted:4/26/2012
language:simple
pages:15