Designing the Data Structure › Choose to Distribute or Replicate Data

Choose to Distribute or Replicate Data

The decision to either distribute or replicate data is a critical one because it involves significant effort.

Rules may already be in place that define how the data is to be distributed and or replicated.

Avoiding distribution and replication is the simplest and most expedient option.

The main reason for distributing and replicating data is to increase performance. Performance is an issue that becomes much more important in construction and testing. The most appropriate action to improve performance can be taken then.

Detailed discussions of the alternatives with DBMS and network specialists should be sought before proceeding.