https://www.omnidex.com/docs/v54/ 2026-04-29T20:26:09+0000 https://www.omnidex.com/docs/v54/ https://www.omnidex.com/docs/v54/lib/tpl/simple/images/favicon.ico text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:mysql:constraints&rev=1467153531&do=diff Integration: Relational Databases MySQL Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- MySQL Constraints and Indexes MySQL 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 indexes wi… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:mysql:databases&rev=1467153531&do=diff Integration: Relational Databases MySQL Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Databases The CREATE DATABASE statement is used to declare a MySQL database within an Omnidex Environment File. This statement can either be issued directly, or it can be extracted from MySQL using the EXTRACT statement as discussed in the previous section. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:mysql:datatypes&rev=1467153531&do=diff Integration: Relational Databases MySQL Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Datatypes Omnidex supports most MySQL datatypes; however, care must be taken when mapping the MySQL datatypes to Omnidex. Omnidex accesses MySQL using the MySQL ODBC Connector, and so the datatype correlations will follow the ODBC standard. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:mysql:environments&rev=1467153531&do=diff Integration: Relational Databases MySQL Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Environments The Omnidex Environment File contains metadata that describes the MySQL database and the Omnidex configuration. This includes the following connection and schema information: text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:mysql:example&rev=1467153531&do=diff Integration: Relational Databases MySQL Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Example The following example is a simple database using a MySQL 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 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:mysql:home&rev=1467153531&do=diff Integration: Relational Databases MySQL Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Overview Omnidex can be deployed directly against a MySQL database. Omnidex retrieves and indexes the MySQL data, and queries read directly from the MySQL database as needed. This approach allows Omnidex to work alongside MySQL, providing a high-performance query environment for applications. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:mysql:queries&rev=1467153531&do=diff Integration: Relational Databases MySQL 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 in… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:mysql:tables&rev=1467153531&do=diff Integration: Relational Databases MySQL Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Tables The CREATE TABLE Statement The CREATE TABLE statement is used to declare a MySQL table or view within an Omnidex Environment File. The Omnidex Environment File will contain a declaration for each MySQL table or view to be accessed, and will correlate all of the schema information between Omnidex and MySQL, including object names an… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:mysql:updates&rev=1467153531&do=diff Integration: Relational Databases MySQL 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. There are several restrictions that administrators must be aware of before deciding whether to use Omnidex on a read-write database: