This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:indexing:powersearch:sql [2012/01/30 18:59] doc |
admin:indexing:powersearch:sql [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 31: | Line 31: | ||
BILLIE E COOK | BILLIE E COOK | ||
MR. WILL COOK | MR. WILL COOK | ||
- | |||
</code> | </code> | ||
+ | |||
+ | === The USAGE Clause === | ||
The POWERSEARCH option works hand-in-hand with the data stored in the Omnidex Environment File. To use POWERSEARCH, administrators add a context to columns telling Omnidex what they contain. For example, a column named NAME may have a character datatype, but that alone is not enough to tell Omnidex what the column contains. Moreover, Omnidex cannot look to the column name, as there are many different conventions for naming columns. Administrators add a USAGE clause that identifies the contents as given names, as shown in this example: | The POWERSEARCH option works hand-in-hand with the data stored in the Omnidex Environment File. To use POWERSEARCH, administrators add a context to columns telling Omnidex what they contain. For example, a column named NAME may have a character datatype, but that alone is not enough to tell Omnidex what the column contains. Moreover, Omnidex cannot look to the column name, as there are many different conventions for naming columns. Administrators add a USAGE clause that identifies the contents as given names, as shown in this example: | ||
<code> | <code> | ||
- | create table "HOUSEHOLDS" | ||
- | physical "dat\households.dat" | ||
- | ( | ||
- | "HOUSEHOLD" CHARACTER(12) omnidex, | ||
- | "ADDRESS" CHARACTER(50) quicktext usage "STREET_ADDRESS", | ||
- | "CITY" CHARACTER(28) quicktext usage "CITY", | ||
- | "STATE" CHARACTER(2) omnidex usage "STATE", | ||
- | "ZIP" CHARACTER(5) omnidex usage "ZIPCODE", | ||
- | "COUNTRY" CHARACTER(2) omnidex usage "COUNTRY", | ||
- | constraint HOUSEHOLDS_HOUSEHOLD_PK primary ("HOUSEHOLD"), | ||
- | constraint HOUSEHOLDS_STATE_FK foreign ("STATE") references "STATES", | ||
- | constraint HOUSEHOLDS_COUNTRY_FK foreign ("COUNTRY") references "COUNTRIES" | ||
- | ) | ||
- | in "simple.xml"; | ||
- | |||
- | |||
create table "INDIVIDUALS" | create table "INDIVIDUALS" | ||
physical "dat\individuals.dat" | physical "dat\individuals.dat" | ||
Line 58: | Line 43: | ||
"INDIVIDUAL" CHARACTER(12) omnidex, | "INDIVIDUAL" CHARACTER(12) omnidex, | ||
"HOUSEHOLD" CHARACTER(12) omnidex , | "HOUSEHOLD" CHARACTER(12) omnidex , | ||
- | "NAME" CHARACTER(50) quicktext usage "NAME", | + | "NAME" CHARACTER(50) quicktext usage "NAME", |
"GENDER" CHARACTER(1) omnidex bitmap, | "GENDER" CHARACTER(1) omnidex bitmap, | ||
"BIRTHDATE" ANSI DATE omnidex, | "BIRTHDATE" ANSI DATE omnidex, | ||
- | "PHONE" CHARACTER(14) omnidex usage "PHONE", | + | "PHONE" CHARACTER(14) omnidex usage "PHONE", |
- | "EMAIL" CHARACTER(60) quicktext usage "EMAIL", | + | "EMAIL" CHARACTER(60) quicktext usage "EMAIL", |
constraint INDIVIDUALS_INDIVIDUAL_PK primary ("INDIVIDUAL"), | constraint INDIVIDUALS_INDIVIDUAL_PK primary ("INDIVIDUAL"), | ||
constraint INDIVIDUALS_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSEHOLDS", | constraint INDIVIDUALS_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSEHOLDS", | ||
Line 96: | Line 81: | ||
* PHONE | * PHONE | ||
+ | * ... plus, you can add any custom usages needed for your application. | ||