San Antonio, TX, U.S.A. — (METERING.COM) — January 30, 2012 – Oracle has announced the ability to process more than one billion records and generate half million customer bills within an eight-hour nightly window using the Customer Care and Billing, Meter Data Management and Smart Grid Gateway systems, using a subset of data extracted from 30 billion interval meter reads, a volume level typical for a large utility.
The systems were integrated using Application Integration Architecture and run on Exadata Database Machine X2-2 and Exalogic Elastic Cloud X2-2.
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.
“New technologies and business processes are dramatically increasing the volume of data utilities handle during the meter-to-cash process,” commented Rodger Smith, senior vice president and general manager of Oracle Utilities. “This test proves that Oracle’s complete, integrated mission-critical software solutions running on its engineered systems help utilities correctly size their data warehouses to process the high volumes of consumption data generated by smart meters.”