Building the Data Warehouse

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


■■ The network ■■ DASD


■    The operating system managing DASD


■    The interface to and from the warehouse


■    The software used to manage the data warehouse


■    The data warehouse


DSS5—Subject Area Analysis


PRECEDING ACTIVITY: Data model analysis.


FOLLOWING ACTIVITY: Source system analysis.


TIME ESTIMATE: One day.


NORMALLY EXECUTED ONCE OR MULTIPLE TIMES: Once per population project.


DELIVERABLE: Which subject area to build next.


Now the subject area to be populated is selected. The first subject area to be selected must be large enough to be meaningful and small enough to be implemented. If by some chance a subject area is truly large and complex, a subset of the subject area may be chosen for implementation. The output from this step is a scope of effort in terms of a subject.


PARAMETERS OF SUCCESS: The output from this phase when done correctly is a definition of what data is to be populated next. In the first few populations, small subjects are usually selected. In later populations, larger subjects, or even subsets of subjects, are selected. When properly done, the subject selected for population meets the needs of the current stage of development of the data warehouse.


DSS6—Data Warehouse Design


PRECEDING ACTIVITY: Data model analysis; source system analysis; bread-box analysis.


FOLLOWING ACTIVITY: Program specification.


TIME ESTIMATE: One week to three weeks.


NORMALLY EXECUTED ONCE OR MULTIPLE TIMES: Once.


DELIVERABLE: Physical database design for the warehouse.

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