Building the Data Warehouse

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


site A


, site C


local


operational


processing



local


operational


processing


local


data


warehouse



hdqtrs ‘



local


operational


processing


local


data


warehouse



site B



local


operational


processing


local


data


warehouse


local


data


warehouse


global


data


warehouse



Asia



site 13



operational


processing


local


data


warehouse


local


data


warehouse


local


data


warehouse


global


data


warehouse


local


data


warehouse



all IBM site B



operational


processing



mixed IBM DEC,



local


data


warehouse


local Tandem data


warehouse


global


data


warehouse


The global data warehouse contains information that must be integrated at the corporate level. In many cases, this consists only of financial information. In other cases, this may mean integration of customer information, product information, and so on. While a considerable amount of information will be peculiar to and useful to only the local level, other corporate common information will need to be shared and managed corporately. The global data warehouse contains the data that needs to be managed globally.


An interesting issue is commonality of data among the different local data warehouses. Figure 6.8 shows that each local warehouse has its own unique structure and content of data. In Brazil there may be much information about the transport of goods up and down the Amazon. This information is of no use in Hong Kong and France. Conversely, information might be stored in the French data warehouse about the trade unions in France and about trade under the Euro that is of little interest in Hong Kong or Brazil.

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