Teradata Database Features - Teradata Software for AWS

Teradata Vantage™ on AWS (DIY) Installation and Administration Guide

Product
Teradata Vantage on AWS
Release Number
5.08
Published
November 2018
Language
English (United States)
Last Update
2018-11-07
dita:mapPath
upc1519757374969.ditamap
dita:ditavalPath
TeradataAWS_PubCloud_5.08.ditaval
dita:id
B035-2800
lifecycle
previous
Product Category
Cloud

Teradata Software for 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 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. Yes for EBS storage. Automatic for EBS storage.
  • Teradata® Database Release Summary for Teradata Database 14.0
  • Teradata® Database Administration
No for local storage. Manual for local storage (not recommended).
Columnar Provides the ability to partition a table or join index by column. Yes Automatic; must be configured.
  • Teradata® Database Release Summary for Teradata Database 14.0
  • Teradata® Database SQL Data Definition Language - Syntax and Examples
Intelligent Memory

[Advanced, Enterprise tiers only]

Speeds query performance and maximizes system memory by ensuring the most frequently used data is kept in memory.

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

No1 Automatic
  • Teradata® Database Release Summary for Teradata Database 14.10
  • Teradata® Database Utilities
  • Teradata® Intelligent Memory Orange Book2
Row-Level Security Allows you to restrict data access by row in the Teradata Database. No1 Manual
  • Teradata® Database Release Summary for Teradata Database 14.0
  • Teradata® Database Security Administration
Secure Zones Provides grouping of user and database hierarchies into separate database partitions with restriction of user access to one or more zones. No1 Manual
  • Teradata® Database Release Summary for Teradata Database 15.10
  • Teradata® Database Security Administration
Temporal Provides built-in capabilities that are required in a temporal database management system. No1 Manual Teradata® Database Temporal Table Support
1Can enable when deploying Teradata Database

2 To find an Orange Book, go to https://access.teradata.com, log in, and search for the book title.