The question that is being addressed is how the database and the applications that run against it should be placed across the sites. In partitioned scheme database is divided into a number of disjoint partitions each of which is placed at a different site. Replicated designs can be fully or partially replicated. Two fundamental design issues are fragmentation and distribution. Mostly involves mathematical programming to minimize combined cost of storing the database, processing transactions against it, and communication.
Problems are similar to above.
These three dimensions are orthogonal to one another. Chapter 20 20.6 Compare and contrast the different ownership models for replication. Give examples to illustrate your answer. See Section 20.6.1. See Section 21.3.8 Give examples using the DreamHome sample data shown in Figure 3.3.