This document describes a number of in-database analytic functions that are invoked from any Teradata SQL query execution product, such as Teradata Studio or Teradata Bteq. The controlling program for these analytic functions is a custom Teradata External Stored Procedure called TD_Analyze. Some of the functions also use custom Teradata Table Operators. To use the Teradata Warehouse Miner (Miner) In-Database Analytic Functions, these user-defined functions (UDF) must be installed in the Teradata database using a console application supplied with Miner, accessible from the Start menu in the Miner program group. Once these UDFs are installed, they are executed without invoking the Miner client application.
Although independent of the Miner client application, the in-database analytic functions are based on functions available in Miner. All of the in-database functions and more are provided in the Miner client application, which has three principal function categories.
|Data Profiling||Descriptive statistics provided to generate reports and graphics with drill down capabilities, pointing out potential data quality issues. The In-Database Descriptive Statistics functions are derived from the corresponding functions in the Data Profiling function category.|
|Analytic Data Set (ADS) Generation||Functions used to build and transform analytic data sets. The In-Database Variable Transformation function is derived from the Variable Transformation function in the Analytic Data Set Generation function category.|
|Analytic Functions||Functions used to invoke analytic algorithms and scoring along with statistical tests. The In-Database Fast K-Means algorithm and the Gain Ratio Extreme algorithm provide new variations of the Clustering and Decision Tree algorithms and scoring in Miner in the Analytic Functions category.|