Skip to main content

Posts

Showing posts from 2011

Source Tables Made Easy

For our Teiid Designer 7.6 release we introduced a couple of new ways to create new source tables in your relational models.




If you have an existing model that needs a new table, select the model and choose the "New Child > Base Table ..." context action to launch the NewRelational Table Wizard dialog. This wizard contains the options necessary to construct a relational table complete with columns, unique keys and foreign key definitions.





Another new way to create tables is to import an XML input file which you can generate using the new RelationalModel.xsd schema.  Launch the Import wizard and select Teiid Designer's "Designer Text File >> Source or View Models" option.  Then choose the "Relational Model (XML Format)" import type.

Select Next> to get to the file selection page. Browse to select your XML file and select a target model location for your new tables.






When finished your new tables will be displayed in the model's package di…

Teiid Designer 7.6 Final Released

We are pleased to announce Teiid Designer 7.6 is now available.  Feature highlights include:
XML Source Data File Importer - generate relational model xml externally and import to create your relational model. New Relational Table Wizard - Create a new relational table complete with column definition, keys and references in one wizard. New XML Format Relational Model Importer - generate relational model xml externally and import to create your relational model. New Model Extension Definition (MED) Framework - Provides more flexibility to add custom metadata to your models which enables your translators to be more flexible for accessing and exposing your source data. Framework includes a MED Registry View and MED editor.For more see Teiid Designer 7.6 What's New...

See the release notes for more details on the 74 issues addressed.

Download it today....

The Teiid Designer Team

Teiid 7.6 Final Released

We are pleased to announce Teiid 7.6 is now available.  Highlights of 7.6 features:
Procedure language features - Added support for compound/block statements, BEGIN [[NOT] ATOMIC], loop/block labels, and the leave statement. See the reference for more.File Enhancements - the file translator can now optionally (via the ExceptionIfFileNotFound property) throw an exception if the path refers to a file that doesn't exist. The file resource adapter can be configured to map file names and can prevent parent path .. references. See the Admin Guide or the file-ds.xml template for more.TEXTTABLE Enhancements - TEXTTABLE can now parse fixed width files that do not use a row delimiter and can optionally produce fixed values that haven't been trimmed.Temp table transactions - Internal materialized views and temp table usage from a session and within procedures can take advantage of greater transaction support.Buffering Improvements
Added the ability to inline memory based or sm…

Teiid 7.6 CR1

7.6 CR1 is now available.  It fixes issues from the previous betas and contains the following new features: 
View removal hint - the NO_UNNEST hint now also applies to FROM  clause views and subqueries. It will instruct the planner to not perform view flattening. Non-blocking statement execution - Teiid JDBC extensions TeiidStatement and TeiidPreparedStatement can be used to submit queries against embedded connections with a callback to process results in a non-blocking manner. NON_STRICT limit hint - the NON_STRICT hint can be used with unordered limits to tell the optimizer to not inhibit push operations even if the results will not be consistent with the logical application of the limit. Source Hints - user and transformation queries can specify a meta source hint, e.g. SELECT /*+ sh my-oracle:'leading' */ * FROM TBL. The hint information will be passed to the translator. The Oracle translator will by default treat the source hint as an Oracle hint.  See …

Teiid 7.6 Beta1

7.6 Beta1 is now available.  It contains an overhaul of the memory management system, which includes: 
A Fixed Memory Buffer - A serialization buffer will be allocated to increase disk through-put.  It is also managed as a second tier cache.  You may optionally configure the size and set it to use off-heap memory - which is especially useful for dealing with larger amounts (typically 32BG+) of memory from the VM.  The memory buffer also allows for better disk usage based upon fixed allocation blocks vs. the old Teiid scheme which used a file per table/tuple buffer.Concurrent LRFU - the main eviction algorithm was further refined to be concurrent and to better handle table work loads.Numerous Performance Improvements - batch size estimation, serialization, and value type resolution were all improved.You may also now configure query timeout defaults at both the server and per-VDB level.

Now is a great time to provide feedback on any issues or minor enhancements before it's too late …

Teiid 7.6 Alpha1

