Teradata Database

The Best Analytical Database Possible for the Best Decisions Possible

Designed to deliver high performance, diverse queries, in-database analytics & sophisticated workload management

Teradata Database 14

Provides Faster Answers

Get the power you need to make the right decisions - when you need it most. We put over 30 years of real-world experience into developing not only raw power but the most intelligent optimizer and smartest features to process queries and filter data to efficiently respond to any request.

Technical Overview

Reduces IT Effort & Time

This uncomplicated, hands-off solution saves your staff untold hours by continuously runnig a multi-application data warehouse at peak performance.Your IT team will apprecitate Teradata Database's simple set-up, self-managing automation and intelligent design.

Watch E-Brochure

Flexibility to Meet Analytical Needs

Ask any question at any time - from determining complex trends and anomalies in the business to customizing web offers with thousands of short queries. You'll have the flexibility to do it all - all at the same time - with intelligent query processing that supports any physical data model.

Station Casinos: High Stakes

Keep Pace with Growing Business & User Demands

Managing your production environment brings change & challenge as the data in your Teradata system becomes more critical to your business.

Teradata Workload Management

Extreme Performance

By processing only the data required for a specific query - instead of all the data on disk or the rest of the row - you'll get answers faster with less I/O. Together with the built-in parallelism in Teradata Database, this selective column use will upgrade your efficiency.

Introducing Teradata Columnar Whitepaper

Teradata Columnar Datasheet

Dramatic Compression

You can achieve optimal compression with no DBA effort! Teradata Database automatically matches a wide variety of compression mechanisms to the data characteristics and dynamically adjusts as the data evolves over time through new loads.

Teradata Columnar: Pillar of Performance

Teradata Columnar: A Smarter Way To Do Analytics - VIDEO

Integrated into Teradata Database

There are no silver bullets for performance. While columnar technology has been attractive, companies have shied away from columnar databases because they have lacked the capabilities businesses require. With its elegant hybrid design, Teradata Columnar breaks through that barrier by fully integrating columnar and row-based tables within Teradata Database. This allows support of mission-critical applications which depend on advanced workload management, high availability, rich SQL, and in-database analytics.

Row vs. Columns: Why Not Both?

Teradata Columnar Datasheet

New Analytical Dimension, More Detailed History

Gain valuable new insights with a clear view of how things change over time or a snapshot of a single point. From transactions through all dimensions of your business data, you'll have detailed data for an accurate view.

Temporal Dimension Yields Richer Analyses

Faster Time to Value; Improved Data Quality

Reduce the costs and complexities of ETL and data maintenance and bring high quality data to everyone in your organization by implementing a temporal data warehouse. In addition, the time to implement a temporal data warehouse and temporal applications are reduced.

Teradata Database Temporal Option

Full Bi-Temporal Tables & Queries

Things just got simpler! You no longer need complex SQL condition clauses and date fields to model transaction (system) time and valid (real-world) time.

Temporal Processing Delivers

Significantly increase query performance

As part of Teradata’s innovative and comprehensive multi-temperature data management approach, Teradata Intelligent Memory keeps the most frequently used data in memory for rapid query processing.

Teradata Intelligent Memory (video animation)

Teradata Intelligent Memory

Performance of in-memory databases without their cost

By optimizing memory usage, Teradata Intelligent Memory helps enterprises achieve optimal value from their data and data warehouse investment.

No administrator intervention or application changes required

With Teradata Intelligent Memory, the hottest, most frequently used data is automatically and transparently kept in memory for faster query performance, resulting in quicker answers for better decision making and analysis.

“Teradata provides best in class analytic and BI solutions that are used to create significant value for our business.”

Thomas Henry

Senior Director of Corporate Systems, Express Scripts Inc.

CUSTOMER SPOTLIGHT

Express Scripts

Express Scripts (ESI) delivers affordable perscriptions to clients such as public and private employers, managed-care plans and labor unions. Every day ESI deals with a mind-numbing multitude of insurance companies, employer plan sponsors, doctors and patients. Consolidating information on an upgraded data warehouse solution from Teradata and powerful new analytics capabilities from its Beacon application helped ESI detect fraud, reduce costs and continue to provide its trademark high level of service to its richly varied customer base.