| |
 |
|
Oracle 8 Tips
by Burleson Consulting |
The Data Warehouse Development Life Cycle
Distributed Oracle Data Warehouses
Managing an Oracle data warehouse becomes very challenging when
we move into the distributed database environment. The challenge
arises because so many components within the database software
contribute to the overall performance. The number of concurrent
users, the availability of space within the buffer and lock pools,
and the balancing of access across processors all can affect
database performance.
When a data warehouse accesses several remote databases in a single
warehouse query, another dimension of complexity is added to the
data warehouse. Not only must the database administrator (Remote DBA) look
at each individual database, but the Remote DBA also must consider
transactions that span several servers. While accessing several
servers in a distributed warehouse query may seem trivial,
performance problems can be introduced by PC hardware, LAN and
network bottlenecks, router overloads, and many other sources. Let’s
take a look at distributed data warehouses and examine how they
differ from traditional data warehouse environments.
|
