Building the Data Warehouse

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

IND3—Combine, Merge, Analyze

After data has been selected, it is prepared for analysis. Often this means editing the data, combining it with other data, and refining it.

Like all other heuristic processes, it is anticipated that this program be written so that it is easily modifiable and able to be rerun quickly. The output of this activity is data fully usable for analysis.

DELIVERABLE: Analysis with other relevant data.

IND4—Analyze Data

Once data has been selected and prepared, the question is “Do the results obtained meet the needs of the analyst?” If the results are not met, another iteration occurs. If the results are met, then the final report preparation is begun.

DELIVERABLE: Fulfilled requirements.

IND5—Answer Question

The final report that is produced is often the result of many iterations of processing. Very seldom is the final conclusion the result of a single iteration of analysis.


The final issue to be decided is whether the final report that has been created should be institutionalized. If there is a need to run the report repetitively, it makes sense to submit the report as a set of requirements and to rebuild the report as a regularly occurring operation.


How the different activities relate to each other and to the notion of data architecture are described by the diagram shown in Figure A.4.

Selected Topics

The best way to describe the data-driven nature of the development methodology is graphically. Figure A.5 shows that the data model is at the heart of the data-driven methodology.

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