SH Electric Power Improves Data Analysis and Reporting With Integrated Data Warehouse

Overview

The Shanghai Municipal Electric Power Company (SH Electric Power) handles the transmission, distribution, and sale of electrical power in Shanghai. A major challenge under the Business Information (BI) project was to move the company's routine reporting function away from its production system database, which would reduce the load on the system, and allow for new reporting features to be added. The company selected the Oracle OLAP and Oracle Data Mining modules running on Oracle Database 10g. These were then used to set up function-specific synchronized data mirrors and a central data warehouse.