ACADEMIA

Oracle 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-2 and Oracle Exalogic Elastic Cloud X2-2. The test data was a subset extracted from 30 billion interval meter reads, a volume level typical for a large utility.

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).

The configuration tested was able to compress archive data at up to a 45X ratio using Oracle Exadata Hybrid Columnar Compression, enabling storage efficiencies that generate significant cost savings to utilities storing smart grid and other data.