Each new version of Omnidex brings a collection of improvements, from new features to increased performance. Here are the primary features and enhancements in the major releases of Omnidex:

Omnidex now adds AutoComplete to its features designed to support high-performance, interactive applications. AutoComplete allows the application designer to display real-time choices based on the characters typed so far, similar to auto-complete features found in Internet search engines. AutoComplete can be activated on a per-column basis, and can be easily integrated with PowerSearch and ActiveCounts.

Omnidex now supports, real-time connection and query monitoring. Administrators can view all current connections and queries, their current state and statistics. Administrators can also view the past 30 days of connection and query activity to understand usage trends, resource requirements, and performance metrics. Connection and query monitoring is automatic for all Omnidex processes on the server.

Omnidex now supports a universal connection string syntax throughout the product, streamlining the process of connecting to Omnidex databases.

Omnidex now support three editions: Omnidex Enterprise Edition, Omnidex Developer Edition, and Omnidex Trial Edition.

• The Omnidex Enterprise Edition is unrestricted in features, database size and concurrent connections. Omnidex Enterprise Edition is appropriate for production applications, as well as large-scale development and testing.
• Omnidex Developer Edition supports all features of Omnidex, although it is limited in the size of the database and the number of concurrent connections. Omnidex Developer Edition can be downloaded free of charge, and is ideal for general development and testing.
• The Omnidex Trial Edition is unrestricted in features, database size and concurrent connections, but is limited to 30 days. Omnidex Trial Edition is appropriate for evaluating Omnidex in a large-scale development and testing environment.

Version history

• Omnidex now supports, real-time connection and query monitoring.

• Support for DISTINCT_KEY optimization

• Broader support for connection strings throughout Omnidex
• Support for local and remote environment variables in connection strings
• Support for connection options in connection strings

• Support for ROLLUP nodes, distinct from UNPARTITIONED nodes
• Support for UNINDEXED clause
• Support for REQUIRED_OPTIMIZATION=NO_GRID_AGGREGATIONS
• Support for Connection Pooling for grids
• Support for a thin grid client-server relationship
• Possible: Support for taking nodes online and offline
• Possible: Support for clustered grids

• Support for three editions of Omnidex:
  • Omnidex Enterprise Edition
  • Omnidex Developer Edition
  • Omnidex Trial Edition
• License all database drivers and optimization options for each edition
• Support for SHOW LICENSE, REQUEST LICENSE and REGISTER LICENSE commands
• Possible: Support for licensing validation via DISC website

• Improved support for Read-Only Filesystems
• Support for $GETENV function
• Support for more functions used in the ORDER BY clause.
• Support for timezones.
• Improved support for paths and filenames containing spaces
• Support for [NO_]CACHEHDC optimization
• Support for CACHE= on queries?
• Possible: Support for PowerSearch option

• Improved support for Pentaho
• EXTRACT DDL FROM <ORACLE | SQLSERVER | MYSQL | ODBC>
• Use correct number of bytes on national character sets
• Support for LOAD OFX FOR <ENVIRONMENT | DATABASE>.
• Possible: Support for HDFS files

• Support for “odxnet –shutdown –children_only” to terminate child processes without terminating listener.

• ODBC Driver registration
  • Change default ODBC Driver name from “DISC OMNIDEX OdxNet Driver” to “Omnidex”, but allow installation of dual names for backward compatibility with “odbcreg -b” option
• The NODE clause within the CREATE ENVIRONMENT statement now uses ConnectionString rather than Environment for specifying remote node locations.
• Change MDK_RETRIEVAL_THRESHOLD to QUALIFICATION_THRESHOLD and change ASK_RETRIEVAL_THRESHOLD to AGGREGATION_THRESHOLD.
• Correct spelling of MaxSonProcesses in odxnet configuration files.
• Statistics files are now required to use optimization.
• Change TDF files to DELIMITED files, though TDF is still an accepted synonym.
• Change FLATFILE database types to FILE database types, though FLATFILE is still a supported synonym.
• Change C STRING datatypes to STRING datatypes, though C STRING is still a supported synonym.
• Dates are now left justified when Omnidex converts them to string format.

[close]

See also: