My Oracle Support Banner

CQL - StandardDeviation Operator Doesn't Scale (Doc ID 1510164.1)

Last updated on JULY 14, 2015

Applies to:

Oracle Event Processing - Version and later
Information in this document applies to any platform.


On : version, CEP system

The standardDeviation aggregator keeps the individual values, and recalculates the output based on every value. This doesn't scale. Not only does it require storage for all of the values (which will grow until OOME for a stream), it re-calculates the result from every value for each event.

standardDeviation should scale the value.

The issue can be reproduced at will with the following steps:
1. Create a standardDeviation aggregator
2. Notice it won't scale the value.

The issue has the following business impact:
Due to this issue, users cannot use the OOB standardDeviation aggregator.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.