Skip to main content

Posts

Showing posts from April, 2012

Teiid 8.0 CR1

We're getting close! Teiid 8.0 CR1 is now available for deployment on AS7 7.1.1-Final.  This release adds the following notable features in addition to numerous defect fixes: 
Greenplum Translator - for use with the Greenplum database. Enhanced parse/format pushdown - added more built-in support and extension points for parse/format function pushdown. Added parse/format timestamp handling for SQLServer, Sybase, Oracle, and PostgreSQL. User Defined Aggregates - user defined aggregate functions can be defined via extension metadata, DDL, or connector metadata.   8.1 development will now start in earnest with only high priority fixes still to be addressed for 8.0.  Be sure to log a JIRA is you see something before the final release is cut.

There will be more on user defined aggregates in another post.

The Teiid Team


Teiid User Defined Aggregate Support

Building upon our support for pushdown and non-pushdown user defined scalar functions, Teiid with 8.0 CR1 also offers the ability to specify user defined aggregate functions (UDAF).

UDAFs are useful to extend Teiid's already extensive aggregate function library.  They also allow Teiid to implement the final processing over pushdown aggregation. For partitioned datasets there is no additional work for Teiid to do, but the UDAF may be needed to express custom aggregation to the participating data sources. For non-partitioned datasets single argument UDAFs may be marked as decomposable to indicate that not only can the initial aggregation be pushed down, but that Teiid will perform the final integration/aggregation of results itself. This provides map-reduce like behavior where processing can be performed in parallel on a large number of source systems.

UDAFs are defined similarly to UDFs and share most of the same metadata properties.  Building on the prior post using Dynamic VDB…

Teiid Designer 7.7 Released

The Teiid Designer project team is proud to announce it's 7.7 release is now available for download.

This release has focused primarily on usability improvements which include:
NewGuides ViewSimplifies primary modeling use-cases NewStatus ViewRuntime project analysis and status NewDesigner Cheat SheetsImprovedWeb Service ImporterResults in single queryable view procedureGo from WSDL to testing your VDB in minutesImprovedView Table Creation


(See Teiid Designer 7.7 What's New for details and more screen shots)

Domain Mode Aware Teiid

Teiid 8.0.0.Beta2 is released today with  "domain mode" support provided by JBoss AS 7. This release is based on JBoss AS 7.1.1

So, what does "domain mode" provide to Teiid?

When you have more than one JBoss AS instance in your server farm and if they are started in domain mode, all the configuration options of this server farm can be centrally managed. For example, you can deploy a VDB or create a data source across all the instances, with one single CLI based call.  Teiid extends this configuration concept to deploy the VDBs, Translators across the whole server farm.

Also, when domain mode is combined with "HA (high availability)" profile, one can cluster the JBoss AS server instances that are deployed. Teiid chooses the HA profile as default profile in its "domain-teiid.xml" file. When the Server is started using the "domain-teiid.xml" the distributed caching that is used for ResultSet caching and Internal Materialized caching is au…