Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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.  ​ 
- 
- 
  
  
 
Back to top
admin/features/snapshots/creation.1333143186.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)