Get premium membership and access questions with answers, video lessons as well as revision papers.

Discuss the advantages of a DDBMS

Answers

1)Reflects organizational structure Many organizations are naturally distributed over several locations. It’s natural for databases used in such an application to be distributed over these locations.
2)Improved shareability and local autonomy. The geographical distribution of an organization can be reflected in the distribution of the data; users at one site can access data stored at other sites. Data can be placed at the site close to the users who normally use that data. In this way, users have local control of the data, and they can consequently establish and enforce local policies regarding the use of this data.
3)Improved availability. In a centralized DBMS, a computer failure terminates the operations of the DBMS. However, a failure at one site of a DDBMS, or a failure of a communication link making some sites inaccessible, does not make the entire system inoperable.
4)Improved reliability As data may be replicated so that it exists at more than one site, the failure of a node or a communication link does not necessarily make the data inaccessible.
5)Improved performance. As the data is located near the site of ‘greatest demand’, and given the inherent parallelism of DDBMSs, it may be possible to improve the speed of database accesses than if we had a remote centralized database. Furthermore, since each site handles only a part of the entire database, there may not be the same contention for CPU and I/O services as characterized by a centralized DBMS.
6)Economics. It’s generally accepted that it costs much less to create a system of smaller computers with the equivalent power of a single large computer. This makes it more cost-effective for corporate divisions and departments to obtain separate computers. It’s also much more cost-effective to add workstations to a network than to update a mainframe system.
7)Modular growth In a distributed environment. it’s much easier to handle expansion. New sites can be added to the network without affecting the operations of other sites. This flexibility allows an organization to expand relatively easily.

kalvinspartan answered the question on July 4, 2018 at 16:53

Next: Discuss the disadvantages of DDBMS
Previous: Compare and contrast a DDBMS with distributed processing. Under what circumstances would you choose a DDBMS over distributed processing?

View More Computer Science Questions and Answers | Return to Questions Index

Learn High School English on YouTube

Discuss the advantages of a DDBMS

Answers

Related Questions