Описание тега oracle-text
What questions should have this tag?
All questions referencing Oracle indexes:
- CONTEXT
- CTXCAT
- CTXRULE
- CTXPATH
or Oracle query operators that rely on those indexes:
- CONTAINS
- CATSEARCH
- MATCHES
Definitions
Text Query Applications
The purpose of a text query application is to enable users to find text that contains one or more search terms in a collection of documents such as plain text, HTML, XML, or Microsoft Word. It requires either a CONTEXT or CTXCAT index, which can be queried using CONTAINS or CATSEARCH operators respectively.
Document Classification Applications
A document classification application is one that classifies an incoming stream of documents based on its content. For example, an online news agency might need to classify its incoming stream of articles as they arrive into categories such as politics, crime, and sports.
This scenario requires a CTXRULE index. This index indexes the rules (queries) that define each class. When documents arrive, the MATCHES operator can be used to match each document with the rules that select it.