1.1 - 8.10 - Named Entity Finder Evaluator Example - 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)

Input

Input Table: nermem_sports_test
id content
3 <START:LOCATION> LONDON <END> 1996-08-30
4 West Indian all-rounder <START:PER> Phil Simmons <END> took four for 38 on Friday as <START:ORG> Leicestershire <END> beat <START:ORG> Somerset <END> by an innings and 39 runs in two days to take over at the head of the county championship .
6 After bowling <START:ORG> Somerset <END> out for 83 on the opening morning at <START:LOCATION> Grace Road <END>
9 <START:PER> Hussain <END>
10 By the close <START:ORG> Yorkshire <END> had turned that into a 37-run advantage but off-spinner <START:PER> Such <END> had scuttled their hopes
11 At the <START:LOCATION> Oval <END>
12 He was well backed by <START:LOCATION> England <END> hopeful <START:PER> Mark Butcher <END> who made 70 as <START:ORG> Surrey <END> closed on 429 for seven
14 Australian <START:PER> Tom Moody <END> took six for 82 but <START:PER> Chris Adams <END>
16 They were held up by a gritty 84 from <START:PER> Paul Johnson <END> but ex-England fast bowler <START:PER> Martin McCague <END> took four for 55 .
20 <START:LOCATION> LONDON <END> 1996-08-30
22 <START:LOCATION> Leicester <END> : <START:ORG> Leicestershire <END> beat <START:ORG> Somerset <END> by an innings and 39 runs .
... ...

SQL Call

SELECT * FROM NamedEntityFinderEvaluatorReduce (
  ON NamedEntityFinderEvaluatorMap (
    ON nermem_sports_test
    USING
    InputModelFile ('location.sports')
    TextColumn ('content')
  ) PARTITION BY 1
) AS dt;

Output

 precision_val     recall             f_measure         
 ----------------- ------------------ ----------------- 
 0.847457627118644 0.7936507936507936 0.819672131147541

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.