CompressTool

CompressTool

The Ultimate in Teradata Multi-Value Compression Analysis

CompressTool may be added to the following products


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!

CompressTool Screenshots

Click on an image below to expand.

CompressTool

Selection

CompressTool

Options

CompressTool

Recommendations

CompressTool Features

Some of the key features within AtanaSuite CompressTool

Feature
Advanced 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.
Feature
Data Type Filtering
Easily include or exclude certain data types for compression analysis consideration.
Feature
Table Minimum Savings Threshold
Specify a table minimum threshold and have CompressTool exclude any tables that do not meet the specified savings percentage.
Feature
Complete Data Sampling Support
Quickly get an idea of what compression can do for a table by utilizing this feature.
Feature
Detailed and Commented Recommendation Scripts
Complete, detailed and commented recommendation scripts including original table DDL and even handling related objects and permissions.
Feature
Multiple 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.
Feature
Multiple Results Display Options
Multi-column grouping, filtering, ordering and sorting provide all the necessary features for individually customizing the operation results display.
Feature
Simple Table and Column Selection
Simply drag tables and columns into the selected area to include in compression analysis.
Feature
Special Cost Savings Calculation
Immediately determine your cost savings by applying AtanaSuite CompressTool recommendations.
Feature
Multiple Data Analysis Methods
Choose between the traditional table query approach or use the latest statistics collection method.
Feature
Column Minimum Savings Threshold
Specify a column minimum threshold and have CompressTool exclude any columns that do not meet the specified savings percentage.
Feature
Automatic Table Header Size Calculation
AtanaSuite CompressTool can automatically calculate the table header size for you!
Feature
Auto Apply
Have AtanaSuite CompressTool automatically apply the selected recommendation script.
Feature
Multiple 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.
Feature
Tool-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.
Feature
Customizable Database and Table Display
Modify preferences to include size information for even quicker selection of databases and tables.
Feature
Performance 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!
Feature
Multiple Compression Analysis Options
Display selected table current settings, perform data analysis and make compression recommendations options are provided.
Feature
Data 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!
Feature
Compression Analysis Progress Log
Window displays analysis, recommendation calculation and script generation progress.
Feature
Results Export
Available throughout the product that provides exporting results to the most popular formats including Excel.
Feature
Active Script and Server Enabled
Save commonly executed operations as an AtanaSuite Active Script job that can be opened later within JobTool for execution and modification. Purchase AtanaSuite Active Server and take advantage of its centralized job repository, scheduling, execution, monitoring and reporting features.