Data Warehouse Development Standardization Framework (DWDSF): A Way to Handle Data Warehouse Failure

Deepak Asrani, Dr. Renu Jain, Dr. Usha Saxena
2017 IOSR Journal of Computer Engineering  
Why does large number of data warehousing projects fail? How to avoid such failures? How to meet out user's expectations and fulfil data analysis needs of business managers from data warehousing solutions? How to make data warehousing projects successful? These are some of the key questions before data warehouse research community in the present time. Literature shows that large numbers of data warehousing projects undertaken eventually result in a failure. In this paper, we have designed a
more » ... ework named "Data Warehouse Development Standardization Framework" (DWDSF), to help data warehouse developer's community in implementing effective data warehousing solutions. We have critically analysed literature to find out possible reasons of data warehouse project failure. Our framework has been designed to overcome such issues and enable implementation of successful data warehousing solutions. To verify usefulness of our framework, we have applied guidelines of DWDSF framework to design and implement data warehousing solution for National Rural Health Mission (NRHM) project which offers various health services throughout the country. The developed solution is giving results for all type of queries business managers want to run. We have shown results of some sample queries executed over the implemented data warehouse repository. All results are meeting out business manager's query expectations.
doi:10.9790/0661-1901022938 fatcat:u2b5sql245e3vdk3d7nkekgczq