DBMS | Data Replication Schemes, Advantages and Disadvantages of Data Replication

In this tutorial, we are going to learn about the Data Replication Schemes, Advantages and Disadvantages of Data Replication in DBMS.
Submitted by Anushree Goswami, on July 07, 2019

Working on the Distributed System, Data Replication can be Full Replication, such that the whole database gets replicated to every location. It can be Partial Replication in which only the most frequently used dataset is replicated to other location or there may be No Replication at all. These replication schemes help to increase the performance as well as to increase the processing and executing time of the data. Let us understand all the data replication schemes in a more elaborative manner.

1) Full Replication

In Full Replication, the whole database is getting replicated to every other location, from publisher to every other subscriber. The whole data is present at every other site and if a breakdown of multiple sites occurred, the dataset will be available easily at least, at any one of the sites.

Full Replication

Advantages of Full Replication

  1. Data is highly available.
  2. Queries can be executed faster.
  3. Increase Performance.

Disadvantages of Full Replication

  1. Difficult to achieve the concurrency.
  2. Slow processing and execution time.

2) Partial Replication

In Partial Replication, only the modified data is replicated to other locations, from publisher to the multiple subscribers. In this way, the data transfer may occur from one to the total number of database present in the system.

Partial Replication

Advantages of Partial Replication

  1. Depending on the importance of the data, that much number of copies of the changed dataset is required.

3) No Replication

In No Replication, as the name says, there is no replication of the data occurred from publisher to the subscriber that means every changed data is stored at any one place or site.

No Replication

Advantages of No Replication

  1. Data can be recovered easily.
  2. Concurrency of the dataset can be minimized.

Disadvantages of No Replication

  1. Data availability gets poor.
  2. Slow processing and execution time, as on the same server, multiple accesses have been done.

Advantages of Data Replication

  1. In data replication, availability of data gets increased.
  2. In data replication, consistency is maintained across every node of the database.
  3. In data replication, reliability gets the increase.
  4. In data replication, there can be multiple users and still there is not much load at any one site as the data is distributed to various sites consistently.
  5. In data replication, faster processing and execution time.
  6. In data replication, the data may get found at the place where the transaction gets executed thus helps in lesser movement of the data.
  7. In data replication, performance is increased.
  8. In data replication, retrieval of data or modification of data becomes easier.

Disadvantages of Data Replication

  1. In data replication, storage space required gets higher as the replicas needs more space going through various sites at a time.
  2. In data replication, the cost to replicate the data at all sites also gets increased as every site needs to get updated altogether.
  3. In data replication, it becomes hard to maintain the consistency of data.
  4. In data replication, complexity of data increases as well.

Related Tutorials


Comments and Discussions!

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.