1.0 - Teradata SQL Engine - Teradata Vantage

Teradata® Vantage User Guide

Teradata Vantage
Release Number
January 2019
English (United States)
Last Update

Teradata SQL Engine (SQL Engine) includes embedded analytic functions supporting high-speed analytics processing required to operationalize analytics. It is the most comprehensive SQL Engine with the highest available and resilient data platform in the industry.

SQL Engine is designed for decision support. It handles complex data requirements and manages the data warehouse environment through the use of a parallel implementation that automatically distributes data and balances workloads. Parallel processing is an efficient method of handling complex tasks like ad-hoc queries, as it breaks a task into smaller subtasks that are managed concurrently by multiple work units. The support of query and workload parallelism in the SQL Engine enables better performance and higher throughput levels as a relational database management system (RDBMS).

Highly Resilient Data Management

SQL Engine provides scalability by adding node interconnect capabilities through the Teradata BYNET®. Each processor node running the powerful BYNET software is connected to the dual high-speed Infiniband™, interconnecting to each other to form a loosely-coupled, massively parallel processing (MPP) architecture that is managed as a single system. This approach provides the foundation for linear scalability in Teradata systems. A Teradata system is scalable to thousands of physical processors and tens of thousands of virtual processors (VProcs) from an initial single, two-processor node environment.

SQL Engine supports data warehouse solutions from entry-level to massive enterprise data warehouses (EDWs).

In-Database Analytics

SQL Engine has the ability to run path and patterning, time series and model scoring functions for decision trees. The in-database analytics combined with the data management capability, results in high performance and quick decision making.