Unbounded Array Framework (UAF) functions provide functions that data scientists and business analysts can use to create time-series forecast models, digital signal processing models, and 4D spatial analytics models.
Benefits
- Unbounded Array Framework has the following types of functions:
- Data preparation
- Model preparation
- Parameter estimation
- Temporal and spatial
- Diagnostic statistical tests
- Series forecasting
- One-dimension series and two-dimension matrix instances are stored in Vantage as opposed to being stored in memory. The series instances or matrix instances are stored in any supported Teradata table type or Teradata accessible table type.
- Results can be a table or an analytic result table (ART). An ART has multiple layers, each with their own row composition, such as computed coefficients and goodness-of-fit metrics.
- Ability to plot results with auto-correlation, partial auto-correlation, and power spectrum functions.
- Ability to convert an irregular series to a regular series, and to change a sampling rate associated with a series.
Considerations
SQL Changes
The UAF functions are entries in the DBC.TVM, DBC.TVFIELDS, and DBC.UDFINFO tables.
In the DBC.TVM table, the TableKind column value is set to a value of 3, which is a new value defined for UAF functions. The Platform column is set to FPUDF. The following fields are added to the DBC.TVM table for ART attributes:
| Column Name | Data Type and Attribute | Description |
|---|---|---|
| UAFInternalId | Integer, Nullable | Unique function identifier. |
| DistributeStrategy | BYTEINT, Nullable | Distribution strategy for ART. |
| UAFLayerCount | Integer, Nullable | Number of layers in ART. |
| ExtraField1 | CHAR, Nullable | Output content type that the AF used to generate the ART table. For current release, ExtraField1 is the place holder for UAFOutputContent. |
| ExtraField2 | BYTE(4) | Reserved field. |
- AI: Identifier field
- AP: Payload field in primary layer
- AS: Payload field in secondary
- AX: Row or column identifier
Every field from the layers is stored in DBC.TVFIELDS table, there are 500 field identifiers for each layer. The first field identifier is 1025. The field identifier range 1025 to 1524 inclusively is the primary layer, 1525 to 2024 inclusively is the second layer, and so on. All layers share the same identifier fields (‘AI’) that are located and start at field identifier 1025, followed by ROW_I, and COLUMN_I, if it is present.
The following fields are reserved for UAF development:
| Column Name | Data Type and Attribute | Description |
|---|---|---|
| ExtraField1 | CHAR(1) | Reserved field. |
| ExtraField4 | Integer | Reserved field. |
The DBC.UDFINFO table, the FunctionType column value is set to a value of 3, which is defined for UAF functions. The ParameterStyle is set to a value of A. The Platform column is set to UDTFP. The UAFInternalId column was added in the DBC.UDFINFO table. The following fields are added to the DBC.UDFINFO table for ART attributes:
| Column Name | Description |
|---|---|
| DatabaseId | Identifier of the database or user. Always refers to the TD_SYSFNLIB database identifier. |
| FunctionName | UAF function name. |
| FunctionID | UAF function identifier. |
| NumParameters | Number of parameters in the function. Always 0 for UAF functions. |
| Parameter DataTypes | List of input parameters used in the function. |
| FunctionType | Type of function. Types are:
|
| ExternalName | External name of the function. The ExternalName value is the same as the FunctionName. |
| SrcFileLanguage | Source file language used to implement a user-defined function. |
| NoSQLDataAccess | Access indicated in the CREATE PROCEDURE statement. |
| ParameterStyle | Parameter passing convention for the function or external stored procedure. |
| DeterministicOpt | Indicator that the function return the same results for identical inputs. |
| NullCall | Indicator the function is called on NULL input. |
| PrepareCount | Single character representing the Prepare Count statistics option. |
| ExecProtectionMode | Indicator that the function can be run directly with a call statement, or indirectly as a separate process. |
| ExtFileReference | Encoded string that contains the external name or path of each file component that provides core DBS integration methods for the UDT. |
| CharacterType | Character type that was default when the function was activated by CREATE FUNCTION. |
| Platform | Platform that compiled the object, and indicator that the function is valid or compatible with the current platform. |
| RoutineKind | Single character indicator for the family of the routine. |
| ParameterUDTIds | Series of 4-byte UDT-type identifiers. |
| InterimFldSize | Interim field sized defined for an aggregate user-defined function. |
| MaxOutParameters | Maximum output parameters for a table function. |
| UAFInternalId | Internal identifier of the UAF. Each function is assigned a unique identifier which is also stored in TVM.UAFInternalID table. |