Teradata Compression with the DWHPRO TITHONIZER

Do you work in an environment where a compression tool is installed that works to your satisfaction?

If not, I assume you are probably not very pleased with having to walk your way through the databases, table by table, to find out what to compress on which column. Typically, this is time-consuming, fatiguing and subject to momentary human judgment to some extent.

Every reevaluation is costly again. Often, therefore, Teradata compression activities stop once the largest decile of tables has been treated, leaving a lot of potential unused. I can offer you a solution to this problem:

Teradata Compression with the DWHPRO TITHONIZER

Inspired by the Greek legend persona of Tithonos, whose fate it was to shrink ever more, DWHPRO TITHONIZER determines the best possible and feasible current compression potential for a table, under given constraints and assumptions.

The DWHPRO TITHONIZER can be freely downloaded by all newsletter subscribers. If you are not already subscribed or are an existing subscriber who would like to download the DWH TITHONIZER, please enter your e-mail address at the end of this article. 

DWHPRO TITHONIZER determines set of compression candidate columns and the compression candidate values per column.

It then selects the one combination that achieves the highest savings under the given technical constraints and with the current table demographics.

It can be used for compressing a table for the first time or an update on given compressions.

It does not apply the compression findings directly. Rather, it stored them in a separate table to be implemented at a later stage. This allows you to separate the potentially resource-intense analysis from the application work.  Also, DWHPRO TITHONIZER can be applied to one table in isolation or all of the tables of a database.  This enables you to perform demo or study runs over representative tables before any mass activity.

The core assumption behind DWHPRO TITHONIZER is that it is possible to determine the one combination of compressions over columns that achieves the highest net benefit under the given circumstances and constraints.

It gathers the following information:

Is the table populated by enough rows for compression to have a savings potential at all?

Which columns can be candidates for compression for technical reasons?

Which columns shall be candidates for compression from a business or policy point of view?

Which values, given columns, are candidates?

What is the benefit in saved bytes of compressing one value?

What is the cost of compressing this one value?

What is the Presence Byte consumption of a given compression in total?

For every column, compressed value sets are summarized in levels that represent one Presence Bit consumed each.

Based on this information, a dominant path for compression is determined by ordering the various levels of columns by the “savings per header cost ratio”. Highly frequent level 1 values with little cost in bytes for the table header come first in line. At the other end one will find lengthy and infrequent values with a razor-thin or even no net benefit. After potentially adjusting for net benefit and local Presence Byte break-even points, the dominant path is translated into a series of compression statements that are stored in the result table TITHONOS. From there, alter table statements can be generated to apply the compression.

For a detailed description of DWHPRO TITHONIZER, please refer to the pdf file attached to this article.

I recommend to read it before you start working with the Stored Procedure.

DWHPRO TITHONIZER was developed and tested for Teradata Versions 13 and 14.

The current version offered for download and use here is the first one.  Improvements, refinements or modifications of functionality or methodology will occur as experience with it is gained and time to do it is available.

Feel free to use or modify DWHPRO TITHONIZER for your training or working purposes.

Before you start finding out what the Stored Procedure can do for you, let me remind you that the responsibility for the use of the Stored Procedure and any consequence thereof lies wholly in the hand of whoever uses it.  I am not responsible for any damage, misuse or other negative consequences that emerge out of DWHPRO TITHONIZER applications.

If you have gathered experience, I would be pleased to hear of any results you achieved with it.

[mailpoet_form id=”5″]

Good luck and good results!

Paul Timar

Paul Timar is a graduated Sociologist and Economist who turned Data Warehouse Specialist. He has more than 7 years of experience in working with Oracle and Teradata Data Warehouses in the fields of Social Security Data and Banking. His latest focus is on performance optimization.

  • Avatar jaldrin says:

    I don’t see a link to download this tool. What should I look for?

  • The links will be sent by e-mail if you subscribe, at the end of the post, to the newsletter. If you don’t want the newsletter, tell me and i will send you the links.

  • Avatar Sagar says:


    I would like to see this tool but I can not see it anywhere on this page.


  • Hi. The download link will be sent per email if you subscribe to the newsletter at the end of the post.

  • Avatar Shiv Girijashankar says:

    Please send me the link to the compression tool

  • Avatar Steven says:

    I thought I posted something last week, but nothing there, so here goes again.
    I’m trying to get the stored procedure to run,

    CALL DWHPRO_TITHONIZER(‘DWHProCompression’, ”);

    but keep getting the error:

    Executed as Single statement. Failed [3707 : 42000] DWHPRO_TITHONIZER:Syntax error, expected something like ‘)’ or an ‘EXCEPT’ keyword or an ‘UNION’ keyword or a ‘MINUS’ keyword between a string or a Unicode character literal and the word ‘DWHProCompression’.
    Elapsed time = 00:00:09.503

    STATEMENT 1: CALL failed.

    I’ve tried running through Studio and SQLA, get the same error.
    We are running TD 15.00


  • Avatar Steven says:

    Hi Roland
    Have you had a chance to upload latest version yet, can’t see it ?

  • Avatar sridharan says:

    required for applying complression

  • Avatar amit says:

    Please send me the steps and download link for the compresion. I also sent an email from [email protected]

  • Avatar amit says:


    I am awaiting for the tool link , where i can download and start trying it. I have also sent a message to [email protected]. Can you please help me here.

  • Avatar vipin says:

    Hello All,

    Can you please mail be the Download link and if possible how to use the tool.

  • >