This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
integration:rdbms:oracle:example [2011/03/31 22:46] doc |
integration:rdbms:oracle:example [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 11: | Line 11: | ||
| [[integration:rdbms:oracle:databases|Databases]] | | [[integration:rdbms:oracle:databases|Databases]] | | ||
| [[integration:rdbms:oracle:tables|Tables]] | | [[integration:rdbms:oracle:tables|Tables]] | | ||
| - | [[integration:rdbms:oracle:indexes|Indexes]] | | + | [[integration:rdbms:oracle:constraints|Constraints]] | |
| + | [[integration:rdbms:oracle:datatypes|Datatypes]] | | ||
| [[integration:rdbms:oracle:queries|Queries]] | | [[integration:rdbms:oracle:queries|Queries]] | | ||
| [[integration:rdbms:oracle:updates|Updates]] | | [[integration:rdbms:oracle:updates|Updates]] | | ||
| Line 20: | Line 21: | ||
| ==== Example ==== | ==== Example ==== | ||
| - | The following example is a simple database using an Oracle database. The Omnidex Environment File is displayed below; however, the entire example (not including the relational database itself) can be downloaded as a ZIP file at the following link: **{{:integration:rdbms:oracle:oracle_example.zip|Download ZIP File}}**. | + | The following example is a simple database using an Oracle database. The Omnidex Environment File is displayed below; however, the entire example can be downloaded as a ZIP file at the following link: **{{:integration:rdbms:oracle:oracle_example.zip|Download ZIP File}}**. This ZIP file also includes files that can be used to create the Oracle database. |
| The following statements will create and build an Omnidex Environment against an Oracle database: | The following statements will create and build an Omnidex Environment against an Oracle database: | ||
| Line 30: | Line 31: | ||
| >> with delete; | >> with delete; | ||
| Environment created in simple.xml | Environment created in simple.xml | ||
| - | -> ; | ||
| -> ; | -> ; | ||
| -> create database "SIMPLE" | -> create database "SIMPLE" | ||
| >> type oracle | >> type oracle | ||
| >> version "11" | >> version "11" | ||
| - | >> user "myuser" | + | >> user "simple" |
| - | >> password "mypassword" | + | >> password "simple" |
| >> index_directory "idx" | >> index_directory "idx" | ||
| >> in "simple.xml"; | >> in "simple.xml"; | ||
| Database SIMPLE created in simple.xml | Database SIMPLE created in simple.xml | ||
| - | -> ; | ||
| -> ; | -> ; | ||
| -> create table "COUNTRIES" | -> create table "COUNTRIES" | ||
| - | >> physical "MYUSER.COUNTRIES" | + | >> physical "SIMPLE.COUNTRIES" |
| >> ( | >> ( | ||
| >> "COUNTRY" CHARACTER(2) omnidex, | >> "COUNTRY" CHARACTER(2) omnidex, | ||
| Line 57: | Line 56: | ||
| >> in "simple.xml"; | >> in "simple.xml"; | ||
| Table COUNTRIES created in simple.xml | Table COUNTRIES created in simple.xml | ||
| - | -> ; | ||
| -> ; | -> ; | ||
| -> create table "STATES" | -> create table "STATES" | ||
| - | >> physical "MYUSER.STATES" | + | >> physical "SIMPLE.STATES" |
| >> ( | >> ( | ||
| >> "STATE" CHARACTER(2) omnidex, | >> "STATE" CHARACTER(2) omnidex, | ||
| Line 74: | Line 72: | ||
| >> in "simple.xml"; | >> in "simple.xml"; | ||
| Table STATES created in simple.xml | Table STATES created in simple.xml | ||
| - | -> ; | ||
| -> ; | -> ; | ||
| -> create table "GENDERS" | -> create table "GENDERS" | ||
| - | >> physical "MYUSER.GENDERS" | + | >> physical "SIMPLE.GENDERS" |
| >> ( | >> ( | ||
| >> "GENDER" CHARACTER(1) omnidex, | >> "GENDER" CHARACTER(1) omnidex, | ||
| Line 86: | Line 83: | ||
| >> in "simple.xml"; | >> in "simple.xml"; | ||
| Table GENDERS created in simple.xml | Table GENDERS created in simple.xml | ||
| - | -> ; | ||
| -> ; | -> ; | ||
| -> create table "HOUSEHOLDS" | -> create table "HOUSEHOLDS" | ||
| - | >> physical "MYUSER.HOUSEHOLDS" | + | >> physical "SIMPLE.HOUSEHOLDS" |
| >> ( | >> ( | ||
| >> "HOUSEHOLD" CHARACTER(12) omnidex, | >> "HOUSEHOLD" CHARACTER(12) omnidex, | ||
| Line 104: | Line 100: | ||
| >> in "simple.xml"; | >> in "simple.xml"; | ||
| Table HOUSEHOLDS created in simple.xml | Table HOUSEHOLDS created in simple.xml | ||
| - | -> ; | ||
| -> ; | -> ; | ||
| -> create table "INDIVIDUALS" | -> create table "INDIVIDUALS" | ||
| - | >> physical "MYUSER.INDIVIDUALS" | + | >> physical "SIMPLE.INDIVIDUALS" |
| >> ( | >> ( | ||
| >> "INDIVIDUAL" CHARACTER(12) omnidex, | >> "INDIVIDUAL" CHARACTER(12) omnidex, | ||
| Line 113: | Line 108: | ||
| >> "NAME" CHARACTER(50) quicktext, | >> "NAME" CHARACTER(50) quicktext, | ||
| >> "GENDER" CHARACTER(1) omnidex bitmap, | >> "GENDER" CHARACTER(1) omnidex bitmap, | ||
| - | >> "BIRTHDATE" ANSI DATE omnidex, | + | >> "BIRTHDATE" ORACLE DATETIME omnidex, |
| >> "PHONE" CHARACTER(14) omnidex, | >> "PHONE" CHARACTER(14) omnidex, | ||
| >> "EMAIL" CHARACTER(60) quicktext, | >> "EMAIL" CHARACTER(60) quicktext, | ||
| Line 129: | Line 124: | ||
| -> ; Update the Omnidex indexes | -> ; Update the Omnidex indexes | ||
| -> update indexes; | -> update indexes; | ||
| - | Updated indexes for COUNTRIES (239 rows, 0.031 cpu, 0.390 elapsed) | + | Updated indexes for COUNTRIES (239 rows, 0.016 cpu, 0.500 elapsed) |
| - | Updated indexes for STATES (76 rows, 0.016 cpu, 0.031 elapsed) | + | Updated indexes for STATES (76 rows, 0.016 cpu, 0.047 elapsed) |
| - | Updated indexes for GENDERS (2 rows, 0.000 cpu, 0.031 elapsed) | + | Updated indexes for GENDERS (2 rows, 0.016 cpu, 0.031 elapsed) |
| - | Updated indexes for HOUSEHOLDS (1,909 rows, 0.016 cpu, 0.094 elapsed) | + | Updated indexes for HOUSEHOLDS (1,909 rows, 0.031 cpu, 0.110 elapsed) |
| - | Updated indexes for INDIVIDUALS (5,000 rows, 0.031 cpu, 0.390 elapsed) | + | Updated indexes for INDIVIDUALS (5,000 rows, 0.031 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.063 cpu, 0.063 elapsed) | + | Updated statistics for COUNTRIES (239 rows, 0.156 cpu, 0.203 elapsed) |
| - | Updated statistics for STATES (76 rows, 0.047 cpu, 0.047 elapsed) | + | Updated statistics for STATES (76 rows, 0.016 cpu, 0.015 elapsed) |
| - | Updated statistics for GENDERS (2 rows, 0.031 cpu, 0.031 elapsed) | + | Updated statistics for GENDERS (2 rows, 0.016 cpu, 0.015 elapsed) |
| - | Updated statistics for HOUSEHOLDS (1,909 rows, 0.094 cpu, 0.094 elapsed) | + | Updated statistics for HOUSEHOLDS (1,909 rows, 0.047 cpu, 0.047 elapsed) |
| - | Updated statistics for INDIVIDUALS (5,000 rows, 0.125 cpu, 0.125 elapsed) | + | Updated statistics for INDIVIDUALS (5,000 rows, 0.078 cpu, 0.078 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.015 elapsed) | + | Updated text for COUNTRIES (0.000 cpu, 0.015 elapsed) |
| Updated text for STATES (0.000 cpu, 0.000 elapsed) | Updated text for STATES (0.000 cpu, 0.000 elapsed) | ||
| Updated text for GENDERS (0.000 cpu, 0.000 elapsed) | Updated text for GENDERS (0.000 cpu, 0.000 elapsed) | ||
| - | Updated text for HOUSEHOLDS (0.063 cpu, 0.062 elapsed) | + | Updated text for HOUSEHOLDS (0.063 cpu, 0.078 elapsed) |
| - | Updated text for INDIVIDUALS (0.063 cpu, 0.078 elapsed) | + | Updated text for INDIVIDUALS (0.063 cpu, 0.062 elapsed) |
| Text metadata updated for environment USER_ENVIRONMENT | Text metadata updated for environment USER_ENVIRONMENT | ||
| -> ; | -> ; | ||