This shows you the differences between two versions of the page.
|
integration:rdbms:queries [2011/03/14 20:11] els |
integration:rdbms:queries [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ~~NOTOC~~ | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | |||
| - | ====== Integration: Relational Databases ====== | ||
| - | |||
| - | [[integration:rdbms:home|Overview]] | | ||
| - | [[integration:rdbms:servers|Servers]] | | ||
| - | [[integration:rdbms:environments|Environments]] | | ||
| - | **[[integration:rdbms:queries|Queries]]** | | ||
| - | [[integration:rdbms:updates|Updates]] | | ||
| - | [[integration:rdbms:creation|Generating Data Files]] | | ||
| - | [[integration:rdbms:implementation|Implementation Guides]] | ||
| - | |||
| - | ---- | ||
| - | ==== Querying Relational Databases ==== | ||
| - | |||
| - | Omnidex allows the relational database tables and the Omnidex indexes to be queried using standard SQL statements using an ODBC or JDBC interface. The query optimizer within Omnidex will evaluate the SQL statement and choose the best approach for processing. Many queries will be processed using the Omnidex indexes with no need to access the underlying relational database. Other queries will be processed using a combination of Omnidex indexes and access to the underlying relational database. Queries may even be processed exclusively in the relational database if Omnidex indexes would not improve performance. | ||
| - | |||
| - | Queries can be submitted using Omnidex SQL. Omnidex SQL consists of ANSI SQL, supplemented with [[dev:sql:functions:home|Omnidex functions]]. Omnidex also supports some of the proprietary functions found in the relational database. Access to these relational database extensions can be controlled using the [[dev:sql:statements:set_sql_syntax|SET SQL_SYNTAX]] statement. Applications that have been using a particular SQL dialect from a relational database will need to adjust their syntax to Omnidex SQL. | ||
| - | |||
| - | |||
| - | ===== ===== | ||
| - | |||
| - | **[[integration:rdbms:environments|Prev]]** | | ||
| - | **[[integration:rdbms:updates|Next]]** | ||
| - | |||
| - | ====== Additional Resources ====== | ||
| - | |||
| - | See also: | ||
| - | |||
| - | {{page>:integration:rdbms:see_also&nofooter&noeditbtn}} | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||