Traditional warehouse systems cannot do real-time analysis due to its relatively long data extraction period. In order to improve it, this paper puts forward a real-time data warehouse implementation method. This method adopts copying table structure and setting limitation on querying to loading data in data warehouse consistently and effectively. It also demonstrates how to integrate the real-time data by using the data warehouse architecture and OLTP queries in client.