Building Making It Happen
Establishing Making-it-Happen as ‘Formal & Measurable’ Business Discipline
  Sign-in         Register
    
   Traditional vs. Holistic View of Execution Management Organization Readiness for Execution Scorecard  

Execution-MiH Encyclopedia  →   Enterprise Intelligence  →  SECTION -  BI End-to-End  →  CHAPTER -  Business Intelligence Architecture Scenarios  → 

Two tier Data Warehouse Architecture- Staging and Data Warehouse

This is the utopian scenario, where an enterprise staging is supplying data to enterprise Data Warehouse.

This is close to point of arrival in Data Management. We are talking here of a single Staging Area leading to an enterprise-wide Data Warehouse. The detail of this scenario is covered in detail in Data Warehouse Section.

This topology has also got some variants, which are covered out here. The details of setting-up a Data Warehouse are covered in a separate section. The variants are:

Data Warehouse with a limited coverage

A large organization has a lot of systems, and even the best data warehouse will not be able to cover all. Data Warehouse is a relative and not an absolute term. Please refer to difference between the Data-Warehouse/Data-Mart and their respective criteria. If there is an initiative which meets the DW criteria, it can be called a data warehouse, even if it is not covering all possible systems. Typically an organization will have its first data warehouse covering the most critical business themes. This will further expand to include more and more themes over time.

Multiple Data warehouses

If an organization is large enough and has hundreds of systems, it may end-up with multiple information delivery platform with each being a Data Warehouse in its own right. However, these Data Warehouses will not be having overlapping purposes.

 

   Traditional vs. Holistic View of Execution Management Organization Readiness for Execution Scorecard  
 
All Topics in: "Business Intelligence Architecture Scenarios" Chapter
 One tier Data Warehouse →  Two tier Data Warehouse Architecture- Independent Data Marts →  Two tier Data Warehouse Architecture- Staging and Data Warehouse →  Three Tier Data Warehouse -Business Intelligence Architecture →  BI Mixed Data Access →  Business Intelligence Metadata Architecture Scenarios → 
 

Was this page helpful?
If you like it ? share it !
Digg
Digg
Reddit
Reddit
Del.icio.us
Delicious
Google
Google
Live
Live
Facebook
Facebook
Slashdot
Slashdot
Netscape
Netscape
Technorati
Technorati
Stumbleupon
Stumbleupon
Spurl
Spurl
Furl
Furl
Blogmarks
Blogmarks
Yahoo
Yahoo
Plugim
Plugim
Squidoo
Squidoo
BlinkBits
BlinkBits
 
CONTENT ZONE
BI End-to-End

Featured Pages
ODS- Operational Data Store
Store granular data in data warehouse
Metadata detail level
OLAP in Business Intelligence- What is OLAP?

Make 'Executable' Strategy
Maximize Results
Maximize People
Manage Execution

Featured Pages
Production Reports from DW
System Quality Assessment Tool
Customer Data Variations
Dimensional Model Completion Checklist