What are the new features of Teradata 13.10 ?

Here are few new features of Teradata 13.10
Compression on varchar data type fields

New calendar functions in TD13.10

There are lot of calendar functions introduced in 13.10   which are 

·         day_of_week

·         day_of_month

·         day_of_year

·         day_of_calendar

·         weekday_of_month

·         week_of_month

·         week_of_year

·         week_of_calendar

·         month_of_quarter

·         month_of_year

·         month_of_calendar

·         quarter_of_year

·         quarter_of_calendar

·         year_of_calendar

Compression

1. Multi valued Compression.

This is one of my most favourite functionality in Teradata.  Since its introduction in V2R5, it has gained popularity considering the enormous space savings and reduced I/O in huge data warehouses.

Top keep upto its promise, Teradata has gone one step further to include more data types for compression.

Previously multivalued compression was limited to fixed length columns types.

In TD13.10, some new features in MVC include

- Support for varchar and varbyte

- Longer columns support upto 510 characters. Previously 255 in Teradata 12, 13

2. Algorithmic compression

Users can now write their own compression and decompression algorithms for characters. 

These will have to be implemented in UDF and needs to be tested thoroughly before implementing it in full scale.

There are some samples functions Teradata has provide and can be found in SYSLIB.

TransUnicodeToUTF8, TransUTF8ToUnicode, LZCOMP, LZDECOMP, LZCOMP_L, LZDECOMP_L, CAMSET, DECAMSET, CAMSET_L,DECAMSET_L.

3. Block level compression (applicable to DBA’s, Capacity planners)

BLC is applied at data blocks and allows row data to be stored in datablocks* in a new compressed format.

To enable BLC on tables, new command "COMPRESS" is available in FERRET utility. After BLC is enabled on table, all tows added to table are compressed automatically. Similarly "UNCOMPRESS" command can be used to uncompress packed Data.

BLC is one of most straight forward methods where one doesn’t have to worry about type of data across various columns in table. Row header and internal Teradata structures are also compressed using BLC.

BLC plays major role in saving lot of I/O and Space but at same time it can have some performance implications as more CPU can be utilized to compress and uncompress data dynamically.