Scan_RangeQuery_LPNorm function

The Scan_RangeQuery_LPNorm function uses the L_p-norm formula to calculate how close the search pattern matches sequences of the time series.

Syntax

Scan_RangeQuery_LPNorm(
                 ts            TimeSeries,
                 ident         LVARCHAR
                 col_name      LVARCHAR
                 begin_tstamp  DATETIME YEAR TO FRACTION(5),
                 end_tstamp    DATETIME YEAR TO FRACTION(5),
                 pattern       LIST (ROW (DOUBLE PRECISION) NOT NULL),                        
                 p_value       DOUBLE PRECISION,
                 dist_hb       DOUBLE PRECISION) 
RETURNS LIST (SEARCHROW NOT NULL)

ts: The time series value for the specified primary key.
ident: A string identifier that is associated with the time series instance.
col_name: The name of the column in the TimeSeries data type from which to retrieve the values.
begin_stamp: The begin point of the range to search. Can be NULL, which represents the first element in the time series.
end_stamp: The end point of the range to search. Can be NULL, which represents the last element in the time series.
pattern: A search pattern that is returned by the ValueAsCollection or TSGetValueList function.
p_value: The p value as defined in the L_p-norm formula. Must be greater than 0.
dist_hb: The high bound of the threshold of the L_p-norm distance.

Usage

Run the Scan_RangeQuery_LPNorm function to find fragments in the specified time series for the specified time range that are under the threshold of the constraint, which is based on the L_p-norm distance that is computed with the specified pattern. The length of the fragments must be the same. See Lp-norm.

Returns

A list of matches in a LIST data type that contains a SEARCHROW data type value for each match. See Scanning functions.