A distributed database is a network of databases managed by multiple database servers that appears to a user as single logical database.
Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency
A snapshot log is a table in the master database that is associated with the master table. ORACLE uses a snapshot log to track the rows that have been updated
SQL *NET is ORACLE's mechanism for interfacing with the communication protocols used by the networks that facilitate distributed processing and distributed
- Replication of data in distributed environment. - Using snapshots to replicate data. - Using remote procedure calls.
Snapshot is an object used to dynamically replicate data between distribute database at specified time intervals. In ver 7.0 they are read only.
Updating or Inserting records in remote database through database triggers. It may fail if remote database is having any problem.
It is a table that maintains a record of modifications to the master table in a snapshot. It is stored in the same database as master table and is only available
We must be able to create a after row trigger on table (i.e., it should be not be already available) After giving table privileges. We cannot specify snapshot log name because oracle uses
Database on other servers can be updated and those transactions can be grouped together with others in a logical unit.Database uses a two phase commit.
