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