Before calling the NamedEntityFinder function, you must create the table of default models. To create the table, use this command:
DROP TABLE nameFind_configure; CREATE MULTISET TABLE nameFind_configure ( model_name VARCHAR(50), model_type VARCHAR(50), model_file VARCHAR(50) );
Default English-language models are provided with the SQL functions. Before using these models, you must create a default configure_table, as follows:
INSERT INTO nameFind_configure VALUES ('person','max entropy','en-ner-person.bin'); INSERT INTO nameFind_configure VALUES ('location','max entropy','en-ner-location.bin'); INSERT INTO nameFind_configure VALUES ('organization','max entropy','en-ner-organization.bin'); INSERT INTO nameFind_configure VALUES ('date','rules','date.rules'); INSERT INTO nameFind_configure VALUES ('time','rules','time.rules'); INSERT INTO nameFind_configure VALUES ('phone','rules','phone.rules'); INSERT INTO nameFind_configure VALUES ('money','rules','money.rules'); INSERT INTO nameFind_configure VALUES ('email','rules','email.rules'); INSERT INTO nameFind_configure VALUES ('percentage','rules','percentage.rules');
model_name | model_type | model_file |
---|---|---|
person | max entropy | en-ner-person.bin |
location | max entropy | en-ner-location.bin |
organization | max entropy | en-ner-organization.bin |
date | rules | date.rules |
time | rules | time.rules |
phone | rules | phone.rules |
money | rules | money.rules |
rules | email.rules | |
percentage | rules | percentage.rules |