Teradata
By Teradata Corporation
Teradata is a massively parallel processing (MPP) relational database platform designed for large-scale enterprise data warehousing and analytics, originally sold as tightly integrated hardware-software appliances.
Definition
Teradata is a massively parallel processing (MPP) relational database platform designed for large-scale enterprise data warehousing and analytics, originally sold as tightly integrated hardware-software appliances.
Overview
Teradata built its reputation as one of the earliest vendors to prove that a shared-nothing, massively parallel architecture could scale relational SQL queries across many nodes to handle terabytes and later petabytes of data — a foundational idea behind the modern Data Warehouse category. For much of its history it shipped as purpose-built appliances combining proprietary hardware with its database software. Architecturally, Teradata distributes rows across nodes using hashing on a chosen distribution key, allowing query optimization and joins to execute in parallel across the cluster rather than on a single machine — a pattern later echoed by cloud-native warehouses like Amazon Redshift and Google BigQuery. Teradata primarily serves OLAP analytical workloads rather than high-frequency transactional (OLTP) processing. As cloud-native, elastically scaled data warehouses gained traction, Teradata repositioned itself as Teradata Vantage, a software platform that can run on its own appliances or on public cloud infrastructure, competing with modern MPP alternatives such as Vertica and open-source engines like Greenplum.
Key Features
- Massively parallel processing (MPP) shared-nothing architecture
- Hash-based data distribution across compute nodes
- Mature workload management for mixed concurrent analytical queries
- Teradata Vantage software available on-premises and on public cloud
- Advanced SQL engine with strong support for complex joins
- Decades of enterprise data warehousing tooling and ecosystem