7.6 Alpha1 is now available and includes the following notable features since 7.5:
Procedure language features - Added support for compound/block statements, BEGIN [[NOT] ATOMIC], loop/block labels, and the leave statement. See the reference for more. File Enhancements - the file translator can now optionally (via the ExceptionIfFileNotFound property) throw an exception if the path refers to a file that doesn't exist. The file resource adapter can be configured to map file names and can prevent parent path .. references. See the Admin Guide or the file-ds.xml template for more. TEXTTABLE Enhancements - TEXTTABLE can now parse fixed width files that do not use a row delimiter and can optionally produce fixed values that haven't been trimmed. Temp table transactions - Internal materialized views and temp table usage from a session and within procedures can take advantage of greater transaction support. Buffering Improvements - Added the ability to inline me…

Teiid 7.5 Final Released

We are pleased to announce Teiid 7.5 is now available.  Highlights of 7.5 features:
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.Additional ANSI support - Teiid and pushdown support was added for SUBSTRING using FROM/FOR syntax, TRIM, EXTRACT, SIMILAR TO, and LIKE_REGEX. See the reference for more.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…

Teiid 7.5 CR1

Adding on more features to 7.5 Beta 2, 7.5 CR1 is released today.  This marks end of new feature work for 7.5. We are planning a quick turn around and releasing 7.5 Final after some testing within next week.

If you are using 7.4 or any prior versions of Teiid, we highly encourage you to download this version of Teiid and validate your test cases and submit any bugs through JIRA. We will try to fix any critical and blocker bugs before the 7.5 Final.

New features in 7.5 CR1

- LDAP Pagination (TEIID-1659)
- Support for 'substring', 'trim', 'extract' functions (TEIID-1694)

If you are looking for new features in Teiid, this would a great time to start requesting and discussing them out in community forums, so that we can plan them for either 7.6 release or 8.0 releases.

Thank you.

The Teiid Team

Teiid 7.5 Beta2

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 pending issues, check out t…

Teiid 7.5 Beta1

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 XML documents to be pro…

Teiid 7.4 Final Released

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 OLAP4JMulti-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 join hint no longer requires the us…

Teiid 7.4 CR1

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 further solidi…

Teiid 7.4 Beta2

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

Teiid 7.4 Beta1

7.4 Beta1 is now available. From 7.3 we've added a host of important features including:
improved dependent/optional join planningimproved memory managementsubquery optimization controlsupport for multi-source proceduresthe uuid/array_get/array_length system functionsthe arraytable table functioncontrol over source query concurrencyvirtual 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

Materializied Views In Teiid

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.

Teiid 7.3 Final Released

We are pleased to announce Teiid 7.3 is now available. Highlights of 7.3 features:Subquery Optimization - added rewrite to INNER JOIN for applicable WHERE clause subqueries. Also added cost based SEMI and ANTI-SEMI join handling for applicable non-pushed WHERE and HAVING subqueries.Updatable ViewsAdded support to perform simple pass-through and more complicated updates through views by default.Added support for "FOR EACH ROW" update procedure handling (similar to INSTEAD OF triggers in other DBMS's), which should be used instead of the deprecated TRANSLATE criteria approach.Temp table enhancements - added support for the SERIAL datatype, which is a not null INTEGER that auto-increments, and the ability to specify a column as NOT NULL.UDF - new API objects added to teiid-api to support user defined functions that are capable of pushdown to source.Unescape Function - a new system function, unescape, was added to handle common \ escaping in strings includ…

Teiid 7.3 CR1 Released

7.3 CR1 is now available for download. From last release of 7.3 Beta1, support for auto-increment IDs for temp tables is added. Also couple caching issues has been resolved when the JBoss AS being run in the "all" profile. When using H2 as the source "boolean" data type was being imported incorrectly, that has been fixed along with few other issues. For more information check out the JIRA issues here.

If you have been putting off 7.3 version so far and working with 7.2-Final, this is time for you to check your usecase with 7.3 version and report any regressions that we might have missed, so that we can fix them before the 7.3 Final is released.

Thank you.

Teiid Team

Teiid 7.3 Beta 1

7.3 Beta 1 refines the delegating translator, changes the default user credentials to user/user, and provides even more Salesforce fixes. See the release notes and updated guides for more. Expect a candidate release soon, so now is great time to validate your fixes and features.

The Teiid Team