Oracle7 Server Distributed Systems Volume I: Distributed Data

Factors Affecting the Distribution of an Application's Data

In a distributed database environment, you should 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

criticality of access if a node or link is down

need for referential integrity among tables