Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
appendix:releasenotes [2010/08/12 19:39]
tdo
appendix:releasenotes [2012/10/26 14:46] (current)
Line 1: Line 1:
 {{page>:​top_add&​nofooter&​noeditbtn}} {{page>:​top_add&​nofooter&​noeditbtn}}
-<​html><​div align="​center"><​span style="​color:​red">​DRAFT</​span></​div></​html>​ 
  
-====== Omnidex ​Release Notes ======+====== Omnidex ​5.1 Patches ​======
  
-The following is a list of fixes and enhancements for Omnidex ​organized by the release. +The following is a list of fixes and enhancements for the Omnidex 5.x series of releases.
-===== 5.01.01G (In Development) ===== +
-OdxSQL no longer requires Windows file specifications to be escaped when using a connection string. Prior to 5.01.01G, the following syntax was required when using Windows filespecs and connection strings:+
  
-  odxsql> connect ​[localhost:7555]c:\\dev\\odx\\myodx.xml;+For a list of fixes and enhancements for Omnidex 5.0 series, click [[appendix:patches:v50 |here.]]
  
-Now the following syntax is allowed:+For a list of fixes and enhancements for Omnidex 4.x series, click [[appendix:patches:v4x |here.]]
  
-  odxsql> connect [localhost:​7555]c:​\dev\odx\myodx.xml;+===== 5.01.01L August 2011 ===== 
 +  * Fixed a indexing issue on Quicktext (Keyworded) columns which occurred only when two parsed columns were grouped together, and the second column was empty. ​ This causes indexing problems and any customer using grouping should upgrade to 5.01.01L.
  
 +===== 5.01.01K April 2011 =====
 +  * Added a STRICT/​RELAXED mode to the OdxJDBC Driver to allow connections to change from a read/write state to a read only state to work with certain tools such as JasperSoft.
  
 +===== 5.01.01J January 2011 =====
 +  * Fixed problem in internal oaexecsql routine to allow the Oracle functions within an Export statement.
 +  * Fixed Segmentation Fault error in the SQL optimizer.
 +  * Fixed Licensing system to work on read-only file systems.
  
