Building the Data Warehouse

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


■■ Is the transportation of the data from the local environment to the global data warehouse across national lines legal? Some countries have Draconian laws that prevent the movement of certain kinds of data across their national boundaries.


■■ What network will be used to transport the data from the local environment to the global environment? Is the Internet safe enough? Reliable enough? Can the Internet safely transport enough data? What is the backup strategy? What safeguards are in place to determine if all of the data has been passed?


■■ What safeguards are in place to determine whether data is being hacked during transport from the local environment to the global environment?


■■ What window of processing is open for transport of data from the local environment to the global environment? Will transportation have to be done during the hours when processing against the data warehouse will be heavy?


QUERY—“How much money did we spend last month across the corporation on salaries?”


local


operational


processing


local


data


warehouse



site A


QUERY—“What was EDS paid last month in Tampa for facilities maintenance?”

(staging area)


Figure 6.14 Queries need to be routed to different parts of the architecture to be answered properly.


■■ What technology is the local data in, and what technology is the global data in? What measures must be taken to convert the local technology to the global technology? Will data be lost in the translation?


Many issues relate to the physical movement of the data into the global data warehouse environment. In some cases, these issues are mundane; in others, they are anything but.

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