Application: Global Data Distribution
Designing a distributed database is no different than designing a non-distributed one. However, a distributed database raises additional concerns to address. For example, how will the database be partitioned? Which parts will be replicated? Where will the partitions and replicas reside?
The small retail store for which you created the database in Unit 2 merged with another small store. The expanded firm is going global using a new distributed database system. The company needs to determine physical and logical locations for the data as well as technical limitations on possible designs.
In a 2- to 3-page paper, recommend a distributed model for the database system. In particular, recommend a partitioning scheme for the data and provide a rationale that supports your proposal. Also, recommend a method for timing for updates by sales, purchasing, and management. Discuss any limitations on the locations and how you can guarantee the quality of the information.