This is an old revision of the document!


Integration: Relational Databases

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 ActiveCounts, PowerSearch or AutoComplete. Omnidex can access the data in the relational database and provide a high-speed query environment.

Integrating Omnidex into an application environment usually requires integration in two areas: the application (or client) layer, and the database (or server) layer. At the application layer, languages and tools generally use ODBC or JDBC to access the Omnidex SQL Engine. At the database layer, Omnidex is configured to access the underlying database. The Omnidex SQL Engine sits in between these layers, optimizing queries using the Omnidex indexes whenever possible.

Omnidex applications often have tens to hundreds of indexes per table, delivering extremely high performance. As such, Omnidex is usually installed on read-only tables that are updated at periodic intervals. Omnidex does support online indexing; however, this is not suitable for high-volume OLTP applications.

Some companies that use relational databases discover that Omnidex can also provide a complete SQL engine against raw data files. This introduces the possibility of creating an low-cost, high-performance, autonomous query environment used data extracted from the relational database on a separate server. This can alleviate the load on the relational database while improving performance and increasing scalability. This can also lower licensing costs for the overall application.

Additional Resources

See also:

 
Back to top
integration/rdbms/home.1300222131.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)