teradata technology leadership and innovation

Teradata Leadership and Innovation

2

• Teradata Corporation > Global Leader in Data Warehousing

– Data Warehouse Appliances– Enterprise Data Warehouse– Innovative Database Technology– Analytic Solutions

> Started in 1979, Acquired by NCR in 1991, Spun off October 2007> The Leader in Gartner’s Leaders Quadrant

in data warehousing since 1999

• NEW Affordable Appliances > Simple

– Easy to Use– Delivered ready to run with rapid time to value– Long term experience and integration with third party tools

> Powerful– Leveraging the Latest Advances in Open Industry Standard Components – Best Analytic Performance in the Industry

> Affordable– Competitive price point– Innovative packages for rapid time to value


3

The Best Database for

Analytics


Analytics

Leverage unmatched

performance, scalability,

and manageabilit

y

Leverage unmatched


and manageabilit

y

Architectural Flexibility


Meet your requirements

with any architecture, price point, and data

model



model

Integrated Analytics


Discover smarter insights

faster using superior in-

database and analytical processes




Superior OperationalExecution


Drive faster front line

actions with better, more

relevant insights



relevant insights


4


Analytics


Analytics

Leverage unmatched


and manageabilit

y

Leverage unmatched


and manageabilit

y





model



model













relevant insights



relevant insights


5

Teradata – The Clear Data Warehousing LeaderLeadership in Execution and Vision

Ability to Execute

Completeness of Vision

Gartner Magic Quadrant for Data Warehouse DBMS, 2010

The Magic Quadrant is copyrighted 28 January 2011 by Gartner, Inc. and is reused with permission. The Magic Quadrant is a graphical representation of a marketplace at and for a specific time period. It depicts Gartner's analysis of how certain vendors measure against criteria for that marketplace, as defined by Gartner. Gartner does not endorse any vendor, product or service depicted in the Magic Quadrant, and does not advise technology users to select only those vendors placed in the "Leaders" quadrant. The Magic Quadrant is intended solely as a research tool, and is not meant to be a specific guide to action. Gartner disclaims all warranties, express or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

6

Self Managing

Self Managing

Virtual OLAPVirtual OLAP

In-DatabaseAnalytics

In-DatabaseAnalytics

GeospatialAnalysis

GeospatialAnalysis

Real-TimeBI

Real-TimeBI

TemporalAnalysisTemporalAnalysis

Teradata 13

IntelligentScanningIntelligentScanning

SmartOptimizer

SmartOptimizer

The Highest Performing Analytical Engine

7

Teradata - Parallel Everywhere!Predictable, Scalable Performance

Teradata

loader

Master nodebottleneck

loader

2-tierbottleneck

“Intelligent”Storage

DatabaseSoftware

HostNode

Enabling business growth and success!

8

Automatic Built-In

Functionality

Fast Query Performance

“Parallel Everything” design and smart Teradata Optimizer enables fast query execution across platforms

Quick Time to Value

Simple set up steps with automatic “hands off” distribution of data, along with integrated load utilities result in rapid installations

Simple to Manage DBAs never have to set parameters, manage table space, or reorganize data

Responsive to Business Change

Fully parallel MPP “shared nothing” architecture scales linearly across data, users, and applications providing consistent and predictable performance and growth

Easy“Set & G0”

OptimizationOptions

Powerful, Embedded Analytics

In-database data mining, virtual OLAP/cubes, pre-built and custom application objects (User Defined Functions) drive efficient and differentiated business insight

Advanced Workload Management

Workload management options by user, application, Threshold and Filters

Intelligent Scan Elimination

“Set and Go” options reduce full file scanning (Primary, Secondary, Multi-level Partitioned Primary, Aggregate Join Index, Sync Scan)

Teradata Database – Powerfully Simple

Adaptable Software Solution vs. Hardware Brute Force

9


Analytics


Analytics

Leverage unmatched


and manageabilit

y

Leverage unmatched


and manageabilit

y





model



model













relevant insights



relevant insights


10

Teradata Purpose-Built Platform Family

