Teradata Database Capabilities - Advanced SQL Engine - Teradata Database

Database Introduction

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
jiv1600056352873.ditamap
dita:ditavalPath
jiv1600056352873.ditaval
dita:id
B035-1091
lifecycle
previous
Product Category
Teradata Vantage™

Teradata Database allows users to view and manage large amounts of data as a collection of related tables. Some of the capabilities of Teradata Database are listed in the following table.

Teradata Database provides… That…
capacity includes:
  • Scaling from gigabytes to terabytes to petabytes of detailed data stored in billions of rows.
  • Scaling to millions of millions of instructions per second (MIPS) to process data.
parallel processing makes Teradata Database faster than other relational systems.
single data store
  • can be accessed by workstation-attached and mainframe-attached systems.
  • supports the requirements of many diverse clients.
fault tolerance automatically detects and recovers from hardware failures.
data integrity ensures that transactions either complete or rollback to a consistent state if a fault occurs.
scalable growth allows expansion without sacrificing performance.
SQL serves as a standard access language for relational database communication. SQL enables users to control data.