Teiid

7.5 Beta2 is now available with new features and numerous fixes since beta1.  Highlights include: Window function support - Teiid and pushdown support was added for SQL 2003 OLAP window functions. The analytical ranking functions RANK, DENSE_RANK, and ROW_NUMBER were also added. See the reference for more. ODBC Cursors - added the capability to use "UseDeclareFetch" with ODBC. This enables users to read results in batches, which is especially useful when dealing with large row counts. Internal Materialized Views Distributed Refresh - When a internal materialized view is refreshed at one node, an event is issued to all other nodes in the cluster to asynchronously fetch the new contents. Sync at Start - When a node is restarted in a cluster, at end of start cycle Teiid will asynchronously fetch the cached internal materialized view contents from other nodes. As always see the release notes for more. For even more detailed information on these or any pendin...

7.5 Beta1 is now available. While mainly a fix release, there have been notable features since 7.4: Subquery optimization control - added the DJ hint to indicate that a subquery should be the independent side of a dependent join. MAKEIND Hint - The MAKEIND hint can be used to indicate that the other side of the join should be made dependent. ODBC SSL - added support for SSL encrypted ODBC connections. Reauthentication Statement - SET SESSION AUTHORIZATION can now be used to perform a reauthentication via JDBC or ODBC. Pluggable Authorization - an alternative PolicyDecider can be defined in the teiid-jboss-beans.xml file to customize authorization decisions. Streaming XQuery - in situations where document projection applies if the XMLQUERY/XMLTABLE path expressions meet certain conditions, then the incoming document will not only be projected, but the independent subtrees will be processed without loading the entire document. This allows for nearly arbitrarily large ...

We are pleased to announce Teiid 7.4 is now available.  Highlights of 7.4 features: Virtual procedure out params - virtual procedures can now have RETURN/OUT/INOUT parameters to return values. OLAP - OLAP translator is now part of the Teiid kit using OLAP4J Multi-source procedures - multi-source handling was expanded to cover stored procedure execution. See the Reference for more. Function Support - additional system functions were made available. uuid was added to generate type 4 UUIDs and the Hibernate dialect was updated to support the GUIDGenerator. array_get was added to extract values from java.sql.Array or java array values. array_length was added to get the length of java.sql.Array or java array values. ARRAYTABLE - the ARRAYTABLE table function was added to simplify array value extraction into a tabular format. Ingres - Ingres database translator is now available to use as supported source under Teiid. Optional Join Enhancements - the optional joi...

7.4 CR1 is now available. Notable features since beta3: Security Improvements - UDF and pushdown functions can now be protected with data roles. Also the CommandContext can provide the Subject for custom security checks in UDFs. Cache Invalidation - Prepared plan and result set caches have will invalidate entries based upon metadata and data changes respectively. See the cache configuration maxStaleness setting and the Admin and Developer Guides for more. Runtime-updates of Metadata - ALTER statements have been added to change view/procedure/INSTEAD OF trigger (update procedure) definitions. A CREATE TRIGGER statement is also available to add an INSTEAD OF trigger (update procedures) to views. System procedures were added to set extension metadata and stat values. By default all effects of metadata updates happen only on running vdbs across the cluster. To make the changes persistent see the Developers Guide Runtime Updates section. The pg ODBC layer has also been furth...

7.4 Beta2 is now available. Notable features since beta1: improved dependent join processing through in predicate splitting and parallization threading improvements for the ODBC transport and local connections the more scalable enhanced sort join replaces the partitioned sort join As always see the release notes for more. For even more detailed information on these or any pending issues, check out the JIRA issues here . Please check any of your issues that have been resolved and log new ones before it's too late to hit the release. The Teiid Team

7.4 Beta1 is now available. From 7.3 we've added a host of important features including: improved dependent/optional join planning improved memory management subquery optimization control support for multi-source procedures the uuid/array_get/array_length system functions the arraytable table function control over source query concurrency virtual procedure out/return/in_out params (requires a pending Teiid Designer 7.4 milestone) There is also new source connectivity with an OLAP translator and Ingres/InterSystems Cache JDBC translator variants. As always see the release notes for more. For even more detailed information on these or any pending issues, check out the JIRA issues here . Please check any of your issues that have been resolved and log new ones before it's too late to hit the release. The Teiid Team

Teiid supports various kinds of caching Caching of final results of a user query, called "result set" caching. Caching contents of a virtual table, called "materialized views". This article is a practical "How To" guide for users who want to use "Materialized Views" in their use-case to improve the query performance. For more information about caching in the Teiid please consult " Caching Guide ". http://community.jboss.org/docs/DOC-16397 Thank you for using Teiid .