Fast light

News

OMNIDEX Version 5.1 released - July 2010

Version 5.1 includes the following enhancements:

A New Interface for Omnidex Administrators

Omnidex 5.1 provides a greatly improved interface for Omnidex Administrators. Omnidex Environment Files are created using standard SQL statements such as CREATE DATABASE and CREATE TABLE. Omnidex indexes are creating using standard statements such as CREATE INDEX, or even using additional syntax in the CREATE TABLE statement. Indexes are built using a new UPDATE INDEXES statement. All of these commands can be easily called from the OdxSQL utility, or programmatically from the ODBC and JDBC interfaces, greatly simplifying the installation of Omnidex. The old approaches - calling OACOMP and DBINSTAL - are still supported for backward compatibility.

Full Support for Omnidex Grids

Omnidex 5.1 provides support for Omnidex Grids in complex relational models. Omnidex Grids have been supported for many years; however, Omnidex 5.1 provides support for a much wider variety of queries in more complex relational models. Omnidex 5.1 also includes many optimizations to improve the parallel processing of queries.

Support for Common Oracle Functions

Omnidex 5.1 provides support for some of the more common Oracle SQL Functions, allowing existing Oracle-based applications to use Omnidex without converting to ANSI-standard SQL.

ODBC Support on Linux

Omnidex 5.1 extends support for all other ODBC Managers on Linux beyond UnixODBC.

OMNIDEX Version 5 released - July 2009

We are pleased to announce the production release of OMNIDEX Version 5. This incorporates major changes below which greatly simplify installation and provide a further leap in query performance.

Simpler and Higher-Performing Indexing

Omnidex 5.0 combines all indexing features into one index type, simplifying the installation of indexes and greatly speeding index builds. Earlier versions of Omnidex used separate index types for searching and aggregating. Criteria was generally optimized with MDK indexes, and aggregations were generally optimized with ASK indexes. This frequently required administrators to index some columns twice, once with each index type, thus increasing build time and system resources. Indexes suitable for aggregations and ordering were also built individually, requiring many scans of the underlying data. Omnidex 5.0 allows all indexes to be processed in one batch. In heavily indexed scenarios, this can result in a 500% improvement in build performance and a 50% reduction in disk space.

Support for XML Environment Files

Omnidex 5.0 introduces XML files as the new storage approach for Omnidex Environment Files. Historically, Omnidex Environment Files were created by compiling a source file into an Environment File. Omnidex 5.0 now records all information in a highly versatile and portable XML file. Compiled Environment Files are still supported for backward compatibility; however, new features will be developed using the new XML format.