dbms提供数据_DBMS | 数据复制方案，数据复制的优缺点

深藏阁楼爱情的钟 2023-03-05 04:29 102阅读 0赞

dbms提供数据

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)完全复制 **(**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)部分复制 **(**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)不复制 **(**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.
    
    在数据复制中，数据的复杂性也会增加。

> 翻译自: [https://www.includehelp.com/dbms/data-replication-schemes-advantages-and-disadvantages-of-data-replication.aspx][https_www.includehelp.com_dbms_data-replication-schemes-advantages-and-disadvantages-of-data-replication.aspx]

dbms提供数据

[Full Replication]: https://www.includehelp.com/dbms/Images/Full-Replication.jpg
[Partial Replication]: /images/20230208/6f7fb3d808d3434983fba1153d1e7bf1.png
[No Replication]: https://www.includehelp.com/dbms/Images/No-Replication.jpg
[https_www.includehelp.com_dbms_data-replication-schemes-advantages-and-disadvantages-of-data-replication.aspx]: https://www.includehelp.com/dbms/data-replication-schemes-advantages-and-disadvantages-of-data-replication.aspx