This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
oaenv:overview [2009/11/30 19:04] tdo |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| - | ====== OMNIDEX Environment Catalog Syntax ====== | ||
| - | ===== ENVIRONMENT ===== | ||
| - | ===== ENVIRONMENT ===== | ||
| - | |||
| - | ENVIRONMENT | ||
| - | ===== DATABASE ===== | ||
| - | |||
| - | DATABASE | ||
| - | ===== TABLE ===== | ||
| - | |||
| - | TABLE < tablename | "tablename" > | ||
| - | ===== TABLE COLUMN ===== | ||
| - | |||
| - | COLUMN column-name DATATYPE datatype-spec | ||
| - | [PROXIMITY “options”] | ||
| - | [SYNONYMS 'options'] | ||
| - | [SPELLCHECK 'options'] | ||
| - | [MISSPELLINGS 'options'] | ||
| - | [FORMS 'options'] | ||
| - | [STOPWORDS 'options'] | ||
| - | [PHONETIC 'options'] | ||
| - | [INCLUDED_TAGS 'options'] | ||
| - | [EXCLUDED_TAGS 'options'] | ||
| - | {AS < columnspec | "$retrieve_file(FILENAME)" > ] | ||
| - | |||
| - | ===== NODE ===== | ||
| - | NODE nodename | ||
| - | DATABASE dbname FILEDSN "dsn" | ||
| - | [ LOCAL ] | ||
| - | [ CACHE ] | ||
| - | CLUSTER table | ||
| - | [PARTITION BY criteria_expression | ||
| - | | ||
| - | <code> | ||
| - | node GRID01 | ||
| - | database LIST filedsn "list01.dsn" local cache | ||
| - | cluster | ||
| - | table LIST partition by "STATE in ('MA','ME','NH','NY','PR','RI','VT') and | ||
| - | ZIP between '00000' and '05999'" | ||
| - | |||
| - | node GRID02 | ||
| - | database LIST filedsn "list02.dsn" local cache | ||
| - | cluster | ||
| - | table LIST partition by "STATE in ('CT','NJ','NY') and | ||
| - | ZIP between '06000' and '10999'" | ||
| - | |||
| - | node GRID03 | ||
| - | database LIST filedsn "list03.dsn" local cache | ||
| - | cluster | ||
| - | table LIST partition by "STATE in ('NY') and | ||
| - | ZIP between '11000' and '14999'" | ||
| - | </code> | ||
| - | |||
| - | column "SUBTOTAL" datatype FLOAT length 8 as "AMOUNT * QUANTITY" | ||
| - | |||
| - | column "GRANDTOTAL" datatype FLOAT length 8 as "SUBTOTAL * TAX_RATE" | ||
| - | |||
| - | column "COMPANY_SDX" datatype C STRING length 40 as "$soundex(COMPANY)" | ||
| - | |||
| - | column "COUNTYSTATE" datatype CHARACTER length 5 as "COUNTY_CODE || STATE" | ||
| - | |||
| - | <code> | ||
| - | where the “options” are: | ||
| - | |||
| - | SPACE=proximity_spec | ||
| - | NEAR=proximity_spec | ||
| - | BEFORE=proximity_spec | ||
| - | PHRASE=proximity_spec | ||
| - | |||
| - | and where “proximity_spec” is: | ||
| - | |||
| - | NEAR(n) – means insure that word1 is within n words before or after word2. | ||
| - | BEFORE(n) – means insure that word1 is within n words before word2 | ||
| - | PHRASE - means insure that word1 immediately before word 2, and treat as a phrase rather than separate words. | ||
| - | |||
| - | The default behavior is as follows: | ||
| - | |||
| - | SPACE=NEAR(999) | ||
| - | NEAR=NEAR(10) | ||
| - | BEFORE=BEFORE(10) | ||
| - | PHRASE=PHRASE | ||
| - | </code> | ||
| - | One other change to the options in the clause is the removal of AUTOENABLE and NOAUTOENABLE. The AUTOENABLE option makes sense for things like SYNONYMS, but it doesn’t make sense for PROXIMITY since proximity is always in effect. | ||
| - | |||
| - | ==== EXAMPLES ==== | ||
| - | column "SUBTOTAL" datatype FLOAT length 8 as "AMOUNT * QUANTITY" | ||
| - | |||
| - | column "GRANDTOTAL" datatype FLOAT length 8 as "SUBTOTAL * TAX_RATE" | ||
| - | |||
| - | column "COMPANY_SDX" datatype C STRING length 40 as "$soundex(COMPANY)" | ||
| - | |||
| - | column "COUNTYSTATE" datatype CHARACTER length 5 as "COUNTY_CODE || STATE" | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||