Duplicating tables

If a group of users regularly needs only a subset of data, you can duplicate the critical table subset for that group.

Figure 6-8: Denormalizing by duplicating tables

The kind of split shown in Figure 6-8 minimizes contention, but requires that you manage redundancy. There may be issues of latency for the group of users who see only the copied data.