Disadvantages of Distributed DBMS Last Updated : 12 Jan, 2023 Comments Improve Suggest changes Like Article Like Report 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 is 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 a 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 on 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.Lack of Professional Support:Due to a lack of adequate communication standards, it is not possible to link different equipment produced by different vendors into a smoothly functioning network. Thus several good resources may not be available to the users of the network.Data design complex: Designing a distributed database is more complex compared to a centralized database. If the data is not properly distributed at different sites, then the query processing time will increase and response to requests will become slow. Comment More infoAdvertise with us Next Article Disadvantages of Distributed DBMS S simranjenny84 Follow Improve Article Tags : DBMS Distributed System Similar Reads Disadvantages of DBMS You might have encountered bulks of files/registers either at some office/school/university. The traditional file management system has been followed for managing the information or data at many organizations and by many businesses. It used to be cost-effective and easily accessible. With evolving t 9 min read Advantages of Distributed database Distributed databases basically provide us the advantages of distributed computing to the database management domain. Basically, we can define a Distributed database as a collection of multiple interrelated databases distributed over a computer network and a distributed database management system as 4 min read Concepts of Distributed databases A Distributed database is defined as a logically related collection of data that is shared which is physically distributed over a computer network on different sites. Distributed DBMS : The Distributed DBMS is defined as, the software that allows for the management of the distributed database and ma 3 min read Types of Distributed DBMS A system that is used for managing the storage and retrieval of data across multiple interconnected databases is called a Distributed Database Management System(DDBMS). In this case, the interconnected databases are situated in different geographical areas. In DDBMS, one can access and store data tr 4 min read Distributed Database System A distributed database is basically a database that is not limited to one system, it is spread over different sites, i.e, on multiple computers or over a network of computers. A distributed database system is located on various sites that don't share physical components. This may be required when a 5 min read Like