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. 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 deploying Teradata Database.
  • Manual indicates you must install and configure the feature using the Teradata Database documentation, similar to on-premises systems.

The following table does not include Teradata Database features that are enabled by default and are automatically installed and configured, such as Fallback.

Database FeatureDescriptionEnabled by DefaultInstallation and ConfigurationDocumentation
Block-Level CompressionStores 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).

Database Administration
Teradata ColumnarProvides the ability to partition a table or join index by column.

See Release Summary for Teradata Database 14.0.

YesAutomatic

Must be configured.

SQL Data Definition Language - Syntax and Examples
Teradata Intelligent Memory

[Advanced, Enterprise tiers]

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

Can be enabled when deploying Teradata Database.

Automatic

  • Utilities
  • Teradata Intelligent Memory Orange Book
Teradata Row-Level SecurityAllows you to restrict data access by row in the Teradata Database.

See Release Summary for Teradata Database 14.0.

No

Can be enabled when deploying Teradata Database.

ManualSecurity Administration
Teradata Secure ZonesProvides 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 deploying Teradata Database.

ManualSecurity Administration
Teradata TemporalProvides built-in capabilities that are required in a temporal database management system.No

Can be enabled when deploying Teradata Database.

ManualTemporal Table Support

results matching ""

    No results matching ""