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 is based on ANSI-standard SQL and 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. They simply submit standard SQL statements that reference the tables and columns in the database. This makes it easy to write new applications, and it also means existing applications that call ANSI-standard SQL will quickly receive the benefit of optimization.
See also: