Oracle has announced the unprecedented ability to process more than one billion records and generate 500,000 customer bills within an eight-hour nightly window using Oracle Utilities Customer Care and Billing, Oracle Utilities Meter Data Management and Oracle Utilities Smart Grid Gateway – integrated using Oracle Application Integration Architecture and running on Oracle Exadata Database Machine X2-2and Oracle Exalogic Elastic Cloud X2-2. The test data was a subset extracted from 30 billion interval meter reads.
The test, designed according to real business scenarios, processed data reported from 10 million smart meters, each reporting nearly 100 reads per day, which is representative of the daily processing needs for a typical utility service provider.
The test used one month of historical meter data via Oracle Utilities Meter Data Management (30 billion meter readings) and a six-month billing history on Oracle Utilities Customer Care and Billing (60 million bills). The test billed each account using three different rates (simulating “peak,” “shoulder” and “off-peak” rates).
“New technologies and business processes are dramatically increasing the volume of data utilities handle during the meter-to-cash process. This test – the only one of its kind to date – proves that Oracle’s complete, integrated mission-critical software solutions running on Oracle’s engineered systems help utilities correctly size their data warehouses to process the high volumes of consumption data generated by smart meters. That data, in the end, helps utilities help their customers to monitor and manage energy use with greater flexibility and control,” said Rodger Smith, Senior Vice-President & General Manager, Oracle Utilities.