Overview | Types | Creating | Maintaining | Deploying

There are two methods to create Omnidex Environments. They can be created interactively using the Omnidex Administrator, or they can be created using SQL statements such as CREATE ENVIRONMENT, CREATE DATABASE, CREATE TABLE and CREATE INDEX. Once created, a simple Omnidex Environment File will look like this:

create environment    
 in                   "simple.xml"
 with                 delete;


create database       "SIMPLE"
 type                 FLATFILE
 index_directory      "idx"
 in                   "simple.xml";

create table          "HOUSEHOLDS"
 physical             "dat\households.dat"
 (
  "HOUSEHOLD"         CHARACTER(12),               
  "ADDRESS"           CHARACTER(50),               
  "CITY"              CHARACTER(28),               
  "STATE"             CHARACTER(2),                
  "ZIP"               CHARACTER(5),                
  "COUNTRY"           CHARACTER(2),                
  constraint HSHD_HOUSEHOLD_PK primary ("HOUSEHOLD")
 )
 in                   "simple.xml";


create table          "INDIVIDUALS"
 physical             "dat\individuals.dat"
 (
  "INDIVIDUAL"        CHARACTER(12),               
  "HOUSEHOLD"         CHARACTER(12),               
  "NAME"              CHARACTER(50),                
  "GENDER"            CHARACTER(1),                    
  "BIRTHDATE"         ANSI DATE,                
  "PHONE"             CHARACTER(14),               
  "EMAIL"             CHARACTER(60),                  
  constraint IND_INDIVIDUAL_PK primary ("INDIVIDUAL"),
  constraint IND_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSEHOLDS"
 )
 in                   "simple.xml";

The easiest way to add Omnidex Indexing is to add indexing information beside each column. This will not work in all situations, such as when multi-column indexes are being created. However, the example below shows the basic addition of Omnidex indexing to the same database. In this example, the OdxSQL program is used to process the statements; however, these statements can also be sent through ODBC or JDBC applications.

> create environment
>>  in                   "simple.xml"
>>  with                 delete;
Environment created in simple.xml
>
>
> create database       "SIMPLE"
>>   type                FLATFILE
>>   index_directory     "idx"
>>  in                   "simple.xml";
Database SIMPLE created in simple.xml
>
>
> create table          "HOUSEHOLDS"
>>  physical             "dat\households.dat"
>>  (
>>   "HOUSEHOLD"         CHARACTER(12)     omnidex,
>>   "ADDRESS"           CHARACTER(50)     quicktext,
>>   "CITY"              CHARACTER(28)     quicktext,
>>   "STATE"             CHARACTER(2)      omnidex,
>>   "ZIP"               CHARACTER(5)      omnidex,
>>   "COUNTRY"           CHARACTER(2)      omnidex,
>>   constraint HOUSEHOLDS_HOUSEHOLD_PK primary ("HOUSEHOLD")
>>  )
>>  in                   "simple.xml";
Table HOUSEHOLDS created in simple.xml
>
>
> create table          "INDIVIDUALS"
>>  physical             "dat\individuals.dat"
>>  (
>>   "INDIVIDUAL"        CHARACTER(12)     omnidex,
>>   "HOUSEHOLD"         CHARACTER(12)     omnidex,
>>   "NAME"              CHARACTER(50)     quicktext,
>>   "GENDER"            CHARACTER(1)      omnidex bitmap,
>>   "BIRTHDATE"         ANSI DATE         omnidex,
>>   "PHONE"             CHARACTER(14)     omnidex,
>>   "EMAIL"             CHARACTER(60)     quicktext,
>>   constraint INDIVIDUALS_INDIVIDUAL_PK primary ("INDIVIDUAL"),
>>   constraint INDIVIDUALS_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSEHOLDS"
>>  )
>>  in                   "simple.xml";
Table INDIVIDUALS created in simple.xml

Prev | Next

See also: