Distributed Database Systems is a kind of DBMS where databases are present at different locations and connected via a network. Each site in a Distributed Database is capable of accessing and processing local data as well as remote data. Although, distributed DBMS is capable of effective communication and data sharing still it suffers from various disadvantages are as following below.
- Complex nature :
Distributed Databases are a network of many computers present at different locations and they provide an outstanding level of performance, availability and of course reliability. Therefore, the nature of Distributed DBMS is comparatively more complex than a centralized DBMS. Complex software are required for Distributed DBMS . Also, It ensures no data replication, which adds even more complexity in its nature.
- Overall Cost :
Various costs such as maintenance cost, procurement cost, hardware cost, network/communication costs, labor costs, etc, adds up to the overall cost and make it costlier than normal DBMS.
- Security issues:
In a Distributed Database, along with maintaining no data redundancy, the security of data as well as network is a prime concern. A network can be easily attacked for data theft and misuse.
- Integrity Control:
In a vast Distributed database system, maintaining data consistency is important. All changes made to data at one site must be reflected to all the sites. The communication and processing cost is high in Distributed DBMS in order to enforce the integrity of data.
- Lacking Standards:
Although it provides effective communication and data sharing, still there are no standard rules and protocols to convert a centralized DBMS to a large Distributed DBMS. Lack of standards decreases the potential of Distributed DBMS.
If the data is not properly distributed at different sites, then the query processing time will increase and response to requests will become slow.
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- Disadvantages of DBMS
- Difference between Client /Server and Distributed DBMS
- Advantages and Disadvantages of SQL
- Advantages and Disadvantages of Using Stored Procedures - SQL
- Distributed Database System
- Hashing in Distributed Systems
- Deadlock detection in Distributed systems
- Advantages of Distributed database
- Functions of Distributed Database System
- Comparison - Centralized, Decentralized and Distributed Systems
- Mutual exclusion in distributed system
- Maekawa’s Algorithm for Mutual Exclusion in Distributed System
- Ricart–Agrawala Algorithm in Mutual Exclusion in Distributed System
- Lamport's Algorithm for Mutual Exclusion in Distributed System
- Suzuki–Kasami Algorithm for Mutual Exclusion in Distributed System
- Hierarchical Deadlock Detection in Distributed System
- Algorithm for implementing Distributed Shared Memory
- Difference between Network OS and Distributed OS
- Chandy-Misra-Haas's Distributed Deadlock Detection Algorithm
- Interprocess Communication in Distributed Systems
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.