Page History

...

The probabilistic feature provides arbitrary functions to work with discrete and continuous probabilistic values random variables in a data stream and provides algebraic operator (+, *, -, /) to perform probabilistic addition, subtraction, multiplication, division, and exponentiation.

...

...

.

...

SQRT(Probabilistic Number)

Computes the probabilistic square root of the given probabilistic value.

sMIn(Probabilistic Number, Probabilistic Number)

Computes the minimum of two probabilistic values.

sMax(Probabilistic Number, Probabilistic Number)

Computes the maximum of two probabilistic values.

ToProbabilisticDouble(Matrix)

Constructs a discrete probabilistic value using the first column of the given matrix for the values and the second column of the matrix for the probabilities for each value.

SELECT ToProbabilisticDouble([2.0,0.25;3.0,0.75]) FROM Stream
=> (3.0:0.75;2.0:0.25)

DoubleToByte(Probabilistic Number)

Converts the given probabilistic double value to a probabilistic byte value

DoubleToShort(Probabilistic Number)

Converts the given probabilistic double value to a probabilistic short value

DoubleToInteger(Probabilistic Number)

Converts the given probabilistic double value to a probabilistic integer value

DoubleToLong(Probabilistic Value)

Converts the given probabilistic double value to a probabilistic long value

DoubleToFloat(Probabilistic Number)

Converts the given probabilistic double value to a probabilistic float value

Int(Probabilistic Distribution|Vector, Number|Vector, Number|Vector)

...