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