This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
integration:rdbms:oracle:home [2011/03/31 19:58] doc |
integration:rdbms:oracle:home [2011/04/04 02:49] doc |
||
---|---|---|---|
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:datatypes|Datatypes]] | | ||
[[integration:rdbms:oracle:indexes|Indexes]] | | [[integration:rdbms:oracle:indexes|Indexes]] | | ||
[[integration:rdbms:oracle:queries|Queries]] | | [[integration:rdbms:oracle:queries|Queries]] | | ||
[[integration:rdbms:oracle:updates|Updates]] | | [[integration:rdbms:oracle:updates|Updates]] | | ||
- | [[integration:rdbms:oracle:storedproc|Stored Procedures]] | | ||
[[integration:rdbms:oracle:example|Example]] | [[integration:rdbms:oracle:example|Example]] | ||
Line 23: | Line 23: | ||
Omnidex can be deployed directly against an Oracle database. An Omnidex Environment File is created that describes how to connect to the Oracle database and identifies the tables and columns that Omnidex will have access to. Using this Omnidex Environment File, administrators can then create Omnidex indexes on the Oracle data, providing a high-performance query environment for applications. | Omnidex can be deployed directly against an Oracle database. An Omnidex Environment File is created that describes how to connect to the Oracle database and identifies the tables and columns that Omnidex will have access to. Using this Omnidex Environment File, administrators can then create Omnidex indexes on the Oracle data, providing a high-performance query environment for applications. | ||
- | Omnidex accesses the Oracle data directly using standard SQL statements issued through the Oracle Call Interface (OCI). During indexing and query processing, Omnidex maintains a connection to the Oracle database and accesses the data as needed. Typically, queries are first routed to the Omnidex indexes where specific rowids or primary keys are identified that meet the criteria. Omnidex then fetches the appropriate rows using these values using standard SQL statements. | + | Omnidex accesses the Oracle data directly using standard SQL statements issued through the Oracle Call Interface (OCI). During indexing and query processing, Omnidex maintains a connection to the Oracle database and accesses the data as needed. Typically, queries are first routed to the Omnidex indexes where specific rowids or primary keys are identified that meet the criteria. Omnidex then fetches the appropriate rows using these values with standard SQL statements. |
{{:integration:rdbms:oracle:basic_architecture_oracle.png|}} | {{:integration:rdbms:oracle:basic_architecture_oracle.png|}} |