Updating replicated data in distributed database
The database application used at each location must also be either identical or compatible.In a heterogeneous distributed database, the hardware, operating systems or database applications may be different at each location.Publications allow you to organize subscriptions and then monitor them with a single command.A Replication Agent—Rep Agent for sites running Adaptive Server—transfers transaction information from a database to a Replication Server for distribution to replicate databases.Replication Server allows you to create a replication definition that identifies all or part of a table to replicate. You can create a database replication definition that identifies the database objects—tables, functions, system procedures, transactions, and data definition language (DDL)—to replicate.You can also create a replication definition of a stored procedure—called a function replication definition—to facilitate rapid replication of large amounts of data and to replicate updates from replicate databases back to the primary database.When failures occur in centralized databases, the system comes to a complete stop.When a component fails in distributed database systems, however, the system will continue to function at reduced performance until the error is fixed.
In a homogenous distributed database system, all the physical locations have the same underlying hardware and run the same operating systems and database applications.
Portions of the database are stored in multiple physical locations and processing is distributed among multiple database nodes.
A centralized distributed database management system (DDBMS) integrates data logically so it can be managed as if it were all stored in the same location.
Since Replication Server provides multiple copies of data, clients can rely on their own local data instead of remote, centralized databases.
In addition, you can copy only the data you want to destination databases.
Search for updating replicated data in distributed database:
Admins can achieve lower communication costs for distributed database systems if the data is located close to where it is used the most. Replicated data is used to create instances of data in different parts of the database.