Advanced analytics functions

Use advanced analytics functions to find matching sequences, to determine the difference between sequences, and to perform administrative tasks.

Scanning functions

The scanning functions find matches to a sequence using one of the analytical methods. Scanning functions return a list of matches in a LIST data type that contains a SEARCHROW data type value for each match. The SEARCHROW data type is a ROW data type with the following definition:

ROW(LVARCHAR,
   DATETIME YEAR TO FRACTION(5),
   DATETIME YEAR TO FRACTION(5),
   DOUBLE PRECISION)

The SEARCHROW data type fields have the following information:

  • A string identifier that is associated with the time series instance.
  • The begin point of the match.
  • The end point of the match.
  • The score of the match, as a double precision number 0.0-1.0 that represents the percentage of values in the matching sequence that are an exact match to the corresponding values in the search pattern.

Distance functions

The distance functions calculate the distance between two sequences using one of the analytical methods.

Input functions

The ValueAsCollection and TSGetValueList functions convert time series values or a string into sequences that you can use as the pattern arguments of the scanning functions or as the sequence arguments of the distance functions.

Administrative functions

The TSAFuncsRelease function returns the version number for the advanced analytics extension. The TSAFuncsTraceFile and TSAFuncsTraceLevel functions control tracing for the advanced analytics functions.