This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
integration:rdbms:sqlserver:example [2011/04/07 17:54] 127.0.0.1 external edit |
integration:rdbms:sqlserver:example [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 32: | Line 32: | ||
| Environment created in simple.xml | Environment created in simple.xml | ||
| -> ; | -> ; | ||
| - | -> create database "SIMPLE" | + | -> create database "simple" |
| - | >> type odbc | + | >> type sqlserver |
| - | >> subtype mysql | + | >> version "9" |
| >> filedsn "dat/simple.dsn" | >> filedsn "dat/simple.dsn" | ||
| >> user "simple" | >> user "simple" | ||
| Line 43: | Line 43: | ||
| -> ; | -> ; | ||
| -> create table "COUNTRIES" | -> create table "COUNTRIES" | ||
| - | >> physical "SIMPLE.COUNTRIES" | + | >> physical "COUNTRIES" |
| >> ( | >> ( | ||
| >> "COUNTRY" CHARACTER(2) omnidex, | >> "COUNTRY" CHARACTER(2) omnidex, | ||
| Line 59: | Line 59: | ||
| -> ; | -> ; | ||
| -> create table "STATES" | -> create table "STATES" | ||
| - | >> physical "SIMPLE.STATES" | + | >> physical "STATES" |
| >> ( | >> ( | ||
| >> "STATE" CHARACTER(2) omnidex, | >> "STATE" CHARACTER(2) omnidex, | ||
| Line 75: | Line 75: | ||
| -> ; | -> ; | ||
| -> create table "GENDERS" | -> create table "GENDERS" | ||
| - | >> physical "SIMPLE.GENDERS" | + | >> physical "GENDERS" |
| >> ( | >> ( | ||
| >> "GENDER" CHARACTER(1) omnidex, | >> "GENDER" CHARACTER(1) omnidex, | ||
| Line 86: | Line 86: | ||
| -> ; | -> ; | ||
| -> create table "HOUSEHOLDS" | -> create table "HOUSEHOLDS" | ||
| - | >> physical "SIMPLE.HOUSEHOLDS" | + | >> physical "HOUSEHOLDS" |
| >> ( | >> ( | ||
| >> "HOUSEHOLD" CHARACTER(12) omnidex, | >> "HOUSEHOLD" CHARACTER(12) omnidex, | ||
| Line 96: | Line 96: | ||
| >> constraint HOUSEHOLDS_HOUSEHOLD_PK primary ("HOUSEHOLD"), | >> constraint HOUSEHOLDS_HOUSEHOLD_PK primary ("HOUSEHOLD"), | ||
| >> constraint HOUSEHOLDS_STATE_FK foreign ("STATE") references "STATES", | >> constraint HOUSEHOLDS_STATE_FK foreign ("STATE") references "STATES", | ||
| - | >> constraint HOUSEHOLDS_COUNTRY_FK foreign ("COUNTRY") references "COUNTRIES" | + | >> constraint HOUSEHOLDS_COUNTRY_FK foreign ("COUNTRY") references "COUNTRIES", |
| - | , | + | |
| >> native HOUSEHOLDS_HOUSEHOLD_IDX ("HOUSEHOLD") | >> native HOUSEHOLDS_HOUSEHOLD_IDX ("HOUSEHOLD") | ||
| >> ) | >> ) | ||
| Line 104: | Line 103: | ||
| -> ; | -> ; | ||
| -> create table "INDIVIDUALS" | -> create table "INDIVIDUALS" | ||
| - | >> physical "SIMPLE.INDIVIDUALS" | + | >> physical "INDIVIDUALS" |
| >> ( | >> ( | ||
| >> "INDIVIDUAL" CHARACTER(12) omnidex, | >> "INDIVIDUAL" CHARACTER(12) omnidex, | ||
| Line 114: | Line 113: | ||
| >> "EMAIL" CHARACTER(60) quicktext, | >> "EMAIL" CHARACTER(60) quicktext, | ||
| >> constraint INDIVIDUALS_INDIVIDUAL_PK primary ("INDIVIDUAL"), | >> constraint INDIVIDUALS_INDIVIDUAL_PK primary ("INDIVIDUAL"), | ||
| - | >> constraint INDIVIDUALS_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSE | + | >> constraint INDIVIDUALS_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSEHOLDS", |
| - | HOLDS", | + | |
| >> constraint INDIVIDUALS_GENDER_FK foreign ("GENDER") references "GENDERS", | >> constraint INDIVIDUALS_GENDER_FK foreign ("GENDER") references "GENDERS", | ||
| >> native INDIVIDUALS_INDIVIDUAL_IDX ("INDIVIDUAL") | >> native INDIVIDUALS_INDIVIDUAL_IDX ("INDIVIDUAL") | ||
| Line 123: | Line 121: | ||
| -> ; | -> ; | ||
| -> connect simple.xml | -> connect simple.xml | ||
| - | Connected to D:\class\lab_mys\simple.xml | + | Connected to D:\class\lab_ssv\simple.xml |
| -> | -> | ||
| -> ; Update the Omnidex indexes | -> ; Update the Omnidex indexes | ||
| -> update indexes; | -> update indexes; | ||
| - | Updated indexes for COUNTRIES (239 rows, 0.016 cpu, 0.235 elapsed) | + | Updated indexes for COUNTRIES (239 rows, 0.016 cpu, 0.516 elapsed) |
| Updated indexes for STATES (76 rows, 0.000 cpu, 0.031 elapsed) | Updated indexes for STATES (76 rows, 0.000 cpu, 0.031 elapsed) | ||
| - | Updated indexes for GENDERS (2 rows, 0.000 cpu, 0.031 elapsed) | + | Updated indexes for GENDERS (2 rows, 0.000 cpu, 0.015 elapsed) |
| - | Updated indexes for HOUSEHOLDS (1,909 rows, 0.016 cpu, 0.094 elapsed) | + | Updated indexes for HOUSEHOLDS (1,909 rows, 0.016 cpu, 0.125 elapsed) |
| - | Updated indexes for INDIVIDUALS (5,000 rows, 0.016 cpu, 0.766 elapsed) | + | Updated indexes for INDIVIDUALS (5,000 rows, 0.016 cpu, 0.578 elapsed) |
| Omnidex indexes updated for environment USER_ENVIRONMENT | Omnidex indexes updated for environment USER_ENVIRONMENT | ||
| -> ; | -> ; | ||
| -> ; Update statistics to improve performance optimization; | -> ; Update statistics to improve performance optimization; | ||
| -> update statistics; | -> update statistics; | ||
| - | Updated statistics for COUNTRIES (239 rows, 0.047 cpu, 0.062 elapsed) | + | Updated statistics for COUNTRIES (239 rows, 0.266 cpu, 0.281 elapsed) |
| - | Updated statistics for STATES (76 rows, 0.016 cpu, 0.031 elapsed) | + | Updated statistics for STATES (76 rows, 0.016 cpu, 0.016 elapsed) |
| - | Updated statistics for GENDERS (2 rows, 0.016 cpu, 0.016 elapsed) | + | Updated statistics for GENDERS (2 rows, 0.000 cpu, 0.015 elapsed) |
| - | Updated statistics for HOUSEHOLDS (1,909 rows, 0.063 cpu, 0.047 elapsed) | + | Updated statistics for HOUSEHOLDS (1,909 rows, 0.063 cpu, 0.063 elapsed) |
| - | Updated statistics for INDIVIDUALS (5,000 rows, 0.109 cpu, 0.110 elapsed) | + | Updated statistics for INDIVIDUALS (5,000 rows, 0.109 cpu, 0.125 elapsed) |
| Statistics updated for environment USER_ENVIRONMENT | Statistics updated for environment USER_ENVIRONMENT | ||
| -> ; | -> ; | ||
| -> ; Update the text database to enable PowerSearch; | -> ; Update the text database to enable PowerSearch; | ||
| -> update text; | -> update text; | ||
| - | Updated text for COUNTRIES (0.016 cpu, 0.031 elapsed) | + | Updated text for COUNTRIES (0.016 cpu, 0.016 elapsed) |
| - | Updated text for STATES (0.000 cpu, 0.000 elapsed) | + | Updated text for STATES (0.016 cpu, 0.015 elapsed) |
| - | Updated text for GENDERS (0.000 cpu, 0.016 elapsed) | + | Updated text for GENDERS (0.000 cpu, 0.000 elapsed) |
| - | Updated text for HOUSEHOLDS (0.016 cpu, 0.015 elapsed) | + | Updated text for HOUSEHOLDS (0.047 cpu, 0.062 elapsed) |
| - | Updated text for INDIVIDUALS (0.016 cpu, 0.016 elapsed) | + | Updated text for INDIVIDUALS (0.078 cpu, 0.079 elapsed) |
| Text metadata updated for environment USER_ENVIRONMENT | Text metadata updated for environment USER_ENVIRONMENT | ||
| -> ; | -> ; | ||
| -> disconnect | -> disconnect | ||
| Disconnected | Disconnected | ||
| - | ></code> | + | </code> |
| ===== ===== | ===== ===== | ||