FellegiSunter Output - Teradata Vantage

Machine Learning Engine Analytic Function Reference
Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantage™

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 argument.
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 argument; 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.