Image

CompressTool

The Ultimate in Teradata Multi-Value Compression Analysis

Available in

Before AtanaSuite CompressTool, applying Teradata multi-value compression to your Teradata warehouse or appliance was a manual, time-consuming, error prone process typically performed by expensive Teradata experts with Excel spreadsheets and calculators. With AtanaSuite CompressTool, this tedious, time-consuming, and expensive manual process is eliminated and replaced with an extremely powerful and precise compression algorithm wrapped in a simple, easy to use product that all Teradata users can understand and utilize.

AtanaSuite CompressTool can instantly save hundreds, even thousands of GB of valuable data warehouse space while increasing query performance!

Save Space, Save Time, Save Money and Increase Performance with AtanaSuite CompressTool!

Let AtanaSuite CompressTool analyze your entire warehouse and squeeze every little bit of value out of it.

Using AtanaSuite CompressTool is as easy as drag-n-drop - select the tables and columns to go after, specify a few options and AtanaSuite CompressTool does the rest. It identifies your current settings, it analyzes the existing data, it makes recommendations on compression and data type changes, it provides complete application scripts and it will even apply your selected recommendation automatically!

Tool Screenshots

Screenshots of CompressTool in action.

Key Features

Some of the key features found in CompressTool.

CompressTool Screenshots

Click on an image below to expand.

Image

Selection

Image

Options

Image

Recommendations

CompressTool Features

Some of the key features within CompressTool.

Badge ImageAdvanced Compression Analysis Algorithm
Takes into account Teradata release specific limitations and capabilities as well as other special considerations like table header size and row presence bits to deliver the most optimum compression and data type change recommendations.
Badge ImageData Type Filtering
Easily include or exclude certain data types for compression analysis consideration.
Badge ImageTable Minimum Savings Threshold
Specify a table minimum threshold and have CompressTool exclude any tables that do not meet the specified savings percentage.
Badge ImageComplete Data Sampling Support
Quickly get an idea of what compression can do for a table by utilizing this feature.
Badge ImageDetailed and Commented Recommendation Scripts
Complete, detailed and commented recommendation scripts including original table DDL and even handling related objects and permissions.
Badge ImageMultiple Recommendation Application Scripts
Choose from a variety of application scripts provided to apply the compression recommendation. Several scripts generated to create a new table or replace the existing table with or without data and even includes an Alter statement script for versions of Teradata that support it.
Badge ImageMultiple Results Display Options
Multi-column grouping, filtering, ordering and sorting provide all the necessary features for individually customizing the operation results display.
Badge ImageSimple Table and Column Selection
Simply drag tables and columns into the selected area to include in compression analysis.
Badge ImageSpecial Cost Savings Calculation
Immediately determine your cost savings by applying AtanaSuite CompressTool recommendations.
Badge ImageMultiple Data Analysis Methods
Choose between the traditional table query approach or use the latest statistics collection method.
Badge ImageColumn Minimum Savings Threshold
Specify a column minimum threshold and have CompressTool exclude any columns that do not meet the specified savings percentage.
Badge ImageAutomatic Table Header Size Calculation
AtanaSuite CompressTool can automatically calculate the table header size for you!
Badge ImageAuto Apply
Have AtanaSuite CompressTool automatically apply the selected recommendation script.
Badge ImageMultiple Summary and Detailed Results
Current settings, data analysis and recommendations displayed in easy to navigate results display. Use the summary to get a high-level view of information and then select specific items for more in-depth review and analysis.
Badge ImageTool-to-Tool Integration
The AtanaSuite environment is designed to help get you to the right tool for the job by providing toolbar buttons that enable context aware loading of information from one tool to another.
Badge ImageCustomizable Database and Table Display
Modify preferences to include size information for even quicker selection of databases and tables.
Badge ImagePerformance Optimizing Features and Options
From sampling to batching, AtanaSuite CompressTool has the most performance tuning features and options to get the needed analysis and recommendations delivered and applied!
Badge ImageMultiple Compression Analysis Options
Display selected table current settings, perform data analysis and make compression recommendations options are provided.
Badge ImageData Type Change Analysis
Several data type change options provided to consider as part of compression analysis to save the most amount of space possible. Select the options and let AtanaSuite CompressTool do the work!
Badge ImageCompression Analysis Progress Log
Window displays analysis, recommendation calculation and script generation progress.
Badge ImageResults Export
Available throughout the product that provides exporting results to the most popular formats including Excel.
Badge ImageActive Script Enabled
Save commonly executed operations as an AtanaSuite Active Script job that can be opened later within JobTool for scheduling, execution and modification.

AtanaSuite

AtanaSuite is a proven leader in development, management, query, visualization, compression and synchronization productivity products for popular databases including Teradata and Vantage!