Under the competitively awarded contract, the company will provide its relational database management software, Kdb+ to support MDM/R data retrieval, processing and analysis.
A common platform for processing, storing and managing all hourly smart meter data in Ontario, the central MDM/R has been serving more than 70 local distribution companies since 2008.
IESO Smart Metering director Przemek Tomczak said the IESO required 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,” Tomczak added.
Kx Systems Chief Strategist Simon Garland said several legacy software systems cannot manage large amounts of data.
”Kdb+ has the horsepower to do sophisticated queries that simply are impossible otherwise with this amount of streaming data," Garland added.
Kdb+ provides unified access to real-time and historical data eliminating the requirement for multiple different types of databases for transaction processing, data access and analytics.
