Building the Data Warehouse

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


In addition, an important design issue is how to create and transport the local system of record data from the technology found at the local level into the technology of the corporate data warehouse. In some cases, the official “staged” data is kept at the local level. In other cases, the staged data is passed on to the corporate environment with no access at the local level.


As a rule, the data in the corporate data warehouse is simple in structure and concept. Figure 6.25 shows that data in the corporate data warehouse appears to be detailed data to the DSS analyst at the corporate level, and at the same time it appears to be summary data to the DSS analyst at the local level. This apparent contradiction is reconciled by the fact that the appearance of summarization or detail is strictly in the eye of the beholder.

Figure 6.24 The corporate data warehouse is loaded from the different autonomous operating companies.



c ^


South


America


d/w




summary



detailed


data


Figure 6.25 What is summary at one level is detailed at another.




corporate


data


warehouse


The corporate data warehouse of the distributed database can be contrasted with the corporate financial data warehouse of the completely unrelated companies. Figure 6.26 makes this comparison.


In many ways, the data warehouse of the distributed corporation is very similar to the data warehouse of the unrelated companies. However, although there are similarities in design and operation, there is one major difference. The corporate distributed data warehouse extends into the business itself, reflecting the integration of customer, vendor, product, and so forth. As such, the corporate

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