Proposed Techniques to Design Speed Efficient Data Warehouse Architecture for Fastening Knowledge Discovery Process

Decision-making is the key factor of any organization which decides organization’s sustainability in competitive market and its continuous growth and helps in knowledge discovery process. These decisions are taken based on analysis of historical and current data, which are managed by data warehouses (DWH). Based on the datasets provided by these DWH, crystal and ad-hoc reports are generated by BI tools. So, Speed of data warehouse architectures plays a prominent role for deriving decisions at right time. In this paper we have proposed techniques to make data warehouse architecture speed efficient. For speed optimization we have not only worked on data warehouse architecture but also, we have worked on various operations performed by data warehouse, which further boost the overall data warehouse architecture speed.