Kx powers Data Mart for Ontario’s Smart Meter Data

23 Aug 2017 | , , , , , , , ,
Share on:

By Przemek Tomczak

Ontario’s electricity system is overseen by a semi-governmental entity called the Independent Electricity System Operator (IESO). The IESO’s responsibilities include ensuring that there is enough power to meet the province’s energy needs and to plan for future needs. As part of that mission, a Smart Meter Entity within the IESO administers the data generated by Ontario’s four million smart meters.

The volume of data generated by the province exceeds 250 billion smart meter reads, and grows by 100 million meter reads per day. The administrator of this data is required to provide it to the utilities in the province in a timely manner and has set up a meter data management system (MDM/R) to do so.

However, the existing transaction and relational database systems within the MDM/R were not originally designed to handle the increasing requirements of the fast growing database. That’s where Kx came in with its high-performance database system kdb+, and the suite of powerful visualization tools built on top of it.

The IESO chose Kx after thoroughly testing a number of other technologies. They found that kdb+ delivered very high levels of performance at the lowest total cost of ownership. The IESO conducting over 25 tests on five years of data from five million meters, and proved that kdb+ outperformed any of its competitors.

To read more about the IESO case study please click here.

SUGGESTED ARTICLES

Kx Product Insights: Inter-Trading Alert

5 Dec 2018 | , , ,

by Aidan O’Neill Kx has a broad list of products and solutions built on the time-series database platform kdb+ that capitalize on its high-performance capabilities when analyzing very large datasets. Kx for Surveillance is a robust platform widely used by financial institutions for monitoring trades for regulatory compliance. The Surveillance platform instantly detects known trading […]

Kx extends relationship with NASA Frontier Development Lab and the SETI Institute

The Exploration of Space Weather at NASA FDL with kdb+

4 Dec 2018 | , , , ,

Our society is dependent on GNSS services for navigation in everyday life, so it is critically important to know when signal disruptions might occur. Physical models have struggled to predict astronomic scintillation events. One method for making predictions is to use machine learning (ML) techniques. This article describes how kdb+ and embedPy were used in the ML application.