Building the Data Warehouse

Скачать в pdf «Building the Data Warehouse»
Where to Turn

The EIS analyst can turn to various places in the architecture to get data. In Figure 7.9, the EIS analyst can go to the individual level of processing, the depart-

mental (data mart) level of processing, the lightly summarized level of processing, or the archival/dormant level of data. In addition, there is a normal sequence or hierarchy in which the EIS analyst goes after data to serve management’s needs (see Figure 7.9).

There is a very good reason for the order shown, as indicated in Figure 7.10. By going from the individual level of processing to the archival/dormant level, the analyst does de facto drill-down analysis. The most summarized data found in the architected environment is at the individual level. The supporting level of summary for the individual level is the departmental (data mart) level. Supporting the summaries at the departmental (data mart) level is data at the data warehouse lightly summarized level. Finally, the light summarization at the data warehouse level is supported by archival/dormant data. The sequence of summaries just described is precisely what is required to support drill-down EIS analysis.

Almost by default, the data warehouse lays a path for drill-down analysis. At the different levels of the data warehouse, and throughout the summarization

In going from individual levels of processing to true archival data, the drilldown process is accommodated.

Скачать в pdf «Building the Data Warehouse»