What Is The Advantages And Disadvantages Of Distributed Data Base And Centralize Data Base ?


2 Answers

Anonymous Profile
Anonymous answered
Distributed database advantages    There are a number of advantages to using a distributed DBMS. These include the following:    Capacity and incremental growth    Reliability and availability    Efficiency and flexibility    Sharing          Capacity and growth    An advantage of distributed databases is that as the organisation grows, new sites can be added with little or no upheaval to the DBMS. Compare this to the situation in a centralised system, where growth entails upgrading with changes in hardware and software that effect the entire database.          Reliability and availability    An advantage of distributed databases is that even when a portion of a system (i.e. A local site) is down, the overall system remains available. With replicated data, the failure of one site still allows access to the replicated copy of the data from another site. The remaining sites continue to function. The greater accessibility enhances the reliability of the system.        Efficiency and flexibility    An advantage of distributed databases is that data is physically stored close to the anticipated point of use. Hence if usage patterns change then data can be dynamically moved or replicated to where it is most needed.          Distributed database sharing    An advantage of distributed databases is that users at a given site are able to access data stored at other sites and at the same time retain control over the data at their own site.  Women's Polytechnique College Siddhi,Mayuree,Deepshikha

Answer Question