Managing the Distribution of Application Data - Oracle 10g

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

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Oracle 10g Topics