Building the Data Warehouse

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

raw system requirements

phases of development

formal requirements

major subject areas

midlevel detailed data model

tables, databases physically designed

Figure A.7 METH 7. Deliverables for operational data analysis.

On a repetitive basis, the deliverables of data warehouse population activities are represented by Figure A.9, which shows that the deliverable for subject area analysis-each time the data warehouse is to be populated-is the selection of a subject (or possibly a subset of a subject) for population.


Figure A.8 METH 8. Preliminary data warehouse deliverables.

DSS5    DSS7    DSS8    DSS9    DSS10

Figure A.9 METH 9. Deliverables from the steps of data warehouse development.

ming phase is the programs that will extract, integrate, and change data from current value to time variant.

IND1    IND2    IND4

Figure A.10 METH 10. Deliverables for the heuristic level of processing.

The final deliverable in the population of the data warehouse is the actual population of the warehouse. It is noted that the population of data into the warehouse is an ongoing activity.

Deliverables for the heuristic levels of processing are not as easy to define as they are for the operational and data warehouse levels of development. The heuristic nature of the analytical processing in this phase is much more informal. However, Figure A.10 shows some of the deliverables associated with heuristic processing based on the data warehouse.

Figure A.10 shows that data pulled from the warehouse is the result of the extraction program. The deliverable of the subsequent analysis step is further analysis based on data already refined. The deliverable of the final analysis of data is the satisfaction (and understanding) of requirements.

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