Kx Systems reports that its 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.”
The MDM/R serves more than 70 local distribution companies, handling reads from over four million meters, and processing over 100 million transactions per day.
Przemek Tomczak, IESO director of smart metering says his company “needed a time-series database technology that could handle large volumes of time-series smart meter data efficiently and at the lowest total cost. 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.”
Kx Systems chief strategist Simon Garland explains, “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.”
According to the IESO, it is responsible for “managing Ontario’s bulk electricity power system and operating the wholesale market,” and “the administration and operation of the MDM/R, including the collection, validation, estimation and the ability for distributors to edit the meter read data.”