Kdb+ chosen by IESO for smart meter analytics

Kx Systems’ kdb+ chosen by Ontario electric grid operator

22 Jan 2014 | , , , , , ,
Share on:

Palo Alto, CA (22 Jan 2014) – Kx Systems has been selected to provide its kdb+ database to Ontario, Canada’s Independent Electricity System Operator (IESO) to support the retrieval and querying of smart meter data processed by Ontario’s Meter Data Management and Repository (MDM/R) system.

Following a competitive evaluation, Kx Systems was awarded the IESO contract based on its ability to meet or exceed demanding functional and performance requirements while doing so at the lowest total cost of ownership.

Kx Systems’ relational database management software will be utilized to support MDM/R data retrieval, processing and analysis. In Ontario, the central MDM/R provides a common platform for processing, storing and managing all hourly Smart Meter data in the province. In operation since 2008, it is one of the world’s largest systems of its kind and serves over 70 local distribution companies, handling reads from over four million meters, and processing over 100 million transactions per day.

“The IESO needed a time-series database technology that could handle large volumes of time-series smart meter data efficiently and at the lowest total cost”, said Przemek Tomczak, Director – Smart Metering at the IESO. “We found after conducting extensive research, evaluations and proof of concept testing, that kdb+ and its q programming language, delivered very high levels of performance at the lowest total cost of ownership.”

Kdb+ provides unified access to real-time and historical data eliminating the need for multiple different types of databases for transaction processing, data access and analytics.

“As data sets have grown from hundreds of records to millions, and tables from millions of rows to hundreds of billions, many legacy software systems cannot scale. To manage that amount of data, not just to store it, you need speed. Kdb+ has the horsepower to do sophisticated queries that simply are impossible otherwise with this amount of streaming data,” said Simon Garland, Chief Strategist with Kx Systems.

The IESO is responsible for managing Ontario’s bulk electricity power system and operating the wholesale market. The IESO as the Smart Metering Entity is responsible for the administration and operation of the MDM/R, including the collection, validation, estimation and the ability for distributors to edit the meter read data. For more information, please visit http://ieso.ca/.

Widely adopted in the financial services sector, kdb+ is also used in other industries, like energy, where the management and analysis of massive amounts of time-based data at high speeds is critical.


Kx selected by Survalent Technology for advanced sensor analytics

Kdb+ sets benchmark for GCP in first-ever cloud STAC-M3 tests

29 Oct 2018 | , ,

(Newry, Northern Ireland, 29 October 2018) Kx announces excellent results for the kdb+ database system in the first-ever cloud benchmark tests performed by the Securities Trading Analysis Center (STAC). Two recent STAC-M3 tests, run on Google Cloud Platform (GCP), validate the use of kdb+ for massive amounts of market data, trade data and database-of-record applications […]

European Energy Market Contract Win

European Energy Market Contract Win with Fingrid

16 Jul 2018 | , , , , ,

FD (AIM:FDP.L, ESM:FDP.I) announces that it has been selected, alongside its partner CGI, to deliver a next-generation electricity information exchange for Fingrid, the transmission system operator for Finland. This significant contract win further demonstrates Kx technology’s applicability within utilities, in particular opening up the potential for further wins as transmission system and energy market operators […]

Kx offers kdb+ on-demand for Cloud and on-premises

Kx offers kdb+ on-demand for Cloud and on-premises

27 Mar 2018 | ,

PALO ALTO, CA (27 March 2018) Kx Systems announces that it has released a subscription-based version of kdb+, its core technology. Kdb+ on demand has a new flexible pricing model which makes it widely accessible to programmers for all uses. This model is available for use on premises, as well as to meet the rising […]