https://www.omnidex.com/docs/v51/ 2026-04-23T09:17:56+0000 https://www.omnidex.com/docs/v51/ https://www.omnidex.com/docs/v51/lib/tpl/simple/images/favicon.ico text/html 2012-10-26T14:51:09+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:creation&rev=1351263069&do=diff Integration: Relational Databases Overview | Servers | Environments | Queries | Updates | Generating Data Files | Implementation Guides ---------- Generating Raw Data Files There are many ways to create raw data files. Omnidex is especially versatile at accessing data files from many different external sources. Omnidex can also be used to create raw data files from another data source using standard SQL statements. text/html 2012-10-26T14:51:09+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:environments&rev=1351263069&do=diff Integration: Relational Databases Overview | Servers | Environments | Queries | Updates | Implementation Guides ---------- Environments and Relational Databases Omnidex provides access to a relational database by creating an Omnidex Environment File that points to the relational database and the tables. Within the Omnidex Environment File, the administrator declares a database with connection information for the underlying relational database, and then declares tables that point to the unde… text/html 2012-10-26T14:51:09+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:home&rev=1351263069&do=diff Integration: Relational Databases Overview | Servers | Environments | Queries | Updates | Implementation Guides ---------- Overview Omnidex is often used to increase performance and improve flexibility on relational databases. Most companies that have invested in a relational database solution will continue to use the relational database as their core data store, but they may want to improve query performance or enhance their searches with text/html 2012-10-26T14:51:09+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:implementation&rev=1351263069&do=diff Integration: Relational Databases Overview | Servers | Environments | Queries | Updates | Implementation Guides ---------- Implementation Guides Each relational database has its own set of implementation details. These implementation guides cover how to declare the schema information in the Omnidex Environment File, how to deal with data-specific issues and datatypes, and how to address the proprietary SQL syntax used by the relational database. text/html 2012-10-26T14:51:09+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:queries&rev=1351263069&do=diff Integration: Relational Databases Overview | Servers | Environments | Queries | Updates | Implementation Guides ---------- Querying Relational Databases Query Optimization 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. Queries will only access the indexes or the database tables if… text/html 2012-10-26T14:51:09+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:see_also&rev=1351263069&do=diff * Integration * Relational Databases * Oracle * SQL Server * ODBC (inc. MySQL) * Raw Data Files * ODBC * Java * Business Intelligence text/html 2012-10-26T14:51:09+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:servers&rev=1351263069&do=diff Integration: Relational Databases Overview | Servers | Environments | Queries | Updates | Implementation Guides ---------- Servers Omnidex benefits from being on a separate server from the relational database whenever possible. Relational databases tend to use strategies that consume most of the resources on a server. It is not uncommon for a relational database to consume nearly all of the memory and CPU while processing large quantities of data using multiple threads. While this maximiz… text/html 2012-10-26T14:51:09+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rdbms:updates&rev=1351263069&do=diff Integration: Relational Databases Overview | Servers | Environments | Queries | Updates | Implementation Guides ---------- Updating Relational Databases Omnidex is mostly commonly implemented on read-only tables. Many Omnidex applications take advantage of tens to hundreds of indexes per table, and online updates are impractical in this situation. Omnidex applications are usually built around tables that are refreshed on a daily, weekly or monthly basis. Once the data has been updated in …