Designing a Framework to Standardize Data Warehouse Development Process for Effective Data Warehousing Practices

摘要

Data warehousing solutions work as information base for large organizations to support their decisionmaking tasks. With the proven need of such solutions in current times, it is crucial to effectively design,implement and utilize these solutions. Data warehouse (DW) implementation has been a challenge for theorganizations and the success rate of its implementation has been very low. To address these problems, wehave proposed a framework for developing effective data warehousing solutions. The framework isprimarily based on procedural aspect of data warehouse development and aims to standardize its process.We first identified its components and then worked on them in depth to come up with the framework foreffective implementation of data warehousing projects. To verify effectiveness of the designed framework,we worked on National Rural Health Mission (NRHM) project of Indian government and designed datawarehousing solution using the proposed framework.