Answer to Question #226776 in Algorithms for kkk

Question

Q1. Explain strategies and options for distributed database design.

Q2. Explain advantages and risks of distributed databases.

Q3. Discuss relative advantages of synchronous and asynchronous data replication and partitioning.

Q4. Describe salient characteristics of distributed database environments.

Answer 1

Solution 1. The strategies for the distributed databases are listed below -

• Data replication.
• Horizontal partitioning.
• Vertical partitioning.
• Combinations of the above.

Solution 2. The advantage and the risk of the distributed databases are listed below -

Advantages:

• Modular development.
• Reliability.
• Lower communication casts.
• better response

Risk:

• Costly software
• Large overhead
• Data integrity
• Improper data distribution.

Solution 3.

Asynchronous replication requires substantially less bandwidth than synchronous replication. It is designed to work over long distances. Since, the replication process does not have to occur in real time, Asynchronous replication can tolerate some degradation in connectivity.

Solution 4.

The characteristics of the distributed databases are listed below -

• it is independent of location.
• It is based on distributed query processing.
• It is based on distributed transaction management.
• It is hardware independent.
• It is operating system independent.
• It is network independent.