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