About Oracle Text Datastores
Previous
Next
About Oracle Text Datastores |
Previous |
Next |
In Oracle Text, the datastore specifies where and how indexed documents are stored so that they can be retrieved. Indexed documents are stored in the system according to your datastore preference, which can be file, URL, direct, and multi-column datastores.
You use the datastore types to specify how your text is stored. To create a datastore preference, you must use one of the datastore types described in the following table.
| Datastore Type | Use When |
|---|---|
DIRECT_DATASTORE |
Data is stored internally in the text column. Each row is indexed as a single document. |
MULTI_COLUMN_DATASTORE |
Data is stored in a text table in more than one column. Columns are concatenated to create a virtual document, one for each row. |
DETAIL_DATASTORE |
Data is stored internally in the text column. Document consists of one or more rows stored in a text column in a detail table, with header information stored in a master table. |
FILE_DATASTORE |
Data is stored externally in operating system files. Filenames are stored in the text column, one for each row. |
NESTED_DATASTORE |
Data is stored in a nested table. |
URL_DATASTORE |
Data is stored externally in files located on an intranet or the Internet. Uniform Resource Locators (URLs) are stored in the text column. |
USER_DATASTORE |
Documents are synthesized at index time by a user-defined stored procedure. |