Building the Data Warehouse

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


NORMALLY EXECUTED ONCE OR MULTIPLE TIMES: NA DELIVERABLE: Usable data warehouse.


This step entails nothing more than the execution of the DSS programs previously developed. The issues addressed here are the following:


■    Frequency of population


■    Purging populated data


for each subject

Figure A.2 METH 2.


■■ Aging populated data (i.e., running tallying summary programs)


■■ Managing multiple levels of granularity


■■ Refreshing living sample data (if living sample tables have been built)


The output of this step is a populated, functional data warehouse.


PARAMETERS OF SUCCESS: When done properly, the result is an accessible, comprehensible warehouse that serves the needs of the DSS community.


HEURISTIC PROCESSING-METH 3


The third phase of development in the architected environment is the usage of data warehouse data for the purpose of analysis. Once the data in the data warehouse environment is populated, usage may commence.


There are several essential differences between the development that occurs at this level and development in other parts of the environment. The first major difference is that at this phase the development process always starts with data, that is, the data in the data warehouse. The second difference is that requirements are not known at the start of the development process. The third difference (which is really a byproduct of the first two factors) is that processing is done in a very iterative, heuristic fashion. In other types of development, there


DEPT1

—    for departmental, repetitive reports


—    for heuristic analytical processing

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