What is Teradata's Advanced SQL Engine?
Driving Digital Transformations

Advanced SQL Engine leverages industry-leading Teradata Database which was designed with a patented massively parallel processing (MPP) architecture from ground-up. This allows complex analytics workloads to be broken down and distributed in order to perform as efficiently as possible. Advanced SQL is the foundation that provides the scalability to start small and then expand into an enterprise-wide, mission-critical analytics system.

  • Benefits
  • Features
GET ACTIONABLE ANSWERS FASTER

Enable faster time to business insights — and value — through a rich set of integrated in-database analytics.

TIMELY, ACCURATE INSIGHTS

Analyze data for tactical and operational insights and for complex and strategic insights through massively parallel and linearly scalable analytics engine.

DRIVING ANALYTICS THAT MATTER

Gain insights by integrating structured business transactional data with unstructured data from IoT and edge computing.

ALIGN WORKLOAD AND BUSINESS PRIORITIES

Manage system resources and SLAs based on business priorities while maintaining operational efficiency of the mixed workload system for all users.

MISSION-CRITICAL AVAILABILITY

Run without interruptions using an enterprise-scale system with high-availability and data resiliency features.

TRULY FUTURE-PROOF

Choose any combination of deployment options — on-premises, in the public or private clouds, as-a-service — they all use the same software.

STRONGER RETURN ON INVESTMENT

Keep TCO low with a simple, scalable, and self-managing solution while enabling fast and insightful analytics throughout the enterprise.

ELASTIC PERFORMANCE

Throttle system resources whenever needed, based on business needs and seasonal demands.

INDUSTRY’S FIRST: 4D ANALYTICS

Discover new use cases and insights based on 4D Analytics which integrates when (Time Series and Temporal) and where (Geospatial).

INDUSTRY-LEADING IN-MEMORY TECHNOLOGY

Get the most frequently accessed data fast through Teradata Intelligent Memory. Get answers to your complex questions fast through In-Memory Optimizations. 

SUPPORT FOR MULTIPLE DATA TYPES

Supports multiple data types and structures, ranging from traditional structured data to multi-structured data such as web logs, XML, JSON, and CSV.

SOPHISTICATED WORKLOAD MANAGEMENT

Monitor and manage your mixed workload environment in real time with Teradata Workload Management for maximum efficiency and performance.

INDUSTRY’S MOST INTELLIGENT COST-BASED OPTIMIZER

Run your queries in the most efficient way through Teradata Optimizer, which automatically determines a best plan for accessing, joining, and aggregating tables.

TERADATA QUERYGRID™ SUPPORT

Teradata QueryGrid orchestrates use of multiple external analytic engines and file systems, so users can focus on data and business questions, not integrating systems.

HYBRID ROW/COLUMN DATA STORAGE

Mix and match rows and columns with Teradata Columnar to create the optimum structure matching your data and query patterns.

DATA RESILIENCE WITH FALLBACK PROTECTION

Enjoy a completely protected analytics environment built on Teradata Database.

Analytic Engine Use Cases

FINANCIAL

Get timely, accurate answers by merging customer account information for marketing with diverse geographical and business data, including checking and savings accounts, loans, credit cards, ATMs, and online systems.

RETAIL

Transform an approach by compiling and analyze checkout scanner data. Then, use the information to better answer questions on purchasing, pricing, stocking, inventory management, and store configuration.

MANUFACTURING

Analyze data to map the most efficient way to supply customers, determine price points, and set manufacturing schedules.

TELECOMMUNICATIONS

Leverage revenue, profit, and cost information to gain an edge where analytics matter most—in marketing, revenue accounting, reporting compliance, inventory, purchasing, network management.

HEALTHCARE

Get better informed answers, based on real-time data, to questions about medical cost trend sources, tailored member service, underwriting and managing risk, and evidence-based care.

TRANSPORTATION, DISTRIBUTION, AND LOGISTICS

Optimize assets utilization, reduce operational expenses, and boost revenue margins, and customer services using data analysis.

Teradata Pricing and Deployment Options

Teradata offers four simplified tiers based on workload profiles. Each is bundled with database features, subscription-based licensing, and license portability from on-premises to cloud options. Along with purchasing and deployment flexibility that reduce risk.

  • What’s New

4D Analytics

Vantage combines a variety of analytic capabilities to enhance IoT use cases and make edge computing smarter.

Learn more

Cloud Analytics

We conducted a survey and the largest companies in the world agree—the cloud is the best place to run analytics.

See results

Cloud Momentum

There are multiple improvements to IntelliCloud as-a-service offering, including expanded deployment options, a growing international footprint, and increased platform capabilities.

learn more

  • 4D Analytics
  • Cloud Analytics
  • Cloud Momentum

next section:

Related to Advanced SQL Engine