This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:features:snapshots:creation [2012/03/30 21:33] doc |
admin:features:snapshots:creation [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 8: | Line 8: | ||
[[admin:features:snapshots:home|Overview]] | | [[admin:features:snapshots:home|Overview]] | | ||
+ | [[admin:features:snapshots:benefits|Benefits]] | | ||
**[[admin:features:snapshots:creation|Creation]]** | [[admin:features:snapshots:portability|Portability]] | [[admin:features:snapshots:scalability|Scalability]] | **[[admin:features:snapshots:creation|Creation]]** | [[admin:features:snapshots:portability|Portability]] | [[admin:features:snapshots:scalability|Scalability]] | ||
Line 23: | Line 24: | ||
<code> | <code> | ||
- | export (select * from INDIVIDUALS) to individuals.dat; | + | export (select * from INDIVIDUALS) to dat/individuals.dat; |
</code> | </code> | ||
Line 87: | Line 88: | ||
INDIVIDUALS.BIRTHDATE <= 'December 31, 1999' | INDIVIDUALS.BIRTHDATE <= 'December 31, 1999' | ||
) | ) | ||
- | to simple_view.dat; | + | to dat/simple_view.dat; |
</code> | </code> | ||
Line 105: | Line 106: | ||
create table "COUNTRIES" | create table "COUNTRIES" | ||
- | physical "dat\cnt.dat" | + | physical "dat/cnt.dat" |
( | ( | ||
"COUNTRY" CHARACTER(2) omnidex, | "COUNTRY" CHARACTER(2) omnidex, | ||
Line 120: | Line 121: | ||
create table "STATES" | create table "STATES" | ||
- | physical "dat\sta.dat" | + | physical "dat/sta.dat" |
( | ( | ||
"STATE" CHARACTER(2) omnidex, | "STATE" CHARACTER(2) omnidex, | ||
Line 135: | Line 136: | ||
create table "GENDERS" | create table "GENDERS" | ||
- | physical "dat\gdr.dat" | + | physical "dat/gdr.dat" |
( | ( | ||
"GENDER" CHARACTER(1) omnidex, | "GENDER" CHARACTER(1) omnidex, | ||
Line 145: | Line 146: | ||
create table "HOUSEHOLDS" | create table "HOUSEHOLDS" | ||
- | physical "dat\households.dat" | + | physical "dat/households.dat" |
( | ( | ||
"HOUSEHOLD" CHARACTER(12) omnidex, | "HOUSEHOLD" CHARACTER(12) omnidex, | ||
Line 161: | Line 162: | ||
create table "INDIVIDUALS" | create table "INDIVIDUALS" | ||
- | physical "dat\individuals.dat" | + | physical "dat/individuals.dat" |
( | ( | ||
"INDIVIDUAL" CHARACTER(12) omnidex, | "INDIVIDUAL" CHARACTER(12) omnidex, | ||
Line 178: | Line 179: | ||
create table "SIMPLE_VIEW" | create table "SIMPLE_VIEW" | ||
- | physical "dat\simple_view.dat" | + | physical "dat/simple_view.dat" |
( | ( | ||
"INDIVIDUAL" CHARACTER(12) omnidex, | "INDIVIDUAL" CHARACTER(12) omnidex, | ||
Line 209: | Line 210: | ||
in "simple_view.xml"; | in "simple_view.xml"; | ||
</code> | </code> | ||
+ | |||
+ | This Omnidex Environment is now ready for indexes to be built and for queries to be run. At this point, it is the same as a standard, raw data file environment. Refer to the section on [[integration:rawdata:home|Raw Data Files]] for detailed documentation. | ||
=== Using a Database or ETL Tool === | === Using a Database or ETL Tool === | ||
When creating an Omnidex Snapshot using a database or ETL tool, simply request that the data be extracted into a raw data file or a delimited file. A raw data file is a binary stream of data, with fixed-length records using native datatypes. A delimited file uses delimiters to identify when one column ends and another begins, and similarly when one row ends and the next row begins. Refer to the section on [[integration:rawdata:home|Raw Data Files]] for detailed documentation. | When creating an Omnidex Snapshot using a database or ETL tool, simply request that the data be extracted into a raw data file or a delimited file. A raw data file is a binary stream of data, with fixed-length records using native datatypes. A delimited file uses delimiters to identify when one column ends and another begins, and similarly when one row ends and the next row begins. Refer to the section on [[integration:rawdata:home|Raw Data Files]] for detailed documentation. | ||
- | |||
- | |||
- | |||
- | One of the most common ways to create an Omnidex Snapshot is to expobe done using Omnidex's EXPORT command, or it can be done using any database tool that can generate a raw data file or a delimited file. | ||
- | |||
- | |||