Managing the Distribution of Application Data

In a distributed database environment, coordinate with the database administrator to determine the best location for the data. Some issues to consider are:

• Number of transactions posted from each location

• Amount of data (portion of table) used by each node

• Performance characteristics and reliability of the network

• Speed of various nodes, capacities of disks

• Importance of a node or link when it is unavailable

• Need for referential integrity among tables