Teradata Database Features

Teradata Database on AWS offers many Teradata Database features including, but not limited to, those listed in this topic. Not all features listed below are included in all Teradata Database tiers. See Teradata Database License Tiers. Although the package is included in the Teradata Database AMI, you still need to install and configure it.

The following terms are used in the table below:
  • Automatic indicates you do not have to install or configure the feature and can begin using it after launching a Teradata Database instance.
  • Manual indicates you must install and configure the feature using the Teradata Database documentation, similar to on-premises systems. Features that require Teradata Customer Support to enable a feature are noted.

The following table does not include Teradata Database features that are enabled by default and are automatically installed and configured. Fallback is mandatory for all Teradata Database license tiers and cannot be disabled.

Database Feature Description Enabled by Default Installation and Configuration Documentation
Block-Level Compression Stores data blocks in compressed format to save storage space and improve performance.

See Release Summary for Teradata Database 14.0.

Yes for EBS storage.

No for local storage.

Automatic for EBS storage.

Manual for local storage (not recommended).

Teradata Database Administration
Fallback Protects data in case of AMP vproc failure.

See Introduction to Teradata.

Yes Automatic SQL Data Definition Language Syntax and Examples
Teradata Columnar Provides the ability to partition a table or join index by column.

See Release Summary for Teradata Database 14.0.

Yes Automatic

Must be configured.

SQL Data Definition Language Syntax and Examples
Teradata Intelligent Memory Speeds query performance and maximizes system memory by ensuring the most frequently used data is kept in memory.

See Release Summary for Teradata Database 14.10

All instance types that run Teradata Database support the minimum memory of 5 GiB or higher per AMP except for m4.4xlarge.

No

Enable when launching a Teradata ecosystem or launching components separately for Advanced and Enterprise tiers.

Automatic

  • Utilities
  • Teradata Intelligent Memory Orange Book
Teradata Row-Level Security If purchased, allows you to restrict data access by row in the Teradata Database.

See Release Summary for Teradata Database 14.0.

No

Can be enabled when launching a Teradata ecosystem.

Manual Security Administration
Teradata Secure Zones Provides grouping of user and database hierarchies into separate database partitions with restriction of user access to one or more zones.

See Release Summary for Teradata Database 15.10.

No

Can be enabled when launching a Teradata ecosystem.

Manual Security Administration
Teradata Temporal Provides built-in capabilities that are required in a temporal database management system. No

Contact Teradata Customer Support to enable (Base, Advanced, and Enterprise tiers only).

Manual Temporal Table Support

results matching ""

    No results matching ""