268 Oracle Database 11g DBA Handbook
Reducing Network Traffic
As databases and the applications that use them become more distributed, the network that
supports the servers may become a bottleneck in the process of delivering data to the users.
Because DBAs typically have little control over the network management, it is important to use
the database??™s capabilities to reduce the number of network packets required for the data to be
delivered. Reducing network traffic will reduce your reliance on the network and thus eliminate
a potential cause of performance problems.
Replication of Data Using Materialized Views
You can manipulate and query data from remote databases. However, it is not desirable to have
large volumes of data constantly sent from one database to another. To reduce the amount of data
being sent across the network, you should consider different data replication options.
In a purely distributed environment, each data element exists in one database. When data is
required, it is accessed from remote databases via database links. This purist approach is similar
to implementing an application strictly in third normal form??”an approach that will not easily
support any major production application. Modifying the application??™s tables to improve data
retrieval performance involves denormalizing data. The denormalization process deliberately
stores redundant data in order to shorten users??™ access paths to the data.
Pages:
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457