MultiValue Data Replication
MultiValue data replication allows database administrators to distribute data across multiple servers throughout an organization. You may wish to implement replication in your organization for a number of reasons, such as:
Load balancing. Replication allows you to disseminate your data to a number of servers and then distribute the query load among those servers.
Offline processing. Replication supports manipulating data from your database on a machine that is not always connected to the network.
Redundancy. Replication allows you to build a fail-over database server that’s ready to pick up the processing load at a moment’s notice.
Any replication scenario has two main components:
Publishers have data to offer to other servers. A given replication scheme may have one or more publishers.
Subscribers are database servers that wish to receive updates from the Publisher when data is modified.