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 the feature after a Teradata Database instance is launched.
  • 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.
For more information, including how to install and configure the listed features, see the Documentation column.
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 an AMP vproc failure.

See Introduction to Teradata.

Yes Automatic SQL Data Definition Language Syntax and Examples
Node Level Buffering Use for query row redistribution. Yes Automatic Resource Usage Macros and Tables

See the ResUsageSpma table.

Teradata Columnar If purchased, 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 File System Checksum Used to detect data corruption, you can specify an amount of data used to compute the checksum for a table.

See Release Summary for Teradata Database 15.10.

Yes Automatic
  • Checksum option for DDL: SQL Data Definition Language Detailed Topics
  • Checksum settings in DBS Control: Utilities
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

Contact Teradata Customer Support to enable.

Automatic

Must be configured.

  • 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.

Manual Temporal Table Support
Teradata Workload Management Provides DBAs the ability to manage workloads and includes a comparison of TASM and TIWM features. Yes Automatic
  • Teradata Workload Management User Guide
  • Teradata Viewpoint User Guide

results matching ""

    No results matching ""