Building the Data Warehouse

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


The activity of coding produces the deliverable of programs. And finally, the activity of implementation produces a completed system.


The deliverables for data analysis for operational systems are shown in Figure A.7.


The same deliverables discussed earlier are produced by the interview and data gathering process, the sizing and phasing activity, and the definition of formal requirements.


The deliverable of the ERD activity is the identification of the major subject areas and their relationship to each other. The deliverable of the dis activity is the fully attributed and normalized description of each subject area. The final deliverable of physical database design is the actual table or database design, ready to be defined to the database management system(s).


The deliverables of the data warehouse development effort are shown in Figure A.8, where the result of the breadbox analysis is the granularity and volume analysis. The deliverable associated with data warehouse database design is the physical design of data warehouse tables. The deliverable associated with technical environment preparation is the establishment of the technical environment in which the data warehouse will exist. Note that this environment may or may not be the same environment in which operational systems exist.


M2


M3


M4


P1


P2


P3


P4


P5



P6


P7


P8


P9


P10


P11



M1

Figure A.6 METH 6. Deliverables throughout the development life cycle.



M1


M2


M3


M4


D1


D2


D3


D4

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