Construction of Real Time Data Warehouse

Data warehouse is a copy of transaction data specifically structured for querying, analysis and reporting Data warehouse is a database application that actually store and collect the data from any particular business domain for decision support system. There are different ways to implement and design the data warehouse. Some processes are involved the data extraction, transformation and loading. Integration of the data from various sources in to the data warehouse is major concept. So, while the design of the data warehouse such that to entertain all these processes accurately then we can guarantee the data purity. Approach of recent times is becoming very much famous now days that is real time data warehouse. Real time data warehouse actually load the data from the transactional and operational data stores when in real time. As soon the data is coming up in the external data source it will appear into the real time data warehouse so this paper will cater the discussion of structure of real time data warehouse. Real time data warehouse approach has major deficit of extraction and loading process. It could be very efficient source of decision support system if we can eliminate the deficiencies.