Integration: Relational Databases

SQL Server


Omnidex can be deployed directly against a Microsoft SQL Server database. Omnidex retrieves and indexes the SQL Server data, and queries read directly from the SQL Server database as needed. This approach allows Omnidex to work alongside SQL Server, providing a high-performance query environment for applications.

An Omnidex Environment File controls how Omnidex connects to the SQL Server database and identifies the tables and columns that Omnidex will have access to. Omnidex accesses the SQL Server data directly using standard SQL statements issued through the SQL Server libraries. During indexing and query processing, Omnidex maintains a connection to the SQL Server 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.

Omnidex does not migrate the data out of SQL Server, but instead directly references the data in the SQL Server database. This is not a requirement, though. Migration of the data into raw data files is an option if that is preferable. In fact, many companies use Omnidex Snapshots for this very purpose. Omnidex Snapshots are high-performing, highly-portable, heavily-indexed copies of data that can be easily accessed using standard ODBC and JDBC interfaces.

Omnidex is usually deployed on read-only tables. Most applications require tens to hundreds of Omnidex indexes on a table, making real-time updates impractical. Applications usually set aside certain SQL Server tables that are refreshed on a regular basis and Omnidex indexes are completely refreshed. Omnidex does support real-time updates for those situations where there are fewer indexes and lower volume.

Additional Resources

See also:

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