This shows you the differences between two versions of the page.
|
integration:rawdata:ost:environments [2015/07/14 17:33] doc |
integration:rawdata:ost:environments [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ~~NOTOC~~ | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | |||
| - | ====== Integration: Raw Data Files ====== | ||
| - | |||
| - | ===== Omnidex Standalone Tables ===== | ||
| - | |||
| - | [[integration:rawdata:ost:home|Overview]] | | ||
| - | **[[integration:rawdata:ost:environments|Environments]]** | | ||
| - | [[integration:rawdata:ost:options|Options]] | | ||
| - | [[integration:rawdata:ost:datatypes|Datatypes]] | | ||
| - | [[integration:rawdata:ost:ofx|Offset Indexes]] | | ||
| - | [[integration:rawdata:ost:export|Exporting]] | | ||
| - | [[integration:rawdata:ost:limitations|Limitations]] | | ||
| - | [[integration:rawdata:ost:example|Example]] | ||
| - | |||
| - | |||
| - | ---- | ||
| - | |||
| - | ==== Environments ==== | ||
| - | |||
| - | The Omnidex Environment File is the key to setting up Omnidex on raw data files. Omnidex Standalone Tables have metadata about the table itself, but not the table relationships or the Omnidex indexing. The Omnidex Environment File fulfills this role. | ||
| - | |||
| - | === Declaring Databases for Raw Data Files === | ||
| - | |||
| - | Databases in Omnidex are of a particular type, such as Oracle, SQL Server, MySQL, or ODBC. A database that accesses a raw data file has its own type: FILE. All tables within this database must be raw data files, though they can be a mixture of the types of raw data files supported by Omnidex. | ||
| - | |||
| - | <code> | ||
| - | create database "SIMPLE" | ||
| - | type FILE | ||
| - | index_directory "idx" | ||
| - | in "simple.xml"; | ||
| - | </code> | ||
| - | |||
| - | |||
| - | === Declaring Tables for Omnidex Standalone Tables === | ||
| - | |||
| - | Tables will point to a single Omnidex Standalone Table, and the file must match the record layout specified in the [[dev:sql:statements:create_table:home|CREATE TABLE]] statement. In the [[dev:sql:statements:create_table:home|CREATE TABLE]] statement, the OST option in the [[integration:rawdata:ost:options|OPTIONS clause]] is used to identify this as an Omnidex Standalone Table. | ||
| - | |||
| - | In the CREATE TABLE statement, the PHYSICAL clause is used to point to the physical location of the raw data file. This PHYSICAL clause can contain a relative path name (relative to the location of the Omnidex Environment File) such as "dat/states.ost", or an absolute path name such as "d:/class/lab1/dat/states.ost". Unlike fixed-length and delimited files, only one Omnidex Standalone Table can be referenced in the PHYSICAL clause, and wildcards are not allowed. The PHYSICAL clause can reference [[appendix:reference:envvar:home|environment variables]] using a special syntax. | ||
| - | |||
| - | <code> | ||
| - | create table "STATES" | ||
| - | options "OST" | ||
| - | physical "dat/states.ost" | ||
| - | ... | ||
| - | </code> | ||
| - | |||
| - | |||
| - | ===== ===== | ||
| - | |||
| - | **[[integration:rawdata:ost:home|Prev]]** | | ||
| - | **[[integration:rawdata:ost:options|Next]]** | ||
| - | |||
| - | ====== Additional Resources ====== | ||
| - | |||
| - | See also: | ||
| - | |||
| - | {{page>:integration:rawdata:see_also&nofooter&noeditbtn}} | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||