DIDW: An Approach for Dynamic Updating in Intelligent Data Warehouse

Transfer of information from source database into data warehouse i.e. data updating is one of the most important issue for discussionand research. Organizations that are going through it are solving by deploying dynamic and intelligent data warehouse in real-time manner. Overall strategy in dynamic and intelligent data warehouse relies on updates that are made to source database. These updates in source databaseare then stored in some temporary storage device through which they are transferred to data warehouse. This paper proposes a Dynamic andIntelligent Data Warehouse (DIDW) architecture with its implementation, using multi real-time data cache. Data cache stores updated dataretrieved by update data translator from expandable horizontally partition database. Thus it is analyzed and suggested that using this DIDW architecture in real-time manner helps to the organizations