This shows you the differences between two versions of the page.
admin:basics:environments:create [2011/01/13 17:37] els |
admin:basics:environments:create [2016/06/28 22:38] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{page>:top_add&nofooter&noeditbtn}} | ||
- | ====== Administration: Omnidex Basics ====== | ||
- | |||
- | ===== Omnidex Environments ===== | ||
- | |||
- | [[admin:basics:environments:home|Overview]] | | ||
- | [[admin:basics:environments:types|Types]] | | ||
- | **[[admin:basics:environments:create|Creating]]** | | ||
- | [[admin:basics:environments:maintain|Maintaining]] | | ||
- | [[admin:basics:environments:deploy|Deploying]] | ||
- | |||
- | ---- | ||
- | |||
- | ==== Creating Environments ==== | ||
- | |||
- | There are two methods to create Omnidex Environments. They can be created interactively using the [[programs:odxadmin:home|Omnidex Administrator]], or they can be created using SQL statements such as [[dev:sql:statements:create_environment:home|CREATE ENVIRONMENT]], [[dev:sql:statements:create_database:home|CREATE DATABASE]], [[dev:sql:statements:create_table:home|CREATE TABLE]] and [[dev:sql:statements:create_index:home|CREATE INDEX]]. Once created, a simple Omnidex Environment File will look like this: | ||
- | |||
- | <code> | ||
- | 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"; | ||
- | |||
- | </code> | ||
- | |||
- | ==== Adding Omnidex Indexing ==== | ||
- | |||
- | 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 [[programs:odxsql:home|OdxSQL]] program is used to process the statements; however, these statements can also be sent through ODBC or JDBC applications. | ||
- | |||
- | <code> | ||
- | > 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</code> | ||
- | |||
- | |||
- | ===== ===== | ||
- | |||
- | **[[admin:basics:environments:home|Prev]]** | | ||
- | **[[admin:basics:environments:create|Next]]** | ||
- | |||
- | ====== Additional Resources ====== | ||
- | |||
- | See also: | ||
- | |||
- | {{page>:admin:basics:see_also&nofooter&noeditbtn}} | ||
- | |||
- | {{page>:bottom_add&nofooter&noeditbtn}} |