Databases Reference
In-Depth Information
(a)
Query Management
Workloads
Data Movement
Workloads
I/O Workloads
Database
(Storage
Server)
Database
Server
Application
Server
End-User
Application
Latencies
Latencies
Latencies
Performance
Issues
Performance
Issues
Performance
Issues
Performance
Issues
(b)
Data Movement
Workloads
Query Management
Workloads
I/O Workloads
Database
(Storage
Server)
Source
Database
Application
Server
Database
Server
Latencies
Latencies
Latencies
Performance
Issues
Performance
Issues
Performance
Issues
Performance
Issues
FIGURE 8.2
Classic data warehouse problem manifests: (a) outbound side and (b) inbound side.
results, we infer what performance impact is experienced in the current state and what can be experi-
enced if there are spikes of increases or decreases of workloads. The resulting definitions from these
exercises often fail to produce the right architectural decisions.
Figure 8.2
shows the problem areas that manifest in the data warehouse today. We can
bucket these problems under each segment to understand the overall workload aspect of the system.
The different aspects of the data warehouse affected by workloads are discussed in the following
sections.
