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 [2011/04/21 01:36]
admin
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 ===== 
-===== 5.01.01F (Aug 6, 2010) ===== +  * Fixed 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.
-Fixes to OdxNet to better handle network processing across ​grid.+
  
-Known Problems:+===== 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.
  
-  NsAdmin does not work.+===== 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.
  
-  odxnet -admin option is not currently active.+===== 5.01.01I October 2010 ===== 
 +  * Fixed an issue to allow spaces in the OMNDIEX_HOME directory.
  
-  odxnet -nodaemon option is disabled.+===== 5.01.01H October 2010 ===== 
 +  * Internal licensing change for flat file licensing. 
 +  * Fixed an issue with the internal dbigetkeys optimizer and the indexing kernel.
  
-==== Index_Directory changes ​==== +===== 5.01.01G September 2010 =====
-As of the 5.01.01F release, the Index Directory option of the CREATE DATABASE no longer uses the index direction 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.+
  
-===== Version 5.1 ===== +  * Fixed a problem when using EXISTS in an Omnidex Grid environment
-==== DDL Support ==== +  * Added a facility to create an odxnet.log in the $OMNIDEX_HOME/​logs/​ directory should OdxNet abort abnormally. 
-  * Omnidex Data Definitiion (DDL) support +  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:
-    CREATE ENVIRONMENT +
-    * CREATE DATABASE +
-    * CREATE TABLE +
-    * CREATE INDEX +
-    * DROP ENVIRONMENT +
-    * DROP DATABASE +
-    * DROP TABLE +
-    * DROP INDEX+
  
-==== Terminology changes ==== +  odxsql> connect [localhost:​7555]c:​\\dev\\odx\\myodx.xml;
-  Omnidex Index is a MDK index with the NP and NE options. +
-  QuickText Index is a MDK index with the KW option. +
-  FullText Index is a MDK index.+
  
-==== XML versus ENV Catalogs ==== +Now the following ​syntax is allowed:
-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.+
  
-===== Version 5.0 - July 2009 ===== +  odxsql> connect [localhost:​7555]c:​\dev\odx\myodx.xml;
-==== Major ====+
  
-  ​Unification of ASK and MDK indexes in DBINSTAL+===== 5.01.01F August 2010 ===== 
-  * OdxQuery is no longer being supported.  ​The program may still be in the Omnidex distributionCustomers should use OdxSQL with the -odbc option ​to test retrievals across ​the network. +  ​Fixes to OdxNet to better handle network processing across a grid
-  * 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 a future release +  * Added a Linux 32 bit version that runs under 54bit Linux for MicroStrategy compatible. 
 +  * 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.
  
-===== Build 4.5.01A - Jan 2009 =====+===== 5.01.01E July 2010 ===== 
 +  * Added several Oracle functions which can be used after a SET SQL_SYNTAX ORACLE statement is issued. 
 +  * Made improvements to OdxNet for Grid processing and the ODBC/JDBC interfaces. 
 +  * Fixes to OdxNet for multi-threaded concurrency. 
 +  * Enhanced Explain Plans to show Grid information. 
 +  * Added Error number 89067 to the Omnidex Message file dealing with the indexing kernel licensing.
  
-==== Major ====+The following is an example of the enhanced Explain Plans on a Grid.
  
-  * Support for native 64-bit on Windows, Linux and HP-UX +<​code>​ 
-  Support for Oracle 11g on HP-UX +----------------------------------- SUMMARY ----------------------------------- 
-  ​* Support for MySQL 5.01 on Windows and Linux using the DataAccess ODBC Interface +Select ​       STATE, 
-==== Moderate ====+              count(*) 
 +  ​from        PROSPECTS 
 +  group by    STATE 
 +  with        opt=no_rollup;
  
-  * Support for detailed, real-time statistics from the ODXSQL UPDATE STATISTICS command +Version: ​     5.1 Build 1E  (Compiled Jul  2 2010  10:50:49) 
-  * Support in OdxSQL for api=JDBC +OptimizationGRID 
-  * Support for UPDATE INDEXES command to build Omnidex Indexes from ODXSQL or oaexecsql +Warnings: ​    ​GRID_AGGREGATION 
-  * Support for LOAD OFX, UPDATE ROLLUPS and UPDATE TEXT in oaexecsql as well as ODXSQL +------------------------------- GRID PERFORMANCE ------------------------------ 
-  * Support for Omnidex XML Environments in OmniAccess, with support in:  +                                                   ​Elapsed seconds 
-    * oacomp with -xml option or specifying an Omnidex Environment with an **xml** suffix+                          0.0        1.6         ​3.1 ​      ​4.7 ​          6.2 
-    * oadecomp +[localhost] 
-    * oahelper + Controller ​              ​--------------- ​                                 + 
-  * Support more efficient given name synonym lists with a maximum of eight synonyms + NODE01 ​                                ​.................===>>​ 
-  * Changed oaglobal.env to Omnidex.env, allowing "​connect myenv" without a path specification + NODE02 ​                                .................===>>​ 
-  * Changed OAGLOBAL environment variable to OMNIDEX_ENV+ NODE03 ​                                                     ............==>​
  
-==== Minor ==== 
-  * Added support for a -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 ===== +Elapsed Time              Connect ​ Select ​ Fetch (Count) ​  ​Transfer ​ Total 
-==== Minor ====+NODE01 ​                   2.12     0.40    0.04 (1)                2.57 
 +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 ---------------------------------
  
