Database Replication

From the earlier chapter, you have got the idea of what a distributed Database management system is? In this chapter, you will be learning about the opposite of the previous concept and potentially more simplified version of data distribution provided by a replication server that holds the replication of data to remote sites. Every main database vendor has an imitation solution of one kind or another. Furthermore, many non-database vendors also offer substitute ways for replicating data.

Database Replication

It is the process of repetition and upholding database objects such as relations, where numerous databases that make up a distributed database system. Changes done at one site are captured and stored locally before being forwarded and applied at each of database's remote locations. Replication employs distributed database technology for sharing data among various sites, but a replicated database and a distributed database have some differences between them. In a distributed database, data is available at different locations, but a particular relation has to reside at only one location.

Advantages of replication

Replication in a database offers database users various benefits that are termed below

  • Availability
  • Has Reliability
  • Gives high Performance
  • Facilitates load reduction
  • Provide disconnected computing
  • Supports many users
  • Supports latest versions or advanced applications

Applications of Replication

Replication maintains a diverse variety of applications that have very different requirements. Some applications are sufficiently supported with only partial synchronization between the copies of the database and the corporate database system; while many other applications insist continuous synchronization between all copies of the database.


Scroll Back to Top