-===== 5.01.01F (Aug 6, 2010===== +===== 5.01.01I October ​2010 ===== 
-Fixes to OdxNet to better handle network processing across a grid. +  * Fixed an issue to allow spaces in the OMNDIEX_HOME directory.
-===== Version 5.1 ===== +
-  * Omnidex Data Definitiion (DDL) support +
-    * CREATE ENVIRONMENT +
-    * CREATE DATABASE +
-    * CREATE TABLE +
-    * CREATE INDEX +
-    * DROP ENVIRONMENT +
-    * DROP DATABASE +
-    * DROP TABLE +
-    * DROP INDEX+
  
-Terminology changes +===== 5.01.01H October 2010 ===== 
-  ​Omnidex Index is a MDK index with the NP and NE options+  ​* Internal licensing change for flat file licensing
-  ​QuickText Index is a MDK index with the KW option. +  ​* Fixed an issue with the internal dbigetkeys optimizer and the indexing kernel.
-  FullText Index is a MDK index.+
  
-As of Omnidex ​5.1 XML Environments are the preferred approach over the legacy Omnidex Environment Catalogs using the original OmniAccess Environment syntax and compiled with oacomp. ​ With 5.1, XML Environments can be more easily maintained with the OdxSQL using the DDL CREATE statements. ​ The new Omnidex Environment file is stored in the common XML format.+===== 5.01.01G September 2010 =====
  
-===== Version 5.0 - July 2009 ===== +  * Fixed a problem when using EXISTS in an Omnidex Grid environment
-==== Major ====+  * Added a facility to create an odxnet.log in the $OMNIDEX_HOME/​logs/​ directory should OdxNet abort abnormally. 
 +  * OdxSQL no longer requires Windows file specifications to be escaped when using a connection string. Prior to 5.01.01G, the following syntax was required when using Windows filespecs and connection strings:
  
-  ​* Unification of ASK and MDK indexes in DBINSTAL. +  ​odxsql> connect [localhost:​7555]c:​\\dev\\odx\\myodx.xml;
-  * OdxQuery is no longer being supported. ​ The program may still be in the Omnidex distribution. Customers should use OdxSQL with the -odbc option to test retrievals across the network. +
-  * DSEDIT'​s Connect and Retrieval options are no longer supported but DSEDIT can still be used to create System, User and File ODBC and JDBC Data Sources. ​ This functionality is being moved to the Omnidex Administrator in the 5.2 release.+
  
-===== Build 4.5.01A - Jan 2009 =====+Now the following syntax is allowed:
  
-==== Major ====+  odxsql> connect [localhost:​7555]c:​\dev\odx\myodx.xml;​
  
-  ​Support for native 64-bit on Windows, Linux and HP-UX +===== 5.01.01F August 2010 ===== 
-  * Support ​for Oracle 11g on HP-UX +  ​Fixes to OdxNet to better handle network processing across a grid. 
-  * Support for MySQL 5.01 on Windows ​and Linux using the DataAccess ODBC Interface +  * Added a Linux 32 bit version that runs under 54bit Linux for MicroStrategy compatible. 
-==== Moderate ====+  * As of the 5.01.01F release, the Index Directory option of the CREATE DATABASE no longer uses the index prefix option ​and will instead create the directory if they do not already exist in the OS.  Existing DDL may have to be modified if they are using the Index_Directory/​Index_Prefix option.
  
-  * Support for detailed, real-time statistics from the ODXSQL UPDATE STATISTICS command +===== 5.01.01E July 2010 ===== 
-  * Support in OdxSQL for api=JDBC +  * Added several Oracle functions which can be used after a SET SQL_SYNTAX ORACLE statement is issued. 
-  * Support for UPDATE INDEXES command ​to build Omnidex Indexes from ODXSQL or oaexecsql +  * Made improvements ​to OdxNet ​for Grid processing ​and the ODBC/JDBC interfaces. 
-  * Support ​for LOAD OFX, UPDATE ROLLUPS ​and UPDATE TEXT in oaexecsql as well as ODXSQL +  * Fixes to OdxNet ​for multi-threaded concurrency
-  * Support ​for Omnidex XML Environments in OmniAccess, with support in:  +  * Enhanced Explain Plans to show Grid information. 
-    * oacomp with -xml option or specifying an Omnidex Environment with an **xml** suffix. +  * Added Error number 89067 to the Omnidex ​Message file dealing with the indexing kernel licensing.
-    * oadecomp +
-    * oahelper +
-  * Support more efficient given name synonym lists with a maximum of eight synonyms +
-  * Changed oaglobal.env ​to Omnidex.env, allowing "​connect myenv" without a path specification +
-  * Changed OAGLOBAL environment variable to OMNIDEX_ENV+
  
-==== Minor ==== +The following is an example of the enhanced Explain Plans on Grid.
-  * Added support for -odxnet option in OdxSQL to automatically launch OdxNET +
-  * Added support for both 32-bit and 64-bit C DATETIME datatypes +
-  * Fixed problem with OdxSQL command SET CONTINUATION OFF +
-  * Fixed problem with $BITMAP_INDEX and other columns in system catalog table $INDEXES +
-  * Fixed signal handler in Java scenarios[Note JBOSS must still be run with alternate Java DLL.] +
-  * Allow $SCORE and $CONTAINS even when no proximity qualifications have occurred +
-  * added support for the CLOB datatype in Omnidex Standalone Tables (OST). +
-  * Added file sizes for flatfile databases in the ODXSQL SHOW command and the info calls. +
-  * Internal Changes to the Info call structure and Makefile  +
- +
  
-===== Build 4.4.02B ​Aug 2007 ===== +<​code>​ 
-==== Minor ====+----------------------------------- SUMMARY ----------------------------------
 +Select ​       STATE, 
 +              count(*) 
 +  from        PROSPECTS 
 +  group by    STATE 
 +  with        opt=no_rollup;
  
-  * Support oafetchkeys with KEYWD or KWCOUNT options on Distributed Indexes +Version: ​     5.1 Build 1E  (Compiled Jul  2 2010  10:50:49) 
-  * Support the column alias also being the name of a column in the table. +Optimization:​ GRID 
-  * Support NULL values for OMNIDEX, ANSI, ASCII and C DATE datatypes. +Warnings: ​    ​GRID_AGGREGATION 
-  * Support for Java 1.5 on UNIX platforms +------------------------------- GRID PERFORMANCE ------------------------------ 
-  * Automatically add App_Themes directory on first use of OmniSearch (preview only) +                                                   ​Elapsed seconds 
- +                          0.0        ​1.6         ​3.1 ​      ​4.7 ​          6.2 
 +[localhost] 
 + Controller ​              ​--------------- ​                                 + 
 + ​NODE01 ​                                ​.................===>>​ 
 + ​NODE02 ​                                ​.................===>>​ 
 + ​NODE03 ​                                                     ............==>​
  
-===== Build 4.4.02A - Aug 2007 ===== 
-==== Moderate ==== 
  
-  ​* Beta release of Omnidex JDBC Intelligent Router +Elapsed Time              Connect ​ Select ​ Fetch (Count) ​  ​Transfer ​ Total 
-  * Support for JDK and JRE 1.5 for the Omnidex JDBC driver +NODE01 ​                   2.12     ​0.40 ​   0.04 (1)           ​- ​     2.57 
-  * Translate environment variables in datasources for the Omnidex JDBC+NODE02 ​                   2.14     ​0.39 ​   0.03 (2)           ​- ​     2.56 
 +NODE03 ​                   1.50     ​0.25 ​   0.03 (6)           ​- ​     1.78 
 +Controller ​                                                          ​6.23 
 +---------------------------------- GRID NODES ---------------------------------
  
-==== Minor ====+  ---------------------------------- NODE01 --------------------------------- 
 +  Start/​Stop: ​  ​13:​41:​38.223 to 13:​41:​38.629 
 +  Elapsed: ​     0.406 
 +  Request Opt:  PRIKEY, MDKQUAL, NO_DISTINCT_KEYWD,​ ASKQUAL, ASKORDERBY,​ 
 +                AGGREGATION,​ ASKLINK, ASKRETRIEVAL,​ STARSCHEMA, CACHED_VIEW,​ 
 +                MDKLINK, HDC, REUSEQUAL, NO_ROLLUP, NO_UNRESTRICTEDQUAL 
 +  Optimization:​ AGGREGATION 
 +  Details:
  
-  ​* Support for nested queries in the FROM clauses within the WHERE clause +  ​Aggregate PROSPECTS ​using STATE for GROUP(STATE), ​COUNT(*on 1; 
-  * Optimization of nested queries against partition qualifiers within Union Views +  ​Return PROSPECTS.STATE,​ COUNT('​*');
-  * Optimization ​using rollup tables within Union Views +
-  * Improved optimization in Union Views within columns using the DISTINCT_IN_PARTITION option +
-  * Improve memory mapping and exclusive access ​for files +
-  * Fix to avoid processing grouped ​COUNT(DISTINCT ...using rollup tables unless all group by columns match the rollup table +
-  * Fix display of counts for OmniSearch ActiveCounts template (preview only)+
  
 +  ---------------------------------- NODE02 ---------------------------------
 +  Start/​Stop: ​  ​13:​41:​38.238 to 13:​41:​38.629
 +  Elapsed: ​     0.390
 +  Request Opt:  PRIKEY, MDKQUAL, NO_DISTINCT_KEYWD,​ ASKQUAL, ASKORDERBY,
 +                AGGREGATION,​ ASKLINK, ASKRETRIEVAL,​ STARSCHEMA, CACHED_VIEW,​
 +                MDKLINK, HDC, REUSEQUAL, NO_ROLLUP, NO_UNRESTRICTEDQUAL
 +  Optimization:​ AGGREGATION
 +  Details:
  
- +  Aggregate PROSPECTS using STATE for GROUP(STATE),​ COUNT(*) on 1; 
 +  Return PROSPECTS.STATE,​ COUNT('​*'​);​
  
-===== Build 4.4.01C  ===== +  ---------------------------------- NODE03 --------------------------------- 
-====  Moderate ==== +  Start/​Stop: ​  ​13:​41:​40.160 to 13:41:40.410 
-  ​* Optimization of nested queries against partition qualifiers in Union Views. ​ +  ​Elapsed: ​     0.250 
-  ​Optimization ​using rollup tables in Union Views. ​ +  ​Request Opt:  PRIKEY, MDKQUAL, NO_DISTINCT_KEYWD,​ ASKQUAL, ASKORDERBY,​ 
-==== Minor ====+                AGGREGATION,​ ASKLINK, ASKRETRIEVAL,​ STARSCHEMA, CACHED_VIEW,​ 
 +                MDKLINK, HDC, REUSEQUAL, NO_ROLLUP, NO_UNRESTRICTEDQUAL 
 +  Optimization: AGGREGATION 
 +  ​Details:​
  
-  * Fix problems with oastatementinfo in queries against grids (DBUNION rule+  ​Aggregate PROSPECTS using STATE for GROUP(STATE),​ COUNT(*) on 1; 
 +  Return PROSPECTS.STATE,​ COUNT('​*'​)
 +------------------------------- GRID CONTROLLER ------------------------------- 
 +Select ​       STATE, 
 +              cast(sum(NEWCOL1) as unsigned integer) 
 +  from        NODE_RESULTS 
 +  group by    STATE 
 +  with        OPTIMIZATION=no_rollup;​
  
-===== Build 4.4.01B - Jul 2007 ===== +Request Opt:  PRIKEY, MDKQUAL, NO_DISTINCT_KEYWD,​ ASKQUAL, ASKORDERBY, 
-==== Moderate ==== +              ​AGGREGATION,​ ASKLINK, ASKRETRIEVAL,​ STARSCHEMA, CACHED_VIEW,​ 
-  * Support for the DataAccess ODBC driver on Linuxwith testing against FreeTDS ​ +              ​MDKLINKHDC, REUSEQUAL, NO_ROLLUP, NO_UNRESTRICTEDQUAL 
-==== Minor ==== +Optimization:​ NONE 
-  * Fixed DSEdit and OdxQuery to allow them to work with 4.4.n releases. +Warnings: ​    ​UNOPTIMIZED_AGGREGATION,​ UNOPTIMIZED_SORT,​ SEQUENTIAL_SCAN 
-  * Fixed Omnidex Addin problem with DBUNION (Grid) statements.+Notes: ​       Optimized aggregations are not possible because no ASK index 
 +                contains all columns 
 +Details:
  
 +Retrieve NODE_RESULTS sequentially;​
 +Pass to queue {1} [NODE_RESULTS.STATE,​ NODE_RESULTS.NEWCOL1];​
 +Sort {1} for GROUP BY [NODE_RESULTS.STATE ASC];
 +Retrieve {1} sequentially;​
 +Return NODE_RESULTS.STATE,​ CAST(SUM(NODE_RESULTS.NEWCOL1) AS UNSIGNED
 +   ​INTEGER);​
 +-------------------------------------------------------------------------------
 +>
 +</​code>​
  
 +===== 5.01.01D July 2010 =====  ​
 +  * Added Machine (System and User) Data Source creation and editing to the Omnidex ODBC Driver under Windows. You create/​modify/​delete System/​User/​File DSN using the standard “ODBC Data Source Administrator” program. Access this interface from Control Panel/​Administrative Tools/Data Sources (ODBC).
  
-===== Build 4.4.01A - June 2007 ===== +  ​Under Linuxyou need to use odbcinst program ​if you use UnixODBCOtherwiseyou need to manually modify ODBC.INI file.
-  +
-==== Moderate ==== +
-  ​Optimization of TOPSKIP, EVERY and RANDOM clause of SELECT statements ​to take advantage of skips within indexing. +
-  * Improve handling of TOP and SKIP operations in the grid processing with the Addin (DBUNION rule). +
-  * Change version checking between client and server so that: +
-    * ODBC and JDBC are based on an earliest compatible version, and  +
-    * CLOA is based on the Omnidex version, taking into consider whether info calls are to be used.  +
-  * For CLOA, the new property NoInfoCalls=Yes is supported, and if set, allows versions to sync on just x.xxrather than x.xx.xx. ​   +
-  * -- oaversion now supports showing the earliest  +
-  * Alpha internal release of OmniSearch +
-==== Minor ==== +
-  * Improve debug messages ​to show better operating system information in banners and trace files. +
-  * Fix abort that occurs when column alias is a literal, but order by is a column. +
-  * Fix to oainfo to resolve problems with info calls in the ODBC driver +
-  * Improve performance of Hashed Data Cache on large result sets.+
  
 +===== 5.01.01C June 2010 =====
 +  * Added a WITH LOG=<log directory>​ to log indexing information during the UPDATE INDEXES process. ​ Also added a dbinstal.log that shows the dbinstal execution for this UPDATE INDEXES.
  
 +===== 5.01.01B June 2010 =====
 +  * Minor bug fixes.
  
-===== Build 4.3.4A - Apr 2007 ===== +===== 5.01.01A May 2010 ===== 
-==== Moderate ​==== +  * Initial 5.01.01A release. 
-  * Port to 64-bit Linux+ 
 +==== DDL Support ​==== 
 +  * Omnidex Data Definitiion (DDL) support 
 +    * CREATE ENVIRONMENT 
 +    * CREATE DATABASE 
 +    * CREATE TABLE 
 +    * CREATE INDEX 
 +    * DROP ENVIRONMENT 
 +    * DROP DATABASE 
 +    * DROP TABLE 
 +    * DROP INDEX 
 + 
 +==== Terminology changes ==== 
 +  Omnidex Index is a MDK index with the No Parse and No Exclude options (dbinstal NP, NE). 
 +  QuickText Index is a MDK index with the keyword option (dbinstal KW). 
 +  FullText Index is a MDK index with the proximity option (dbinstal PX). 
 + 
 +==== XML versus ENV Catalogs ==== 
 +As of Omnidex 5.1 XML Environments are the preferred approach over the legacy Omnidex Environment Catalogs using the original OmniAccess Environment syntax and compiled with oacomp. ​ With 5.1, XML Environments can be more easily maintained with the OdxSQL using the DDL CREATE statements. ​ The new Omnidex Environment file is stored in the common XML format.
  
-==== Minor ==== +==== Known Problems ​==== 
-  * Change oahelper’s generation of Omnidex installation scripts from a Unix shell script to a two input files, one for installing indexes and one for building indexes +  * NsAdmin does not work. 
-  * Change oahelper’s environment source generation to declare the database type as SQL Server rather than ODBC on SQL Server databases +  * odxnet ​-admin option is not currently active
-  * Support for SET CONTINUATION ON | OFF in ODXSQL to support Oracle or SQL Server style of entering multi-line statements. +  * odxnet ​-nodaemon option is disabled.
-  * Fix OMNIDEX_DEBUG=ALL to display DataAccess driver messages as well +
-  * Change licensing checks in Omnidex so that more utility operations are allowed when unlicensed, while still prohibiting database and index access. +
-  * Fix problem where the OFX index files were not being deleted along with their TDF data files +
-  * Fix problem in the Omnidex kernel where the pre-intersect counts were inaccurate on bitmap-indexed columns+
-  * Internal only: change odxget’s count parameter to a 32-bit integer to allow larger skip forward or skip backward operations +
- +
  
 +==== OdxSQL Changes ====
 +  * OdxSQL now defaults to using a terminator, like Oracle or SQL Server. ​ In 5.0 and earlier, you could do:
 +<​code>​
 +select * \
 +  from grs \
 +  where criteria
 +</​code>​
  
 +and not have to end with a terminator. ​ Now you can do:
 +<​code>​
 +select * 
 +  from grs
 +  where criteria;
 +</​code>​
 +and not have to enter the continuation characters.  ​
  
 +To get the previous behavior, use the following OdxSQL SET option.
  
-=====  Build 4.3.03A - Feb 2007 ===== +  set termination off
-  +
-==== Moderate ==== +
-  * Support for optimized radius searches, including +
-  * Support for $distance function +
-  * Support for USAGE LATITUDE, USAGE LONGITUDE in the environment file +
-  * Optimization of $distance functions against Omnidex composite keys containing longitude and then latitude +
-  * Support for Rollup Tables, including +
-  * Support for declaration of Rollup Tables in the environment files +
-  * Support for automatically optimizing queries using rollup tables +
-  * Support for UPDATE ROLLUPS command in ODXSQL  +
-  * Support for metadata about Rollup Tables in oatableinfo +
-  * Support for PARTITION BY clauses containing more than one predicate, such as STATE in (‘CO’) and ZIP between (‘80000’ and ‘80999’) +
-==== Minor ==== +
-  * Support for Oracle 8 on Windows platforms +
-  * Support for Oracle 10g on Linux platforms +
-  * Fix error in Omnidex kernel in large wildcard qualifications,​ such as 1995@ (Axciom) +
-  * Fix error in Omnidex kernel dealing with intersecting large bitmap ID lists +
-  * Allow partitioning of all tables for grid environments,​ rather than restricting to child tables +
-  * Improve table join support for grid environments +
-  * Improve temporary file naming routines to make more unique for high-speed, multithreaded operations +
-  * Disallow the LOAD OFX FOR TDF … command since it is replaced by LOAD OFX FOR TABLE … command +
-===== Build 4.3.2B - Oct 2006 ===== +
-  * Support for creating/​attaching a temp table with a specified access level. +
-  * Improved handling of semaphores +
-  * Fixed eadecomp to preserve "​partition by" clauses +
-  * Fixed oahelper to load correct .dll based on version number +
-===== Build 4.3.1E - Sep 2006 =====+
  
-  * Support for new PRESERVE_CRITERIA option in oaselect +and it will use the 5.0-style behavior.  ​
-  * Improved performance when checking for blank char fields +
-  * Handling of incorrectly formulated in-clauses (e.g., "​gender in (M, F, G)" instead of "​gender in ('​M',​ '​F',​ '​G'​)"​ ) +
-  * Fixed partition table problem when "​env.db.tbl"​ is used +
-  * Fixed OPEN CURSOR and CLOSE CURSOR issues in Omnidex OmniAccess Client API (cloa) +
-  * Fixed SNOWFLAKE_UNJOIN problem of changing "​or"​ to "​and"​ in the where clause +
-  * Removed reliance on the OMNIDEX_LIBS environment variable.+
  
-===== Build 4.3.1B - Jul 2006 ===== 
  
-  * Support for multiple OR’d values in partition qualifiers for aggregation indexes 
-  * Support for partition qualifiers in aggregation indexes that have partial columns as the first component 
-  * Support for partition qualifiers in aggregation indexes that have partial columns as the first component 
-  * Support for the DISTINCT_IN_PARTITION option to the COLUMN statement within Union Views. ​      This option indicates that count distinct operations on this column are better optimized because the    administrator guarantees that values are distinct within each partition.  ​ 
-  * Support for the CACHE/​NOCACHE options in the DBUNION rules in environment files. This option indicates that the grid processing should cache connections to the node so that repeated calls to CLoaconnect,​ CLoaopencursor,​ CLoaclosecursor and CLoadisconnect are not needed for  each node within each query. 
-  * Extend limit for Alt Sorts using Aggregation Indexes from 16 components to 32 components 
-  * Enhance Union View processing to honor DISTINCT_IN_PARTITION clauses on SELECT DISTINCT … statements. 
-  * Support for Postgres RDBMS using our DataAccess ODBC driver 
-  * Further support for partial-length components as partition qualifiers in Aggregation Indexes. 
-  * Change sequence of instructions in Omnidex kernel to circumvent a Microsoft compiler optimization error 
-  * Enhance grid (DBUNION) processing to honor UNIQUE_TO_PARTITION clauses on SELECT DISTINCT … statements. 
-  * Support for compiling and running in 32-bit mode on 64-bit Windows architecture. 
-  * Improve performance on Record Specific processing on Windows. 
-  * Support multiple databases in NODE section and multiple table.column in the UNIQUE_TO_NODE clause of DBUNION rule. 
-  * Fix error on criteria with long quoted strings 
-  * Favor ASK over MDK optimization for distinct key processing. 
-  * Fix problem with temporary files on certain aggregations. 
 
Back to top
appendix/releasenotes.1281641985.txt.gz · Last modified: 2012/10/26 14:40 (external edit)