SOA Based Electric Power Real-Time Data Warehouse

At present, traditional data warehouse can no longer satisfy the electric power enterprise's decision support, real-time data warehouse can provide the electric power enterprise with daily tactical operation technical support, and the article 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 electric power 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 message queue and XML are used for the 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 electric power real-time data warehouse easily.