Shulou(Shulou.com)06/01 Report--

This article shares with you about the advantages and disadvantages of distributed databases. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

What is a distributed database?

Distributed databases are multiple interconnected databases that are usually located on multiple servers but communicate with each other to achieve common goals; they are managed by a distributed database management system (DDBMS).

Distributed database provides the advantages of distributed computing in the field of database management. Basically, we can define a distributed database as a collection of related databases distributed on a computer network.

Advantages of distributed database

1. Data with different transparency can be managed

Ideally, the database should be distributed transparent, hiding the details of where each file is physically stored in the system. In a distributed database system, the following types of transparency can basically be used:

● network transparency: this basically refers to the freedom that users get from the operational details of the network. They come in two types: location and naming transparency.

● replication transparency: it basically makes users unaware of the existence of replicas because we know that data replicas may be stored in multiple sites for better availability and reliability.

● fragment transparency: it basically makes the user unaware of the existence of fragments, which may be vertical or horizontal fragments.

2. Improve reliability and availability

Reliability is basically defined as the probability that the system runs at a specific time, while availability is defined as the probability that the system is continuously available over a period of time. When data and DBMS software are distributed across multiple sites, one site may fail while others continue to run, and we cannot access only the data that exists in the failed site, which basically improves reliability and availability.

3. Easier to expand

In a distributed environment, it is much easier to expand the system in terms of adding more data, increasing database size, or adding more data, increasing database size or adding more processors.

4. Improved performance

By decomposing the query into multiple subqueries that are basically executed in parallel, we can achieve inter-query and internal query parallelism by executing multiple queries at different sites, which can basically improve performance.

Disadvantages of distributed database

1. Complexity, distributed database architecture requires higher requirements in design, troubleshooting and management.

2. Many complex routines must be developed to ensure that data synchronization works properly.

3. There will be a delay between the master data and the satellite data footprint, in which many reports generated by the satellite database are different from the master data. This issue must be evaluated during the design of the synchronization frequency.

Thank you for reading! So much for sharing the advantages and disadvantages of distributed database. I hope the above content can be helpful to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.