Databases Reference
In-Depth Information
Enterprise data warehouse platform
In Chapter 6 we saw a few layers under the hood with respect to the limitations of a database, how-
ever, that makes only one component of the entire infrastructure platform called the enterprise data
warehouse. There are several layers of infrastructure that make the platform for the EDW:
1.
The hardware platform:
●
Database server:
- Processor
- Memory
- BUS architecture
●
Storage server:
- Class of disk
- Controller
●
Network
2.
Operating system
3.
Application software:
●
Database
●
Utilities
A cross-section examination of this infrastructure platform is shown in
Figure 7.1
.
There are several layers of data distributed from transactional systems into the ODS or staging
areas and finally into the data warehouse, to be passed downstream to analytical databases. Let us
examine
Figure 7.1
.
FIGURE 7.1
Data distribution in a data warehouse today.