Abstract: This article analysed the real-time decision requirement of the data warehouse of a specific application system,identified database tables which need to be updated in real-time to data warehouse.Then compared several overall plan of real time data loading,after comprehensive consideration,we designed a method of real time data loading—using the CDC mechanism to acquire the changed data,and then circularly load the changed data to data warehouse via data loading program.After experimental verification,this method can meet the requirement of real time data loading,while doesn’t have much influence over the Database Transaction.So it’s suitable to be applied to the system.

Key words: Real-time data warehouse,Real-time updating,Changed data capture,Data loading