Designing a framework for developing effective data warehousing solution with special reference to data mining and business intelligence