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.







CompressTool Features

Some of the key features within CompressTool.

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

© 2002-2024 Atanasoft LLC.