Add new features to perform millions of calculations in real-time for their award-winning renewables calculation tool, upgrading the current system to handle a new battery technology.
2018 - 2019
Team As A Service
Renewable innovator, OnGen Ltd
To perform millions of calculations in real-time for their award-winning renewables calculation tool, upgrading the current system to handle a new battery technology.
Understanding big data, complex SQL, and changing usage patterns to ensure accuracy.
Our understanding of energy context sped up the process of us getting to grips with the current shortcomings of the solution. We identified the relationship between solar energy, battery and feeding into the grid. Through whiteboard sessions we worked closely with the client to prove the algorithm. To make the feature a reality we really had to take big data performance to the next level for OnGen, our team performed an extensive analysis of the database usage to firstly find initial quick wins for the client. From here, we were able to push the boundaries further by implementing the use of Column Store Indexes, Covering Indexes, and Filtered Indexes.
"ClearSky‘s knowledge and experience of the utility & renewables sectors has been an important factor in helping them to understand and support a complex software development which is helping OnGen scale the business. Their relaxed style and flexibility is underpinned by a deep technical knowledge which is a good fit with our own culture."