Building the Data Warehouse

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


And then, of course, there is the even larger case where much processing occurs at the local level. Products are made. Sales forces are hired. Marketing is done. An entire mini-corporation is set up locally. Of course, the local corporations report to the same balance sheet as all other branches of the corporation. But, at the end of the day, the local organizations are effectively their own company, and there is little business integration of data across the corporation. In this case, a full-scale data warehouse at the local level is needed.


Just as there are many different kinds of distributed business models, there is more than one type of local/global distributed data warehouse, as will be discussed. It is a mistake to think that the model for the local/global distributed data warehouse is a binary proposition. Instead, there are degrees of distributed data warehouse.


site A



local


operational


processing



site C



hdqtrs



local


operational


processing



site B



global


operational


processing



local


operational


processing



Figure 6.3 At the other end of the spectrum of the distributed data warehouse, much of the operational processing is done locally.


Most organizations that do not have a great deal of local autonomy and processing have a central data warehouse, as shown in Figure 6.4.


The Local Data Warehouse


A form of data warehouse, known as a local data warehouse, contains data that is of interest only to the local level. There might be a local data warehouse for Brazil, one for France, and one for Hong Kong. Or there might be a local data warehouse for car parts, motorcycles, and heavy trucks. Each local data warehouse has its own technology, its own data, its own processor, and so forth. Figure 6.5 shows a simple example of a series of local data warehouses.

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