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.
