data-architecture-a

Fig. 11.1.8 A fast running transaction accessing a small amount of data. The transaction on the top is not going to be a fast-ru ...

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 differe ...

Fig. 11.1.10 Denormalized data. Once the data are denormalized, the number of I/Os needed to execute the transaction is reduced. ...

Fig. 11.1.11 Accessing a lot of data in a single transaction. What happens if one of these long-running programs is mixed with a ...

Fig. 11.1.13 Dividing the day into different types of processing hours. One solution to resolving the conflict between long-runn ...

Chapter 12.1 Operational Analytics Abstract Performance is of the essence in the operational environment. In order to enhance pe ...

Fig. 12.1.1 Operational environment. Operational analytics consist of the decisions that are made as a result of the execution o ...

Fig. 12.1.2 The essence of operational processing. Operational systems have the mission of being speedy execution, operation aga ...

This lack of integrity of data is seen in Fig. 12.1.3. Fig. 12.1.3 The lack of integrity of data. One can see the frustration ac ...

Fig. 12.1.4 Very little historical data found in the operational environment. But there is a problem with jettisoning historical ...

Fig. 12.1.5 The data warehouse—the single version of the truth. The definition of a data warehouse has been around since the beg ...

Fig. 12.1.6 The relational model and the data warehouse. Data are loaded into the data warehouse from the operational applicatio ...

Fig. 12.1.7 Transforming application data into corporate data. In fact, data are not “loaded” into the data warehouse at all. Th ...

Fig. 12.1.8 Transformations. In Fig. 12.1.8, application data hold different renditions of data for gender and measurement. In o ...

In the data warehouse, there is one indicator for gender—m and f. In the data warehouse, there is one unit of measurement—centim ...

But as data pass into the data warehouse, the system of record also passes into the data warehouse. The difference is the timeli ...

Fig. 12.1.10 Different departments look at the same data differently. The reason the data warehouse can serve as a foundation of ...

The way that the data warehouse serves the different communities is through the creation of data marts. Fig. 12.1.11 shows that ...

Fig. 12.1.12 Star joins. In the dimensional model are found fact tables and dimension tables. Tables and dimension tables are at ...

Fig. 12.1.13 Data marts and the dimensional model. In Fig. 12.1.13, it is seen that the integration of data occurs as data are p ...