This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
install:releases:odx52:history [2011/03/29 19:59] doc |
install:releases:odx52:history [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 10: | Line 10: | ||
| ===== Omnidex 5.2 Release History ===== | ===== Omnidex 5.2 Release History ===== | ||
| - | ==== 5.2.01A (planned for 2011) ==== | + | The following table shows the individual releases of Omnidex 5.2, including their release dates and features. |
| - | === Connection and Query Monitoring === | ||
| - | * Omnidex now supports, real-time connection and query monitoring. | + | |< 60% 40% 60% >| |
| + | ^ Release ^ Release Date ^ | ||
| + | | [[#5_2_01A|5.2.01A]] | Planned for 2011 | | ||
| - | === Autocomplete === | ||
| - | * Support for DISTINCT_KEY optimization | + | \\ |
| - | === Connection strings === | + | ---- |
| - | * Broader support for connection strings throughout Omnidex | + | |
| - | * Support for local and remote environment variables in connection strings | + | |
| - | * Support for connection options in connection strings | + | |
| - | === Omnidex Grids === | + | |
| - | * 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 | + | |
| - | === Licensing === | + | |
| - | * 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 | + | |
| - | === SQL Engine === | + | |
| - | * 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 | + | |
| - | === Integration === | + | ==== 5.2.01A ==== |
| - | * 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 | + | |
| - | === Network Services === | + | === Release Platforms and Dates === |
| - | * Support for “odxnet –shutdown –children_only” to terminate child processes without terminating listener. | + | |
| - | === Backward compatibility: === | + | Release is planned for 2011, and will be available on both Microsoft Windows and Linux. |
| - | * 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. | + | |
| + | === Release Notes === | ||
| - | [[install:releases:odx52|[close]]] | + | == Connection and Query Monitoring == |
| + | * Omnidex now supports, real-time [[admin:monitor:home|connection and query monitoring]]. | ||
| + | |||
| + | == AutoComplete == | ||
| + | |||
| + | * Omnidex now supports [[admin:indexing:autocomplete:home|AutoComplete]], a feature that allows applications to display relevant choices and their counts as the user types characters into a search field. | ||
| + | |||
| + | == Connection strings == | ||
| + | |||
| + | * Omnidex now provides broad support for [[dev:connections:home|connection strings]] throughout the product. Connection string provide a simple and universal way of connecting to an Omnidex Environment File. | ||
| + | |||
| + | == Omnidex Grids == | ||
| + | |||
| + | * Omnidex Grids now allow a new node type called Rollup Nodes that are used to support Omnidex Rollup Tables that span all nodes. Customers that have previously used Unpartitioned Nodes for this purpose should switch to Rollup Tables to improve the performance of building indexes. | ||
| + | * Omnidex Grids now support an UNINDEXED option within the NODE clause of the CREATE TABLE statement. This clause indicates that the table should not be indexed for a particular node. This is often used in Rollup Nodes to avoid the indexing of the tables that underlay rollup tables. | ||
| + | * Omnidex Grids now support Grid Connection Pooling, designed specifically for a grid environment. Connection pooling supports a grid by intelligently obtaining and releasing connections to the nodes in a common pool, increasing performance and reduces resource usage. | ||
| + | |||
| + | == SQL Engine == | ||
| + | * Omnidex now supports timezones when working with date-class datatypes. | ||
| + | * Omnidex now supports the [[dev:sql:functions:getenv:home|$GETENV]] function for referencing environment variables in Omnidex SQL statements. | ||
| + | * Omnidex now supports spaces in filenames and directory names throughout the Omnidex product on Microsoft Windows operating systems. | ||
| + | * Omnidex now allows the memory used in the [[admin:optimization:caches:hdc|Hashed Data Cache]] to be configured on a per-query basis using the [[dev:sql:statements:select:options#data_cache|DATA_CACHE=]] option. | ||
| + | |||
| + | == Licensing == | ||
| + | * Omnidex now supports three product editions. | ||
| + | * Support for three [[install:editions|editions]] of Omnidex: Omnidex Enterprise Edition, Omnidex Developer Edition and Omnidex Trial Edition. | ||
| + | * Omnidex licensing has been streamlined through three new commands in OdxSQL: [[programs:odxsql:commands:request_license|REQUEST LICENSE]], [[programs:odxsql:commands:register_license|REGISTER LICENSE]], and [[programs:odxsql:commands:show_license|SHOW LICENSE]]. These commands are also discussed in the [[install:licensing:home|guide to Omnidex Licensing]]. | ||
| + | |||
| + | == Integration == | ||
| + | * Omnidex now allows DDL statements to be extracted directly from relational databases using the [[dev:sql:statements:extract|EXTRACT]] SQL statement. This replaces the similar feature that was previously found in the legacy program, OAHELPER. | ||
| + | * Omnidex's JDBC driver has been enhanced to support the Pentaho suite of Business Intelligence tools. | ||
| + | |||
| + | == Network Services == | ||
| + | * Omnidex now supports [[admin:basics:network:options|options]] to allow Omnidex Network Services to terminate existing processes without having to completely restart the service. | ||
| + | |||
| + | == Backward compatibility: == | ||
| + | * In the 5.x releases of Omnidex, the product is being simplified and streamlined. As part of that effort, the following changes have been made. | ||
| + | * The acronym TDF, standing for Tab-Delimited Files, was used throughout the product to reference delimited files. This mnemonic has been changed to DELIMITED, though TDF is still an accepted synonym for backward compatibility. | ||
| + | * The FLATFILE database type within the CREATE DATABASE statement has been change to FILE, though FLATFILE is still a supported synonym for backward compatibility. | ||
| + | * The C STRING datatype has been changed to STRING, though C STRING is still a supported synonym for backward compatibility. | ||
| + | * The name used for the Omnidex ODBC driver, which has been "DISC OMNIDEX OdxNet Driver", has been changed to "Omnidex". Both names can be registered for backward compatibility using the ODBCReg utility. | ||
| + | * The NODE clause within the CREATE ENVIRONMENT statement now uses ConnectionString rather than Environment for specifying remote node locations. | ||
| + | * The optimization setting MDK_RETRIEVAL_THRESHOLD has been changed to QUALIFICATION_THRESHOLD, though MDK_RETRIEVAL_THRESHOLD is still a supported synonym for backward compatibility. | ||
| + | * The optimization setting ASK_RETRIEVAL_THRESHOLD has been changed to AGGREGATION_THRESHOLD, though ASK_RETRIEVAL_THRESHOLD is still a supported synonym for backward compatibility. | ||