Omnidex SQL Engine

The Omnidex product is built around a powerful SQL engine that can process statements and take advantage of the Omnidex indexing technology. This SQL engine can process traditional SQL statements, such as SELECT, INSERT, DELETE and UPDATE, and can also process a wide variety of statements to maintain the database and directly access the Omnidex indexes. The Omnidex SQL Engine is based around Omnidex SQL, a language that begins with ANSI-standard SQL, and also includes a number of Omnidex-specific extensions.

The Omnidex SQL Engine automatically optimizes statements so that they use the Omnidex indexes as fully as possible. As is true with most relational databases, developers do not need to refer to the indexing strategy in their statements. This also allows applications that already call ANSI-standard SQL to direct their queries to Omnidex and quickly receive the benefit of optimization.

The Omnidex SQL Engine does not support the extensions of other relational databases such as Oracle, SQL Server or MySQL. Each of these databases has proprietary extensions to their language. These extensions only work in their respective databases. For these statements to work with the Omnidex SQL Engine, the proprietary extensions will need to be converted to ANSI-standard syntax or Omnidex extensions. Similarly, if applications are coded to reference Omnidex extensions, they will only work against when using the Omnidex SQL Engine.

The Omnidex SQL Engine is available through standard ODBC and JDBC interfaces. It can also be accessed interactively in the Omnidex Administrator and in the console program, OdxSQL.