TeraData Overview

What is Teradata?

Teradata is a Relational Database Management System (RDBMS):

• Designed to run the world’s largest commercial databases
• Preferred solution for enterprise data warehousing
• Open, UNIX-MP-RAS or NT-based system platforms
• Compliant with ANSI industry standards
• Runs on single (SMP) or multiple (MPP) nodes
• Database server to client applications throughout the enterprise
• Uses parallelism to manage terabytes of data

Why Teradata?

1) Teradata is the world leader in large scalable data warehousing.

2) Teradata:

• Supports more warehouse data than all competitors combined.
• Supports easy scalability from a small (10 GB) to a massive (100+TB) database.
• Provides a query optimizer with approximately 20 years of experience in large-table query planning.
• Does not require complex indexing schemes, complex data partitioning or time-consuming reorganizations.
• Supports ad hoc querying against the detail data in the warehouse, not just summary data in a data mart.
• Designed and built with parallelism from day one (not a parallel retrofit).
• There are more than 250 1TB or larger warehouses in the field.

Teradata Competitive Advantages:

• Unlimited, Proven Scalability
• Most Concurrent Users
• Unlimited Parallelism - Parallel sorts/aggregations, temporary tables - “Shared-Nothing” architecture
• Mature Optimizer - Complex queries, joins per query, ad-hoc processing
• Model the Business - 3NF, robust view processing, star schema
• Lowest TCO - ease of setup & maintenance, robust parallel utilities, no re-orgs, lowest disk to data ratio, robust expansion utility
• High Availability - no single point of failure, scalable data loading, parallel load utilities

 Teradata—A Brief History:

• 1979 --- Teradata Corp founded in Los Angeles, California.

          Development begins on a massively parallel database computer.

• 1982 --- YNET technology is patented.
• 1984 --- Teradata sells first DBC/1012 to Wells Fargo Bank  of California. Total revenue for year - $3 million.
• 1986 --- Product of the Year!
• 1989 --- Teradata and NCR partner on next generation of DBC.
• 1990 --- First Terabyte system installed and in production.
• 1991 --- NCR is acquired by AT&T. Teradata revenue  $280M.
• 1992 --- Teradata is merged into NCR.
• 1995 --- Teradata Version 2 for UNIX operating systems released.
• 1996 --- NCR only vendor to run multi-user TPC-D Benchmarks.
• 1996 --- AT&T spins off NCR Corporation with Teradata product.
• 1997 --- Teradata database becomes industry leader in scalable data warehousing.
• 1997 --- 100 Gigabyte TPC-D Benchmark leader.
• 1998 --- 24 Terabyte system in production.
• 1999 --- 1 TB TPC-D winner
• 2000 --- 50+ TB system in production! Teradata Division created.