Fig. 11.1.9 Different types of data are grouped together to improve performance.In Fig. 11.1.9, it is seen that lots of different kinds of data are needed in order to execute
the transaction. If the transaction goes and looks on disk storage for all the different
places where the data reside, the transaction will not be a fast-running transaction.
What the database designer could do is to combine all or some of the data into a single
database design. There is nothing that says that data of different types must be placed in
different databases. In order to enhance performance, the analyst could combine all the
data (or even some of the data) into a single database.
This type of design is referred to as a “denormalized” design. Fig. 11.1.10 shows that data
can be denormalized.
Chapter 11.1: Operational Analytics: Response Time