Building the Data Warehouse

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

Figure 11.6 The data mart, DSS application, and exploration warehouse processing can be done inside or outside the ERP environment (or both) when the data warehouse is constructed inside the ERP environment.


ERP-based data warehouse, as shown in Figure 11.7. This possibility is quite legitimate when there is little or no business integration between the two environments. For example, the non-ERP data warehouse may represent a line of cosmetics, and the ERP-based data warehouse may represent the manufacture of motorcycles. Because there simply is no business relationship between cosmetics and motorcycles, it is quite acceptable to have separate data warehouses for the two environments.


If the two environments must share data, such as financial information, then it may be transferred from one warehouse to the other. For example, say that the cosmetics organization had quarterly profitability of $2,900,871 and the motorcycle manufacturer had profitability for the quarter of $45,880,710. Because both organizations share a bottom line, there may be integration of data. But with regard to customers, business practices, promotions, campaigns, and so forth, there is absolutely no business integration. In such a case separate data warehouses make sense.


i


i



i



i


i

data marts


DSS applications


exploration


warehouse


Figure 11.7 When there is no need for integration, it is possible to have multiple data warehouses.


The ERP-Oriented Corporate Data Warehouse


Occasionally a specialized form of a global data warehouse—called the ERP-oriented corporate data warehouse—occurs. Figure 11.8 shows a corporate ERP data warehouse that collects data from the different geographic locales: the United States, Ethiopia, Switzerland, Japan, Australia, and Kuwait. The corporate data warehouse presents to management a truly global perspective of worldwide operations.

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