Data Mart Appliance

Extreme Data

Appliance

Data Warehouse Appliance

Extreme Performance

Appliance

Active Enterprise

Data Warehouse

Purpose

Test/Developmen

t or Smaller Data Marts

Analytics on Extreme

Data Volumes from New

Data Types

Data Warehouse

or Departmental

Data Marts

Extreme Performance for

Operational Analytics

Enterprise Scale for Strategic

and Operational IntelligenceEDW/ADW

Scalability Up to 12TB Up to 186PB Up to 343TB Up to 17TB Up to 92PB

Sub Segment

Departmental Analytics, Entry-level

EDW

Analytical Archive, Deep Dive Analytics

Strategic Intelligence,

Decision Support System, Fast

Scan

Operational Intelligence,

Lower Volume, High Performance

Active Workloads, Real-Time Update,

Tactical and Strategic response

times

11

Teradata Data Mart

Edition

Teradata Express

Teradata Express for Public Cloud

Teradata Express for

Private Cloud

Teradata Agile

AnalyticCloud

Purpose

Test/Development

or Smaller Data Marts

Express for Windows

Express for Amazon EC2 Cloud

Express for VMWare Player

Private Cloud for building elastic data

marts

Scalability Up to 6TB Up to 10GB Up to 1TB Up to 1TB Flexible

Sub Segment

Departmental Analytics, Entry-level

EDW, deploy in production

Free – Used for Customer Evaluation, Testing and

Development

Subscribe to Amazon EC2 Service – Free

from Teradata. Used for Customer

Evaluation, Testing and Development

Free – Used for Customer

Evaluation, Testing and

Development

Deploy Analytic Sandboxes

inside Teradata Data Warehouse using Teradata

Elastic Mart Builder

Teradata Software/Enterprise Analytics Cloud

12

Built for Active Data Warehousing™

• High Active Performance > Optimized for strategic and operational

mixed workloads• Effortless Scalability

> 4096 nodes scalable to 92 petabytes• Operational Availability

> System Availability with Automatic Node Failover and Recovery

• Enterprise Concurrency> Thousands of users, applications,

and events

Teradata Active Enterprise Data Warehouse 5650

13

NodesNine Nodes per Cabinet with Dual Intel Six Core Westmere Xeon Processors

Storage (188) 300GB or 450GB Enterprise Class Drives Per Node

Total User Data Capacity

Up to 92PB

Scalability Scales up to 4,096 Nodes

Availability

Automatic Node Failover, Full Performance Continuity with Hot Standby Nodes, RAID 1, Fallback, BAR, Dual Active Systems

Operating System

SUSE Linux

System Management

Single Operational View Across Complete System

Interconnect Teradata BYNET® V4

Teradata Active Enterprise Data Warehouse 5650

Solution Specifications

14

Up to 18X Overall Performance Improvement• Over Industry Leader – Teradata• Not just one query or load job – Overall!

World’s Fastest Data Warehouse

• Purpose Built for Extreme Performance• Fast and consistent query response

times> When you need to know Now!

• Scan and aggregate millions of rows in less than a second> Hyper Analytics for truly operational

BI

100% Solid State

Drive Appliance

Teradata Extreme Performance Appliance

15

Teradata Extreme Performance Appliance 4600

Target Application Environments

• Hyper analytics for Operational BI> “Beyond near real-time” business environments needing

consistent response to events in sub-second windows> Sense and respond to business-critical events immediately -

when they are most valuable

• Targeted at 100% hot data applications> Blazing fast operational queries > Aggregate millions of rows in one second> Complex analytics at the speed of thought> Super fast data loads

16

NodesNine Nodes Per Cabinet with Intel Nehalem Dual Quad Core Xeon Processors

Storage (72) 300GB Solid State Drives per Cabinet – (8) SSD per node


6.4TB Per Cabinet, 17TB Max System

Scalability Scales up to 24 Nodes (initial certification)

Availability Automatic Node Failover and Recovery (Cliques), Fallback, BAR

Operating System SUSE Linux

