PG&E Data Mining
As a leading California energy producer, Pacific Gas & Electric needed to track trends in energy costs. The state’s Independent System Operator generates 3 million pieces of XML data every day about the 55,000 megawatts of capacity on the California grid. PG&E used Perl applications to load this data into flat files. Managers got daily reports from the files but could not generate views of long-term trends.
Wired Moon provided the solution: an Oracle database with an automated system to feed in the energy data. The automated system consists of custom Java applications developed by Wired Moon. These applications download XML data from the Independent System Operator and convert the data into database elements. Long-term data now resides in a single database, making trend analysis easy.
With this system, PG&E now generates daily and weekly reports with statistical analyses that reveal vital trends in the factors that set market rates for energy. Wired Moon continues to assist PG&E in the utility’s efforts to mine the available energy data.
Select client list:
- Cell Genesis
- Coastside Fire Protection Agency
- El Dorado Ventures
- Footpath Journeys
- Heising-Simons Foundation
- Hewins Financial
- Jewish Women's Archive
- Kamehameha Schools
- Life Chiropractic College West
- Mid-Coast Television
- Nico Martin Presents
- Pacific Gas & Electric
- REA Corp
- Roche Bioscience
- Santa Clara County Office of Education
- Senvid Inc.
- SERA Learning
- Soothe Your Senses
- The Specific Chiropractic Center
- Stanford Hospital and Clinics
- Stanford Medicine
- Stanford University
- Taube-Koret Campus for Jewish Life
- Tournesol Siteworks
- University of California at Berkeley
- University of Michigan - Sienko Labs
- UC Hastings Law School - Institute for Innovation
- Yale University