Metadata Views for Semantic Indexing
This section describes views that contain metadata about semantic indexing
RDFCTX_POLICIES View
Information about extractor policies defined in the current schema is maintained in the RDFCTX_POLICIES view, which has the columns shown in Table: RDFCTX_POLICIES View Columns and one row for each extractor policy.
Table: RDFCTX_POLICIES View Columns
| Column Name | Data Type | Description |
|---|---|---|
| POLICY_OWNER | VARCHAR2(32) | Owner of the extractor policy |
| POLICY_NAME | VARCHAR2(32) | Name of the extractor policy |
| EXTRACTOR | MDSYS.RDFCTX_EXTRACTOR | Instance of extractor type |
| IS_DEPENDENT | VARCHAR2(3) | Contains YES if the extractor policy is dependent on a base policy; contains NO if the extractor policy is not dependent on a base policy. |
| BASE_POLICY | VARCHAR2(32) | For a dependent policy, the name of the base policy |
| USER_MODELS | SEM_MODELS | For a dependent policy, a list of the RDF graphs included in the policy |
RDFCTX_INDEX_POLICIES View
Information about semantic indexes defined in the current schema and the extractor policies used to create the index is maintained in the RDFCTX_POLICIES view, which has the columns shown in Table: RDFCTX_INDEX_POLICIES View Columns and one row for each combination of semantic index and extractor policy.
Table: RDFCTX_INDEX_POLICIES View Columns
| Column Name | Data Type | Description |
|---|---|---|
| INDEX_OWNER | VARCHAR2(32) | Owner of the semantic index |
| INDEX_NAME | VARCHAR2(32) | Name of the semantic index |
| INDEX_PARTITION | VARCHAR2(32) | Name of the index partition (for LOCAL index only) |
| POLICY_NAME | VARCHAR2(32) | Name of the extractor policy |
| EXTR_PARAMETERS | VARCHAR2(100) | Parameters specified for the extractor |
| IS_DEFAULT | VARCHAR2(3) | Contains YES if POLICY_NAME is the default extractor policy for the index; contains NO if POLICY_NAME is not the default extractor policy for the index. |
| STATUS | VARCHAR2(10) | Contains VALID if the index is valid, INPROGRESS if the index is being created, or FAILED if a system failure occurred during the creation of the index. |
| RDF_MODEL | VARCHAR2(32) | Name of the RDF graph maintaining the index data |
RDFCTX_INDEX_EXCEPTIONS View
Information about exceptions encountered while creating or maintaining semantic indexes in the current schema is maintained in the RDFCTX_INDEX_EXCEPTIONS view, which has the columns shown in Table: RDFCTX_INDEX_EXCEPTIONS View Columns and one row for each exception.
Table: RDFCTX_INDEX_EXCEPTIONS View Columns
| Column Name | Data Type | Description |
|---|---|---|
| INDEX_OWNER | VARCHAR2(32) | Owner of the semantic index associated with the exception |
| INDEX_NAME | VARCHAR2(32) | Name of the semantic index associated with the exception |
| POLICY_NAME | VARCHAR2(32) | Name of the extractor policy associated with the exception |
| DOC_IDENTIFIER | VARCHAR2(38) | Row identifier (rowid) of the document associated with the exception |
| EXCEPTION_TYPE | VARCHAR2(13) | Type of exception |
| EXCEPTION_CODE | NUMBER | Error code associated with the exception |
| EXCEPTION_TEXT | CLOB | Text associated with the exception |
| EXTRACTED_AT | TIMESTAMP | Time at which the exception occurred |