Ontario’s Independent Electricity System Operator (IESO) has selected Kx Systems’ kdb+ database to support the retrieval and querying of smart meter data processed by the province’s meter data management and repository (MDM/R) system.
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.
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.
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 www.smi-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.
About Kx Systems
Kx Systems offers a unified approach to real-time and historical data analysis with its high-performance kdb+ database platform. kdb+ provides a portable, 64-bit implementation of the platform’s expressive query and programming language, q, to analyze and store streaming events, manipulate in-memory and on-disk databases, and build distributed, low-latency applications. The company’s focus is on delivering the best performance and flexibility for high-volume, data-intensive analytics and applications. For more information, visit http://kx.com.