1.1 - 8.10 - FellegiSunter Output - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Output (Model) Table Schema

Column Data Type Description
_key VARCHAR Model property name (see following table).
_value VARCHAR Model property value.

Model Properties

In this table, i is in the range [0, comparison_field_cnt-1].

Property Name Data Type Description
comparison_field_cnt INTEGER Count of comparison fields, equal to length of list specified by ComparisonFields syntax element.
comparison_field_name_i VARCHAR [Column appears once for each comparison field.] Name of comparison field i.
comparison_field_threshold_i DOUBLE PRECISION [Column appears once for each comparison field.] Threshold of comparison field i. If similarity value exceeds this value, objects agree on field i.
is_supervised BYTEINT '1' for supervised learning, '0' for unsupervised learning.
lambda DOUBLE PRECISION Type I (false negative) error, which occurs if unmatched comparison is erroneously linked.
lower_bound DOUBLE PRECISION Lower bound for match. If weight of object pair is less than lower bound, objects do not match.
m_i DOUBLE PRECISION [Column appears once for each comparison field.] Probability that objects in matched pair agree on field i.
mu DOUBLE PRECISION Type II (false positive) error, which occurs if matched comparison is erroneously not linked.
p DOUBLE PRECISION [Column appears only without TagColumn syntax element; that is, for unsupervised learning.] Percentage of object pairs that contain same object.
time_used DOUBLE PRECISION Time function used to learn model parameters.
u_i DOUBLE PRECISION [Column appears once for each comparison field.] Probability that objects in unmatched pair agree on field i.
upper_bound DOUBLE PRECISION Upper bound for match. If weight of object pair is greater than upper bound, objects match.