Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
TimeSeries Data User's GuideThe HCL OneDB™ TimeSeries Data User's Guide contains information to assist you in using the TimeSeries extension with HCL OneDB™.
Advanced analyticsAdvanced analytics functions provide specialized methods of analyzing time series data for patterns or abnormalities.
Advanced analytics functionsUse advanced analytics functions to find matching sequences, to determine the difference between sequences, and to perform administrative tasks.
TSCompute_Sakoe_Chiba_Constraint_Dist functionThe TSCompute_Sakoe_Chiba_Constraint_Dist function calculates a similarity score for two time series sequences with the Sakoe-Chiba constraint.

TSCompute_Sakoe_Chiba_Constraint_Dist function

The TSCompute_Sakoe_Chiba_Constraint_Dist function calculates a similarity score for two time series sequences with the Sakoe-Chiba constraint.

Syntax

TSCompute_Sakoe_Chiba_Constraint_Dist (
                 sequence1           list,
                 sequence2           list,
                 norm_mconstraint    DOUBLE PRECISION) 
RETURNS DOUBLE PRECISION

sequence1: A list of values that is returned by the ValueAsCollection or TSGetValueList function.
sequence2: A list of values that is returned by the ValueAsCollection or TSGetValueList function.
norm_mconstraint: A number that represents the normalized mConstraint in the Sakoe-Chiba formula.

Usage

Run the TSPearson_Correlation_Score function to calculate the similarity distance between two time series sequences, restricted by the Sakoe-Chiba constraint. The length of the sequences must be the same. See Dynamic time warping.

Returns

A number that represents the distance.