TeraData DBA online training in USA, Hyderabad , Canada

1
(No Transcript)
2
Teradata Introduction From RVH Technologies

• Website www.rvhtech.com
• Email info_at_rvhtech.com
• Office 918790137293

3
(No Transcript)
4
So what is Teradata ?

5
What is Teradata?

• RDBMS designed to run the worlds largest
  databases
• Latest Intel technology nodes
• UNIX-MP-RAS, Windows 2003
• Linux in Fall 2005
• Scales linearly from Laptop to MPP
• Has a parallel aware optimizer that
• allows multiple complex queries to run
  concurrently
• Standard access language (SQL)
• Uses a Shared-Nothing architecture
• Unlimited, unconditional parallelism
• Linear Scalability allows for increased workload
  without decreased throughput.

6
Teradata Hardware Architecture

• SMP Nodes
• Latest Intel SMP CPUs
• Configured in 2 to 8 node
• cliques
• Windows, Unix or Linux
• BYNET Interconnect
• Fully scalable bandwidth
• 1 to 1024 nodes
• Connectivity
• Fully scalable
• Channel - ESCON
• LAN, WAN
• Storage
• Independent I/O
• Scales per node
• Server Management
• One console to view the entire system

7
Top Industry Leaders Rely on Teradata
Teradata Top 10

• Leading industries
• Banking
• Government
• Insurance Healthcare
• Manufacturing
• Retail
• Telecommunications
• Transportation Logistics
• Travel
• World class customer list
• More than 800 customers
• Over 1200 installations
• Global presence
• Over 100 countries
• 4,000 world-wide professionals dedicated to data
  warehousing

80 of Top 10Global Telco Firms
60 of Top 10 Most Admired Global Companies
60 of Top 10 Global Airlines
50 of Top 10 Global Retailers
50 of the Top 10 Transportation Logistic Firms
FORTUNE Global Rankings, July 2005
8
The Teradata Difference

• What We Do.
• Enterprise data warehouse
• Windows 2003/Unix/Linux scales from Intel laptop
  to MPP
• Analytic capabilities transform data into
  information.
• Extreme high availability
• Industry leader in analytical applications
• Integration with SAP, Siebel, Hyperion
• Partnerships include Accenture, Bearingpoint,
• CAPGemini, Deloitte, EDS, Lockheed Martin
• Strong customer references
• All we do is Data Warehousing!

9
Industry Awards and Recognition - 2005

• BI Excellence Award
• Sponsor Gartner Group
• Continental Airlines - winner
• Cardinal Health - finalist
• Technology Leadership Award
• Sponsor Frost Sullivan
• Teradata selected for Leadership Award CRM
  Analytics
• TDWI Best Practices Award
• sunrise TDC Switzerland AG winner - Customer
  Relationship Management

• 1to1 Impact Award
• Sponsor Peppers Rogers
• Continental Airlines recognized as Technology
  Optimization winner
• Editors Choice Awards
• Sponsor Intelligent Enterprise
• Teradata selected for theDozen Most
  Influential BI Companies
• Winner, Customer Analytics category
• NEXUS Awards
• Sponsor New Zealand Direct Marketing
  Association
• Bank of New Zealand, silver award - data mining
  analytics bronze award - data management

