Building the Data Warehouse

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


■■ How long will it take to install the software?


■    Who will be responsible for the software?


■    When will the software be ready for full-blown use?


ISSUE: The data warehouse environment is capable of handling a large number of different types of software interfaces. The amount of break-in time and “infrastructure” time, however, should not be underestimated. The DSS architect must not assume that the linking of the data warehouse environment to other environments will necessarily be straightforward and easy.


13.    What software/interface will be required for the feeding of DSS departmental and individual processing out of the data warehouse environment?


■■ Has the interface been thoroughly tested?


■■ What bottlenecks might exist?


■■ Is the interface one-way or two-way?


■■ What technical support will be required?


■    What traffic of data across the interface is anticipated?


■    What monitoring of the interface will be required?


■    What alterations to the interface will there be?


■    What outage is anticipated as a result of alterations to the interface?


■■ How long will it take to install the interface?


■    Who will be responsible for the interface?


■    When will the interface be ready for full-scale utilization?


14.    What physical organization of data will be used in the data warehouse environment? Can the data be directly accessed? Can it be sequentially accessed? Can indexes be easily and cheaply created?


ISSUE: The designer needs to review the physical configuration of the data warehouse environment to ensure that adequate capacity will be available and that the data, once in the environment, will be able to be manipulated in a responsive manner.

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