Discuss The Relative Advantages Of Centralized And Distributed Databases?
Answer»
A distributed database allows a user convenient and transparent access to data which is not stored at the site, while allowing each site CONTROL over its own local data. A distributed database can be made more reliable than a centralized system because if one site fails, the database can CONTINUEFUNCTIONING, but if the centralized system fails, the database can no longer continue with its normal operation. Also, a distributed database allows PARALLEL execution of queries and possibly splitting one query into many parts to increase throughput.
A centralized system is easier to design and implement. A centralized system is CHEAPER to operate because messages do not have to be sent.