https://www.omnidex.com/docs/v51/ 2026-04-23T09:21:15+0000 https://www.omnidex.com/docs/v51/ https://www.omnidex.com/docs/v51/lib/tpl/simple/images/favicon.ico text/html 2012-10-26T14:57:25+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:oracle:constraints&rev=1351263445&do=diff Integration: Relational Databases Oracle Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Oracle Constraints and Indexes Oracle table constraints and indexes should be declared in the Omnidex Environment File. Omnidex uses primary and foreign key table constraints to understand the nature of the data and to optimize table joins. Declaring primary keys for a table also allows Omnidex to fulfill more queries solely in the index… text/html 2012-10-26T14:57:25+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:oracle:databases&rev=1351263445&do=diff Integration: Relational Databases Oracle Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Databases The CREATE DATABASE statement is used to declare an Oracle database within an Omnidex Environment File. This statement can either be issued directly, or it can be extracted from Oracle using the EXTRACT statement as discussed in the previous section. text/html 2012-10-26T14:57:26+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:oracle:datatypes&rev=1351263446&do=diff Integration: Relational Databases Oracle Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Datatypes Omnidex supports most Oracle datatypes; however, care must be taken when mapping the Oracle datatypes to Omnidex. Most Oracle binary data is stored in the internal NUMBER datatype. This datatype cannot be returned to applications, and so applications must choose an appropriate external datatype for presentation. Omnidex allo… text/html 2012-10-26T14:57:26+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:oracle:environments&rev=1351263446&do=diff Integration: Relational Databases Oracle Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Environments The Omnidex Environment File contains metadata that describes the Oracle database and the Omnidex configuration. This includes the following connection and schema information: text/html 2012-10-26T14:57:26+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:oracle:example&rev=1351263446&do=diff Integration: Relational Databases Oracle Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Example 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: text/html 2012-10-26T14:57:26+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:oracle:home&rev=1351263446&do=diff Integration: Relational Databases Oracle Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Overview Omnidex can be deployed directly against an Oracle database. Omnidex retrieves and indexes the Oracle data, and queries read directly from the Oracle database as needed. This approach allows Omnidex to work alongside Oracle, providing a high-performance query environment for applications. text/html 2012-10-26T14:57:26+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:oracle:queries&rev=1351263446&do=diff Integration: Relational Databases Oracle Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Queries The Omnidex SQL Engine will optimize queries to take advantage of the Omnidex indexes. Many queries can be fulfilled entirely within the Omnidex indexes. This is especially true for queries that request counts or aggregations from one or more tables. Even queries that return columns of data can be completed using the Omnidex i… text/html 2012-10-26T14:57:26+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:oracle:tables&rev=1351263446&do=diff Integration: Relational Databases Oracle Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Tables The CREATE TABLE Statement The CREATE TABLE statement is used to declare an Oracle table or view within an Omnidex Environment File. The Omnidex Environment File will contain a declaration for each Oracle table or view to be accessed, and will correlate all of the schema information between Omnidex and Oracle, including object nam… text/html 2012-10-26T14:57:26+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:oracle:updates&rev=1351263446&do=diff Integration: Relational Databases Oracle Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Updates Omnidex is primarily used on read-only databases; however, Omnidex can also be used on read-write databases. Omnidex supports the INSERT, DELETE and UPDATE SQL statements, and also supports using database triggers to automatically update the Oracle database. There are several restrictions that administrators must be aware of befo…