Block Level Compression ISAL| Analytics Database 17.20 | Teradata Vantage - Block Level Compression Method ISAL - Analytics Database - Teradata Vantage

Teradata Vantage™ - Analytics Database Release Summary - 17.20 What's New

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-01-30
dita:mapPath
jva1628096041737.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
weq1472245453190
Product Category
Teradata Vantage

Vantage now supports Intel's Intelligent Storage Acceleration Library (ISAL) as a compression method for data block-level compression. ISAL is a fast, ZLIB-compatible data compression algorithm.

Benefits

  • ISAL can provide a significant decrease in CPU resource requirements during compression operations compared to the IPPZLIB compression method. The compression ratio (amount of size reduction) is slightly worse.

Considerations

  • ISAL is compatible with ZLIB/IPPZLIB. In other words, either ZLIB or IPPZLIB can uncompress a datablocks that was compressed using ISAL.
  • ISAL is not the default setting. The default setting is IPPZLIB.

Additional Information

For more information, see:
  • CompressionLevel, CompressionZLIBMethod, COMPRESS, and UNCOMPRESS in Teradata Vantage™ - Database Utilities, B035-1102
  • Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210.