ART_SPEC Element | Teradata Vantage - ART Specifications - 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
2024-10-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
lifecycle
latest

The primary use of an analytical result table (ART) is to associate function results with a name label, enabling you to easily retrieve the result data and pass the result to another UAF function. An ART can have multiple layers. Each layer has its own dedicated row composition for the series or matrix. This lets you store and analyze complex data structures in a tabular format. For example, a time series with multiple dimensions can be stored in an ART with multiple layers.

An ART is a table generated by the INTO ART or INTO VOLATILE ART clause of a UAF function. The INTO ART clause creates a permanent table. The INTO VOLATILE ART clause creates a volatile table. A volatile table is only available during the current session and is automatically dropped when the session ends.

You can assign a name to the table and to some of its columns, but all other aspects of the table are set by Teradata. Using EXECUTE FUNCTION INTO VOLATILE ART is slightly faster than using EXECUTE FUNCTION INTO ART. User manipulation of ART tables, such as update, insert and delete, is not allowed. See EXECUTE FUNCTION for information about using INTO ART and INTO VOLATILE ART in Teradata Vantageā„¢ - SQL Data Manipulation Language.

An ART can be referenced by a SERIES_SPEC or ART_SPEC. When referenced by an ART_SPEC, the specification represents a simplified way of referencing the output similar of programming environments such as R and PYTHON. For example, the partial auto-correlation function can take a time series or the output of another auto-correlation function as input.

Similar to R and PYTHON environments, not all time series functions accept a simplified ART_SPEC as input. Time series functions that do accept ART_SPECs have a reference to ART_SPEC as acceptable input in the Syntax section. The following table lists the functions that accept ART_SPECs.

Function Supports ART_SPEC Required ART_SPEC Parameter Function that Produced ART_SPEC
TD_DICKEY_FULLER
  • TABLE_NAME
  • TD_LINEAR_REGR
  • TD_MULTIVAR_REGR
  • TD_ARIMAESTIMATE
  • TD_ARIMAVALIDATE
  • TD_MAMEAN
  • TD_SIMPLEEXP
  • TD_HOLT_WINTERS_FORECASTER
TD_DURBIN_WATSON
  • TABLE_NAME
  • TD_LINEAR_REGR
  • TD_MULTIVAR_REGR
  • TD_ARIMAESTIMATE
  • TD_ARIMAVALIDATE
  • TD_MAMEAN
  • TD_SIMPLEEXP
  • TD_HOLT_WINTERS_FORECASTER
TD_BREUSCH_GODFREY
  • TABLE_NAME
  • TD_LINEAR_REGR
  • TD_MULTIVAR_REGR
  • TD_ARIMAESTIMATE
  • TD_ARIMAVALIDATE
  • TD_MAMEAN
  • TD_SIMPLEEXP
  • TD_HOLT_WINTERS_FORECASTER
TD_BREUSCH_PAGAN_GODFREY
  • TABLE_NAME
  • TD_LINEAR_REGR
  • TD_MULTIVAR_REGR
  • TD_ARIMAESTIMATE
  • TD_ARIMAVALIDATE
  • TD_MAMEAN
  • TD_SIMPLEEXP
  • TD_HOLT_WINTERS_FORECASTER
TD_WHITES_GENERAL
  • TABLE_NAME
  • TD_LINEAR_REGR
  • TD_MULTIVAR_REGR
  • TD_ARIMAESTIMATE
  • TD_ARIMAVALIDATE
  • TD_MAMEAN
  • TD_SIMPLEEXP
  • TD_HOLT_WINTERS_FORECASTER
TD_CUMUL_PERIODGRAM
  • TABLE_NAME
  • LAYER (ARTFITRESIDUALS)
  • TD_ARIMAESTIMATE with FIT_PERCENTAGE(100)
  • TD_ARIMAVALIDATE
  • TD_MAMEAN
  • TD_SIMPLEEXP
  • TD_HOLT_WINTERS_FORECASTER
TD_SIGNIF_PERIODICITIES
  • TABLE_NAME
  • LAYER (ARTFITRESIDUALS)
  • TD_ARIMAESTIMATE with FIT_PERCENTAGE(100)
  • TD_ARIMAVALIDATE
  • TD_MAMEAN
  • TD_SIMPLEEXP
  • TD_HOLT_WINTERS_FORECASTER
TD_SIGNIF_RESIDEMEAN
  • TABLE_NAME
  • LAYER (ARTFITRESIDUALS)
  • TD_ARIMAESTIMATE with FIT_PERCENTAGE(100)
  • TD_ARIMAVALIDATE
  • TD_MAMEAN
  • TD_SIMPLEEXP
  • TD_HOLT_WINTERS_FORECASTER
TD_PORTMAN
  • TABLE_NAME
  • LAYER (ARTFITRESIDUALS)
  • TD_ARIMAESTIMATE with FIT_PERCENTAGE(100)
  • TD_ARIMAVALIDATE
  • TD_MAMEAN
  • TD_SIMPLEEXP
  • TD_HOLT_WINTERS_FORECASTER
TD_FITMETRICS
  • TABLE_NAME
  • LAYER (ARTFITRESIDUALS)
  • TD_LINEAR_REGR
  • TD_MULTIVAR_REGR
  • TD_ARIMAESTIMATE
  • TD_ARIMAVALIDATE
  • TD_MAMEAN
  • TD_SIMPLEEXP
  • TD_HOLT_WINTERS_FORECASTER
TD_SELECTION_CRITERIA
  • TABLE_NAME
  • TD_ARIMAESTIMATE with FIT_PERCENTAGE(100)
  • TD_ARIMAVALIDATE
TD_PACF
  • TABLE_NAME
  • TD_ACF
TD_ARIMAESTIMATE
  • TABLE_NAME

Second optional input only

  • TD_ARIMAESTIMATE with FIT_PERCENTAGE(100)
  • TD_ARIMAVALIDATE
TD_ARIMAVALIDATE
  • TABLE_NAME
  • TD_ARIMAESTIMATE
TD_UNDIFF
  • TABLE_NAME

Primary input only

  • TD_DIFF
TD_UNNORMALIZE
  • TABLE_NAME
  • LAYER(ARTMETADATA)
  • PAYLOAD

    See TD_UNNORMALIZE for PAYLOAD requirements

TD_SEASONALNORMALIZE
TD_ARIMAFORECAST
  • TABLE_NAME
  • TD_ARIMAESTIMATE with FIT_PERCENTAGE(100)
  • TD_ARIMAVALIDATE
TD_DFFTCONV
  • TABLE_NAME
  • TD_DFFT
TD_EXTRACT_RESULTS
  • TABLE_NAME
  • LAYER
Any function that produces a multilayer ART