This shows you the differences between two versions of the page.
| Next revision | Previous revision Next revision Both sides next revision | ||
|
integration:rdbms:mysql:home [2011/04/05 02:49] 127.0.0.1 external edit |
integration:rdbms:mysql:home [2011/04/06 23:11] 127.0.0.1 external edit |
||
|---|---|---|---|
| Line 21: | Line 21: | ||
| ==== Overview ==== | ==== Overview ==== | ||
| - | Omnidex can be deployed directly against an 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. | + | 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. |
| - | An Omnidex Environment File controls how Omnidex connects to the MySQL database and identifies the tables and columns that Omnidex will have access to. Omnidex accesses the MySQL data directly using standard SQL statements issued through the MySQL Call Interface (OCI). During indexing and query processing, Omnidex maintains a connection to the MySQL 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. | + | An Omnidex Environment File controls how Omnidex connects to the MySQL database and identifies the tables and columns that Omnidex will have access to. Omnidex accesses the MySQL data directly using standard SQL statements issued through the MySQL ODBC Connector. During indexing and query processing, Omnidex maintains a connection to the MySQL 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:mysql:basic_architecture_mysql.png|}} | {{:integration:rdbms:mysql:basic_architecture_mysql.png|}} | ||