N/APosted on - 07/30/2011
It is believed that Classical SDLC is not suitable for Data warehouse environment. In your point of view why is it not suitable? Secondly what changes do you suggest to be made in Classical SDLC to make it suitable for data warehouse? Give reasons to support your ideas.
Classical SDLC is not suitable for Data warehouse environment
We develop a data warehouse to build Decision Support System (DSS) however the classical system development life cycle (SDLC) does not fit for developing the DWS. This is because SDLC requirement is to know all the requirements in advance whereas in case of DWH the requirements are not known in advance but rather the requirements arise as the DWS is developed.
There are some suggestions which if employed, can make the SDLC a bit flexible.
The requirements are not known in advance show the DWH developer has to build some part of the DWH, and then give to the user. Once they start using the DWH, the user will know their requirements and thus then the SDLC phases can be used.
The SDLC phases show has a linkage direct with another phase will lead to the flexibility to move from a phase to another phase at any time. This will make it very much flexible.
There should be a mechanism to move to the implementation phase and then to the requirements for analyzing the requirements.
Prototyping can be helpful to get the feedback from the user about the enhancement of the system.