Data Updating and Query in Real-Time Data Warehouse System

The issue of data updating is the most important issue facing organizations deploying real-time data warehouse solutions. This paper discussed the real-time data warehouse implement method, proposed feasible real-time data warehouse architecture based on SOA. This SOA based real-time data warehouse architecture uses the Web service to pack the various source database systems, and the various changed data was captured by the data capture Web service. When it comes to the data transformation and flow, the update strategy based on Web service and XML are used for the real data warehouse real-time updating. Also the multi-level real-time data cache is used for real-time data storage. Using this real-time data warehouse architecture, we can implement the real-time data warehouse easily.