Building the Data Warehouse

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


site A


mapping into the global


site C


data structure



local


local


operational


operational


processing


processing



□    Q


□    Q



□ Q □ □ Q



□    Q


□    Q



□ Q □ □ Q




site EB


hdqtrs


local


local


operational


operational


processing


processing




□ Q □ Q



□ QqQoqqQ q □ qQ qQ



global


data


warehouse


Figure 6.10 There is a common structure for the global data warehouse. Each local site maps into the common structure differently.


data that is staged inside of it is transferred to the global level? If the data is not deleted locally, redundant data will exist. Under certain conditions, some amount of redundancy may be called for. This issue must be decided and policies and procedures put into place.


local


local


data


warehouse



site A



site C



local


operational


processing



local


operational


processing


data


warehouse

global


data warehouse (staging area)


(staging area)    gl°bal


Figure 6.11 The global data warehouse may be staged at the local level, then passed to the global data warehouse at the headquarters level.



data warehouse


For example, the Brazilian data warehouse may create a staging area for its data based on American dollars and the product descriptions that are used globally. In the background the Brazilians may have their own data warehouse in Brazilian currency and the product descriptions as they are known in Brazil. The Brazilians may use both their own data warehouse and the staged data warehouse for reporting and analysis.

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