TD_SAX Syntax Elements | Teradata Vantage - TD_SAX Syntax Elements - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-12-08
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
SERIES_SPEC
Specify the SERIES_SPEC of the input time series.

See Series Specifications.

FUNC_PARAMS
Name Data Type Description
WINDOW_TYPE Enumerated list [Optional] Amount of data that the function processes at one time. Options are:
  • global: The function computes the SAX code using a single mean and standard deviation for the entire data set.
  • sliding: The function recomputes the mean and standard deviation for a sliding window of the data set.

The default is global.

OUTPUT_TYPE Enumerated list [Optional] The format of the results. Options are:
  • STRING: The function outputs a list of SAX codes for each window.
  • BITMAP: The function outputs a JSON representation of a SAX bitmap.
  • O_CHARS: The function outputs one character for each line.

The default is STRING.

MEAN Comma separated list of FLOAT [Optional] The global mean values that the function uses to calculate the SAX code for every partition.

If the mean specifies one value and multiple payloads, then the specified value applies to every payload. If the mean specifies multiple values, then it must specify a value for each payload. The nth mean value corresponds to the nth payload.

STD_DEV Comma separated list of FLOAT [Optional] The global standard deviation values that the function uses to calculate the SAX code for every partition.

If the standard deviation specifies only one value and multiple payloads, then the specified value applies to every payload. If the standard deviation specifies multiple values, then it must specify a value for each payload. The nth standard deviation value corresponds to the nth payload.

WINDOW_SIZE Integer [Optional] The size of the sliding window. If window type is sliding, then WINDOW_SIZE is required. Maximum value is 64000.
OUTPUT_FREQUENCY Integer [Optional] The number of data points that the window slides between successive outputs. The value must be greater than 0. The default is 1.

This is valid with WINDOW_TYPE sliding only.

POINTS_PER_SYMBOL Integer [Optional] The number of data points to be converted to one SAX symbol. Each value must be an integer greater than 0. The default is 1.

This is valid with WINDOW_TYPE global only.

SYMBOLS_PER_WINDOW Integer [Optional] The number of SAX symbols to be generated for each window. Each value must be greater than 0. The default is 1.

This is valid with WINDOW_TYPE sliding only.

ALPHABET_SIZE Integer [Optional] The number of symbols in the SAX alphabet. The alphabet consists letters a through t. The value must be an integer in the range [2, 20]. The default is 4, meaning abcd.
BITMAP_LEVEL Integer [Optional] The number of consecutive symbols to be converted to one symbol on a bitmap. For bitmap level 1, the bitmap contains the symbols 'a', 'b', 'c', and so on. For bitmap level 2, the bitmap contains the symbols 'aa', 'ab', 'ac', and so on. The input value must be an integer in the range [1, 4]. The default is 2.

It is valid with OUTPUT type BITMAP.

CODE_STATS Integer [Optional] Indicator that the function prints the mean and standard deviation. Options are true and false. The default is false.
BREAKPOINTS Comma separated list of FLOAT [Optional] The breakpoints to form the SAX code based on input data.
OUTPUT_FMT
[Optional] The INDEX_STYLE which is NUMERICAL_SEQUENCE.