Data Warehouse and Its Architecture

1
Data Warehouse and Its Architecture
PRESENTED By KOKKIRALA SATHEESH KUMAR
CS425 SPRING 2001
2
DEFINITION
3
(No Transcript)
4
(No Transcript)
5
Factors to Be Considered

• Flexibility
• Scalability
• Performance

6
It Is a Way of Representing the Overall Structure
of Data,communication,processing, and
Presentation that exits for End User computing
with in an Enterprise.
Architecture
1.Definition
2.Why we need an Architecture
7
(No Transcript)
8
Types of Architectures

• Centralized Data Warehouses
• Localized Functional Warehouses
• Distributed Data Warehouses

9
Centralized Data Warehouse

• Advantages
• Disadvantages

10
Localized Functional Warehouse(Data Mart)

• Advantages
• Disadvantages

11
Distributed Data Warehouse

• Advantages
• Disadvantages

12
Summary A well defined and
thought out data warehouse, properly
implemented, can be a valuable competitive tool

• References
• Article Building the Data Warehouse by Stephen
  R.Gardner
• (Communications of the ACM September
  1998.)
• http//ucsu.colorado.edu/tanaraks/5817_arch.html