-  ​* Support oafetchkeys with KEYWD or KWCOUNT options on Distributed Indexes +  ​---------------------------------- NODE01 --------------------------------- 
-  ​* Support the column alias also being the name of a column in the table+  ​Start/​Stop: ​  ​13:​41:​38.223 to 13:​41:​38.629 
-  ​* Support NULL values for OMNIDEX, ANSI, ASCII and C DATE datatypes+  ​Elapsed: ​     0.406 
-  ​* Support for Java 1.5 on UNIX platforms +  ​Request Opt:  PRIKEY, MDKQUAL, NO_DISTINCT_KEYWD,​ ASKQUAL, ASKORDERBY,​ 
-  ​* Automatically add App_Themes directory on first use of OmniSearch (preview only) +                AGGREGATION,​ ASKLINK, ASKRETRIEVAL,​ STARSCHEMA, CACHED_VIEW,​ 
- +                MDKLINK, HDC, REUSEQUAL, NO_ROLLUP, NO_UNRESTRICTEDQUAL 
 +  ​Optimization:​ AGGREGATION 
 +  ​Details:​
  
-===== Build 4.4.02A - Aug 2007 ===== +  Aggregate PROSPECTS using STATE for GROUP(STATE),​ COUNT(*) on 1; 
-==== Moderate ====+  Return PROSPECTS.STATE, COUNT('​*'​);​
  
-  ​* Beta release of Omnidex JDBC Intelligent Router +  ​---------------------------------- NODE02 --------------------------------- 
-  ​* Support for JDK and JRE 1.5 for the Omnidex JDBC driver +  ​Start/​Stop: ​  ​13:​41:​38.238 to 13:​41:​38.629 
-  ​* Translate environment variables in datasources for the Omnidex JDBC+  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:
  
-==== Minor ====+  Aggregate PROSPECTS using STATE for GROUP(STATE),​ COUNT(*) on 1; 
 +  Return PROSPECTS.STATE,​ COUNT('​*'​);​
  
-  ​* Support for nested queries in the FROM clauses within the WHERE clause +  ​---------------------------------- NODE03 --------------------------------- 
-  ​* Optimization of nested queries against partition qualifiers within Union Views +  ​Start/​Stop: ​  ​13:​41:​40.160 to 13:​41:​40.410 
-  ​* Optimization using rollup tables within Union Views +  ​Elapsed: ​     0.250 
-  ​* Improved optimization in Union Views within columns using the DISTINCT_IN_PARTITION option +  ​Request Opt:  PRIKEY, MDKQUAL, NO_DISTINCT_KEYWD,​ ASKQUAL, ASKORDERBY,​ 
-  * Improve memory mapping and exclusive access for files +                AGGREGATION,​ ASKLINK, ASKRETRIEVAL,​ STARSCHEMA, CACHED_VIEW,​ 
-  ​* Fix to avoid processing grouped COUNT(DISTINCT ...) using rollup tables unless all group by columns match the rollup table +                MDKLINK, HDC, REUSEQUAL, NO_ROLLUP, NO_UNRESTRICTEDQUAL 
-  ​* Fix display of counts for OmniSearch ActiveCounts template (preview only)+  ​Optimization:​ AGGREGATION 
 +  ​Details:
  
 +  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;​
  
- +Request Opt:  PRIKEY, MDKQUAL, NO_DISTINCT_KEYWD,​ ASKQUAL, ASKORDERBY,​ 
 +              AGGREGATION,​ ASKLINK, ASKRETRIEVAL,​ STARSCHEMA, CACHED_VIEW,​ 
 +              MDKLINK, HDC, REUSEQUAL, NO_ROLLUP, NO_UNRESTRICTEDQUAL 
 +Optimization:​ NONE 
 +Warnings: ​    ​UNOPTIMIZED_AGGREGATION,​ UNOPTIMIZED_SORT,​ SEQUENTIAL_SCAN 
 +Notes: ​       Optimized aggregations are not possible because no ASK index 
 +                contains all columns 
 +Details:
  
-===== Build 4.4.01C  ===== +Retrieve NODE_RESULTS sequentially;​ 
-====  Moderate ==== +Pass to queue {1} [NODE_RESULTS.STATE, NODE_RESULTS.NEWCOL1]; 
-  * Optimization of nested queries against partition qualifiers in Union Views.  +Sort {1} for GROUP BY [NODE_RESULTS.STATE ASC]; 
-  * Optimization using rollup tables in Union Views.  +Retrieve {1} sequentially;​ 
-==== Minor ====+Return NODE_RESULTS.STATE, CAST(SUM(NODE_RESULTS.NEWCOL1) AS UNSIGNED 
 +   ​INTEGER);​ 
 +------------------------------------------------------------------------------- 
 +> 
 +</​code>​
  
-  ​Fix problems with oastatementinfo in queries against grids (DBUNION rule+===== 5.01.01D July 2010 =====   
 +  ​Added Machine ​(System and UserData 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.01B - Jul 2007 ===== +  ​Under Linux, ​you need to use odbcinst program if you use UnixODBC. Otherwise, you need to manually modify ODBC.INI file.
-==== Moderate ==== +
-  ​Support for the DataAccess ODBC driver on Linux, ​with testing against FreeTDS  +
-==== Minor ==== +
-  * Fixed DSEdit and OdxQuery ​to allow them to work with 4.4.n releases. +
-  * Fixed Omnidex Addin problem with DBUNION (Grid) statements.+
  
 +===== 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.4.01A - June 2007 ===== +===== 5.01.01A May 2010 ===== 
-  +  * Initial 5.01.01A release.
-==== Moderate ​==== +
-  * Optimization of TOP, SKIP, 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.xx, rather 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.+
  
 +==== 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).
  
-===== Build 4.3.4A - Apr 2007 ===== +==== XML versus ENV Catalogs ​==== 
-==== Moderate ​==== +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.
-  ​* Port to 64-bit Linux+
  
-==== 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.1303349809.txt.gz · Last modified: 2012/10/26 14:40 (external edit)