NEXUS Awards
10
Teradata Solutions Methodology
Project Management
Strategy
Integrate
Analyze
Research
Design
Build
Equip
Manage
Information Sourcing
Technology Neutral Services
Teradatas success is the combination of
hardware, software and methodology
11
Typical Data Warehouse Architecture
Whats wrong with this picture?
3. The solution is too complex. Every line on
the chart represents an ETL process that requires
for Life Cycle Maintenance
Transaction Systems
1. There are too many copies of the data. Will
they all be the same?
Operational Data Stores
Central store, Hub, Clearing house
4. The solution is too expensive. There are
numerous components that lead to increased costs.
Costs often hidden in distributed organization.
2. There is too much latency - too long to get
the data to the people who need it. Everyone sees
different inconsistent points in time
Data Marts
12
Teradatas Enterprise Data WarehouseAn
Integrated, Centralized Data Warehouse Solution
Transactional Users
Transactional Data
Data Transformation
Operational Data Store (ODS)
Optional ELT
Single version of data
Enterprise Data Warehouse
Data Replication
Logical (Views)
Data Marts
Virtual Views
Decision Users
Strategic Users
Tactical Users
Reporting OLAP Users
Event-driven/ Closed Loop
Data Miners
13
TERADATA is an Open System
Virtually any application or middleware framework
can be integrated with TERADATA !!!
Messages
WEB
IIOP
ASP
JSP
JMS
JMS
CORBA
.NET
TAP Appl
EJB
JAVA
ODBC
OLE-DB
JDBC
JDBC
JDBC
Message Bus
TERADATA
TERADATA Utilities
Adapter(s)
Publish Subscribe
Adapter(s)
TERADATA Utilities
Queues
14
Teradatas Real-Time Enterprise Reference
Architecture
Enterprise Users (Browsers and/or Portal)
Legacy Environment
Legacy Environment
C/S
EDI
Consumers
Suppliers
Internal
Partners
EDI
C/S
WAN / VAN
Internet / Intranet
WAN / VAN
Analytic Decision Making Services
Transactional Services
NW
MSG-MW
MSG-MW
MSG-MW
MSG-MW
MSG-MW
MSG-MW
NW
ASP / JSP
TX1 APPL
TX2 APPL
TX3 APPL
TX4 APPL
BI APPL
Tactical APPL
Strategic APPL
BI APPL
Service Brokers
DA-MW
DA-MW
DA-MW
DA-MW
DA-MW
DA-MW
DA-MW
DA-MW
QD
QD
MSG-MW
MSG-MW
MSG-MW
Business Rules
Event Notification
Event Detection
EDW B
EDW A
DA-MW
DA-MW
DA-MW
RS
OLTP1
OLTP2
OLTP3
OLTP4
RDBMS Based Event Processing
Business Process Automation
Streaming
Batch
Analytic Decision Making Repositories
Transactional Repositories
Data Acquisition Integration
15
Teradata High Availability

• Teradata software provides high availability
  beyond other databases
• Compensates for hardware failures
• Automatic failover for dynamicworkload
  rebalancing (migrating VPROCS)
• Online, continuous backup(Fallback)
• Recycles beforethe operating system completes
  its reboot (multi-node system)

BYNET Interconnect
SMP Node1
SMP Node2
SMP Node3
SMP Node4
PE
AMP
PE
PE
AMP
PE
PE
PE
PE
AMP
PE
AMP
AMP
AMP
AMP
AMP
AMP
AMP
AMP
AMP
AMP
AMP
AMP
AMP
16
Teradata Dual Active Systems

• Benefits
• Dual System Solution
• Recovery in Hours or Less
• Increase Processing Power
• Return on Investment for all systems
• Dual Load of Source
• Same Performance as single loading
• Resource Efficient
• Flexible
• Scalable
• Query Director
• Workload Balancing to maximize Business Value

Query Director
Teradata System A
Teradata System B
Source and ETL Updates
17
Teradatas Multidimensional Scalability (Its
more than just big data)
18
EDW Requires Multi-dimensional Scalability
Data Volume (Raw, User Data)
Mixed Workload
Query Concurrency
Query Complexity
Data Freshness
Schema Sophistication
Query Freedom
Query Data Volume
19
The Teradata DifferenceMulti-dimensional
Scalability
Data Volume (Raw, User Data)
Query Concurrency
Mixed Workload
Competition Scales One Dimension at the Expense
of Others Limited by Technology!
Teradata can Scale Simultaneously Across Multiple
Dimensions Driven by Business!
The Teradata Difference!
Query Complexity
Data Freshness
Schema Sophistication
Query Freedom
Query Data Volume
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23

• Contact Information
• Website www.rvhtech.com
• Email info_at_rvhtech.com
• Contact No 918790137293