Site autonomy - Definition - Oracle Distributed Database concepts

Discussion

• Nirja Shah   -Posted on 21 Sep 15
  - Site autonomy means that each server participating in a distributed database is administered independently from all other databases, as though each database operates as a non-distributed database.
  
  - Although several databases can work together, each database is a distinct, separate repository of data that you manage individually.
  
  - Some of the benefits of site autonomy in an Oracle distributed database include:
  
  1. Nodes of the system can mirror the logical organization of companies or cooperating organizations that need to maintain an "arms length" relationship.
  
  2. Local database administrators control corresponding local data. Therefore, each database administrator's domain of responsibility is smaller and more manageable.
  
  3. Independent failures are less likely to disrupt other nodes of the distributed database. The global Oracle database is partially available as long as one database and the network are available; no single database failure need halt all global operations or be a performance bottleneck.
  
  4. Administrators can recovery from isolated system failures independent of other nodes in the system.
  
  5. A data dictionary exists for each local database--a global catalog is not necessary to access local data.
  
  6. Nodes can upgrade software independently.
  
  - Although Oracle allows you to manage each database in a distributed database system independently, that is not to say that you should ignore the global requirements of the system.

➨ Post your comment / Share knowledge