Syntax:
TM_CATEGORIZE_KNN (
<tm_document>
<tm_search_categorize_knn>
{ <tm_return_category>, ….}
)
Where
<tm_document> :=
DOCUMENT { <string> [ LANGUAGE <string> ] [ MIME TYPE <string> ]
| ( <subquery> ) [ LANGUAGE <string> ] [ MIME TYPE <string> ]
| IN FULLTEXT INDEX WHERE <condition> }
Specify the document which you want to categorize in <tm_document>. Either provide text as string or provide a select query or specify query document as part of full text index using where clause for restriction.
SEARCH NEAREST NEIGHBORS
{ <knn_int> | DEFAULT }
<reference_column> FROM <reference_table> [ WHERE <condition>]
[ WITH TERM TYPE <string>, ….]
….
In <tm_search_categorize_knn> you search for nearest neighbors by providing below syntax. Specify the reference document in reference column and table. Reference document can be restricted by specifying where condition or with term type clause.
RETURN TOP { <top_int>| DEFAULT }
<category_column> FROM <category_table>
[ JOIN <reference_column> ON <primary key of category table> = <primary key of reference table> ]
In { <tm_return_category>, ….} this provides the maximum number of category results to return for the specified category column. It may be a column in the same table as the reference documents or a column in a different table that can be used with the join clause.
Syntax
TM_GET_RELATED_TERMS (
<tm_term>
<tm_search>
<tm_return_term> )
Where
<tm_term> :=
TERM <string> [ LANGUAGE <string> ]
Specifies the term and the language to be processed. Input term can be single term or multiple terms with optional terms types and wildcards example: sap, sap:noun (used as a noun) etc.
<tm_search> :=
SEARCH <column> FROM <table> [ WHERE <condition> ]
[ WITH TERM TYPE <string>, ... ]
Specifies the set of reference documents in <column> and <table>. The specified column must be of type text or must have a full-text index. Set of documents can be restricted by where conditions and with term type.
<tm_return_term> :=
RETURN
[ PRINCIPAL COMPONENTS <pc int> ] -- output FACTORS, ROTATED_FACTORS
[ CLUSTERING [<string>] ] -- output CLUSTER_LEVEL, CLUSTER_LEFT,
-- CLUSTER_RIGHT
[ CORRELATION ] -- output CORRELATIONS
TOP { <top int> | DEFAULT }
Syntax:
TM_GET_RELEVANT_TERMS (
<tm_document>
<tm_search>
<tm_return_term> )
<tm_document> :=
DOCUMENT { <string> [ LANGUAGE <string> ] [ MIME TYPE <string> ]
| ( <subquery> ) [ LANGUAGE <string> ] [ MIME TYPE <string> ]
| IN FULLTEXT INDEX WHERE <condition> }
Either provide text as string or provide a select query or specify query document part of full text index using where clause for restriction.
<tm_search> :=
SEARCH <column> FROM <table> [ WHERE <condition> ]
[ WITH TERM TYPE <string>, ... ]
Specifies the set of reference documents in <column> and <table>. The specified column must be of type text or must have a full-text index. Set of documents can be restricted by where conditions and with term type.
<tm_return_term> :=
RETURN
[ PRINCIPAL COMPONENTS <pc int> ] -- output FACTORS, ROTATED_FACTORS
[ CLUSTERING [<string>] ] -- output CLUSTER_LEVEL, CLUSTER_LEFT
-- CLUSTER_RIGHT
[ CORRELATION ] -- output CORRELATIONS
TOP { <top int> | DEFAULT }
Syntax:
TM_GET_SUGGESTED_TERMS
( <tm_term>
<tm_search>
<tm_return_top> )
Where
<tm_term> :=
TERM <string> [ LANGUAGE <string> ]
Specifies the term and the language to be processed.
<tm_search> :=
SEARCH <reference column> FROM <reference table> [ WHERE <condition> ]
[ WITH TERM TYPE <string>, ... ]
Specifies the set of reference documents in <reference column> and <reference table>. The specified column must be of type text or must have a full-text index. Set of documents can be restricted by where conditions and with term type.
<tm_return_top> :=
RETURN TOP { <top int> | DEFAULT }
Specifies the number of top returned terms.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 | |
5 | |
4 | |
4 | |
4 | |
4 |