System Management


Interconnect Teradata BYNET® over 10 Gigabit Ethernet

Specifications

Teradata Extreme Performance Appliance 4600

17

Ideal for Data Warehouses and Analytical Sand Boxes

Teradata Data Warehouse Appliance 2650

• Simple> Delivered ready to run with rapid time to value> System live within hours, fully staged

and tested

• Powerful> Purpose-built for high analytical performance

– Optimized for fast file scans and heavy “deep dive” analytics

• Affordable> Competitive price point> Easy data and application migration

to a Teradata Active EDW 5650

18

*Nodes Nine nodes per cabinet with Dual Intel Westmere Six Core Xeon Processors

Storage (216) 300GB or 600GB SAS per Cabinet(108) 2TB SAS drives per Cabinet


17.6TB Per Cabinet – 300GB35.2TB Per Cabinet – 600GB68.6TB Per Cabinet – 2TB(0% Compression)

Scalability Scales up to 343TB with 2TB drives

Availability RAID 1 Disk Mirroring, Node Failover with Cliquing, BAR


System Management


Interconnect Teradata BYNET®

*Can configure in 3-node increments

Teradata Data Warehouse Appliance 2650

19

Built for Analyzing Extreme Data Volumes

Teradata Extreme Data Appliance 1650

• Scalable> Can scale from 23TB to 186PB

• Robust Functionality> Purpose built for analytics on

extremely large data sets> Leverages the full BI and data

mining capabilities of Teradata Database

• Cost effective> Price per unit of data meets the

volume driven value of extremely large data analytics

20

The “Extreme” Market Need

Deep Analysis at the Right Cost

• Exponential growth of data volumes driving the need to analyze multiple petabytes> New data and analysis> Moving off-line storage of deep archive

data to on-line for on-demand SQL analysis

• Requires a new approach for data and analysis with inherent lower value per data unit than typical EDW data

21

*NodesTwo Nodes Per Cabinet with Dual Intel Westmere Six Core Xeon Processors

Storage (144) 1 or 2TB SAS Drives per Cabinet


91TB Per Cabinet(0% Compression)

Scalability Scales to 186 PB with 2 TB drives

AvailabilityRAID 1 Disk Mirroring, Optional Fallback Data Protection and Cliquing, BAR


System Management


Interconnect Teradata BYNET®

* Available in Half Cabinet Configurations

Teradata Extreme Data Appliance 1650

22

Ideal for Departmental Data Warehouses and Test and Development Systems

Teradata Data Mart Appliance 560

• Fully-Integrated Design> All components and software come tested and

ready to run

– Single Node, Scales up to 6TBs• Teradata Database 13 Inside

> Easily migrate applications and data to more scalable Teradata platforms

• Low Price Point> Our lowest priced family member

23

NodesSingle node with Dual Intel Six Core Westmere Processors

Storage Up to 72 300GB or 600GB Enterprise-Class Drives per Cabinet


Up to 12TB

Scalability Single Cabinet Design

AvailabilityRAID 1 with Optional Fallback Data Protection, BAR


System Management

Single Node Level

Interconnect Not Applicable

Teradata Data Mart Appliance 560

Solution Specifications

24

Teradata Analytical Ecosystem Overview

25

Cloud

Enterprise DataWarehouse

Data Marts

Star Schema

Active Data Warehouse™

Sand Boxes

3rd Normal Form

Hub & Spoke

Teradata is the only database that does not lock you into a sub-optimal enterprise approach to data architecture, but supports a cross-section of approaches to address all analytical requirements

Trusted Advisor on Your ArchitectureWith Teradata It’s Your Choice

26


Analytics


Analytics

Leverage unmatched


and manageabilit

y

Leverage unmatched


and manageabilit

y





model



model

IntegratedAnalytics

IntegratedAnalytics











relevant insights



relevant insights


27

Business Analytics DriversAnalytics for Everyone

• Analytics complexity is growing

• Analytics is across the enterprise on data silos

• Data is growing at exponential rates

• Increasing adoption of the next generation analytics

• Integration of new data with existing business data is driving big and diverse data requirements

• Timeliness of analytics is a critical dimension of business value

Interaction

The next generation analytic must support diverse data and analytics to optimize decisioning at blazing fast speeds.

Transactions

28


Teradata Integrated Analytics

AdvancedAnalytics

TemporalOLAP

OptimizationGeospatial Big Data

Teradata Database

ApplicationDevelopment

Teradata Open Parallel FrameworkCustomServices

EmbeddedServices

VirtualMachines

AgileAnalytics

DataExploration

QuantitativeAnalyst Mobile BIGIS

Business UsersExecutives

Frontlineworkers

Users


Extreme PerformanceAppliance

Active Enterprise Data Warehouse


Extreme DataAppliance

Data MartAppliance

29


Tools and techniques to accelerate development of analytics

Native temporal support to manage and update time dimension

In-database data labs to accelerate exploration of new data and ideas

Optimized in-database data mining technology from leading vendors, open source and Teradata

Native database geospatial data types and analytics

Build-in multi-dimensional analytics optimization

Partner tools that converts unstructured into structured data for integration and analysis

Visual data exploration to quickly understand and analyze data within the database

AdvancedAnalytics

TemporalOLAP

OptimizationGeospatial Big Data

Teradata Database

ApplicationDevelopment

Teradata Open Parallel Framework

AgileAnalytics

DataExploration

CustomServices

EmbeddedServices

VirtualMachines


Extreme PerformanceAppliance

Active Enterprise Data Warehouse


Extreme DataAppliance

Data MartAppliance


30


• High performance – In-database processing> In-database, high performance environment to run analytics> Optimizes the analytic process by eliminating data movement while

leveraging the parallel processing of the Teradata database engine

• Comprehensive> One stop shop for all analytic capabilities> Application Development, OLAP Optimization, Agile Analytics, Geospatial,

Temporal, Unstructured Analytics, Data Exploration and Advanced Analytics

• Scalable> Ability to integrate multiple subject areas into a single environment for

analytics> Process complex analytics against “big data”

• Open> Ability to extend analytics with customized in-database methods> SAS, IBM SPSS Modeler, KXEN, R, Hadoop, Attensity, Clarabridge,

Information Builders WebFocus, Esri, CoreLogic, Apos, Tableau, Microstrategy, SAP Business Objects, Oracle BI, Cognos, Microsoft and leading solutions

31


Analytics


Analytics

Leverage unmatched


and manageabilit

y

Leverage unmatched


and manageabilit

y





model



model

IntegratedAnalytics

IntegratedAnalytics











relevant insights



relevant insights


32

Teradata Vision

ACTIVE ENTERPRISE INTELLIGENCE™

Integrate & manage data across the enterprise for strategic intelligence

Extend operational intelligence to front-line workers, suppliers, & customers

33

Active Enterprise Intelligence™ An Obvious Trend: More Speed, More Users

Days

Seconds

Strategic Intelligence Operational Intelligence

100’s of Corporate “Knowledge Workers”

1,000’s to 1,000,000s of “Front Line” Operational

Decisions

34


Days

Seconds


• Sales - Product Profitability• Marketing - CRM• Manufacturing -Demand Chain

Management

• Call Center - Customer History• Gate Agent - Event

Notification• Web - Personalized Offers

35


Days

Seconds


Enterprise Data WarehouseBI Tools & reports

Analysis & visualizationPredictive Analytics

EDW Enterprise IntegrationSOA, BPMS, IDEs

Portals/composite applicationsMixed workload management

36

STRATEGIC INTELLIGENCE

Active Enterprise Intelligence™

Plan

INSIGHTSACTION

OPERATIONAL INTELLIGENCEInsights

IntoAction

Results

Intelligence

37


Analytics


Analytics

Leverage unmatched


and manageabilit

y

Leverage unmatched


and manageabilit

y





model



model













relevant insights



relevant insights

Teradata Leadership and InnovationStaying Ahead of the Competition

38

For more information visit ….

http://www.teradata.com/